sql-server

SQL Server 2008 Unique Column that is Case Sensitive.

Is there a way to make a column both UNIQUE and Case Sensitive? I want to be able to put abcde and ABCDE in a unique column. ...

Distributing an application that uses a SQL Server database

If I create a .NET application that uses a small SQL Server database that I create, can I then give that application to other people to run on their PCs even if they're not running SQL Server? If so, is there anything special I have to do in the way I create/distribute it? And are there any special requirements for the PC's it is ins...

SQL reporting service and language problem

I am encountering a problem when attempting to display Hebrew fonts in SQL Server Reporting Services. I see the fonts perfectly in the database, but when displaying the report all the Hebrew fonts displayed as ????? Any suggestions? ...

Configuring james to connect to Microsoft sql server 2005

I'm getting database connection error whenever I try to connect james to sql server 2005, I already loaded driver sqljdbc in the lib directory in james, then why I'm getting an error? Here's the config.xml file of james which is trying to connect to sql server: <data-source name="maildb" class="org.apache.james.util.dbcp.JdbcDataSourc...

How to get around UDF restriction on side-effecting operators?

Microsoft Books Online (BOL) on Using Change Data explains a misleading error messages for cdc.fn_cdc_get_all_changes_* & cdc.fn_cdc_get_net_changes_* when an invalid, out-of-range LSN (Log Sequence Number) has been passed to them. Msg 313, Level 16, State 3, Line 1 An insufficient number of arguments were supplied for the procedure ...

How do you load a 150 kb (kilobyte) text files into sql server 2008?

How do you load 150 kb text files (.aspx, .cs, html, etc) into a sql server 2008 database. I'm able to load all files that are less than 64 kb so far. I have two questions; How do I get around the 64 kb limit, and is the method I'm using the best way to do this? Thanks for the help. Database: file_length int, file_path varchar(2...

Anyway to create a SQL Server DDL trigger for "SELECT" statements?

I am dealing with some sensitive Accounting tables and I would like to audit any SELECT statement executed on the table or any views associated with them. I did not find any DDL Events on BOL (Books Online) that had anything to do with SELECT statement. And DML triggers are for INSERT, UPDATE and DELETE only. Is it possible to log who ...

Exporting data In SQL Server as INSERT INTO...

I am using SQL Server 2008 Management Studio and have a table I want to migrate to a different db server. Is there any option to export the data as an insert into SQL script?? ...

How to import a data from sql server to excel?

I want to get a date from sql server into excel How can i do it manually? ...

Code not working with clustered index

I have an application where the instruction says that it doesn't work with clustered index with more than one field. Couldn't resist testing and it is true. The app gets stuck in some endless lopp if i add a clustered index with 2 fields. I thought the index was something internal to the database that doesn't affect the application. Ho...

batch manipulations for online web app

Hi, A customer has a web based inventory management system. The system is proprietary and complicated. it has around 100 tables in the DB and complex relationships between them. it has ~1500000 items. The customer is doing some reorganisations in his processes and now has the need to make massive updates and manipulation to the data (o...

Setup Http Post Server

I have a mobile application which I want to call a http post to pass a binary string and write it to a SQL Server. Can you please give me some examples of code in setting up a http post server (Server side code) to accept 2 values (brinary string & DeviveID string). Any help, advice or links welcome.... ...

Which is the best way to store text files into a Sql Server data base, for an asp.net mvc web application?

I'm making a small asp.net mvc app. in which I have to compute data from several CSV files ( between 5 to 10 files). The application must provide upload and download actions for these files. The part where I don't have experience is the data base. What column type should I use? text, image, binary ? the size of a file will be betweent ...

30 million records a day, SQL Server can't keep up, other kind of database system needed?

Some time ago I thought an new statistics system over, for our multi-million user website, to log and report user-actions for our customers. The database-design is quite simple, containing one table, with a foreignId (200,000 different id's), a datetime field, an actionId (30 different id's), and two more fields containing some meta-inf...

What is the difference between ";" and "GO" in TSQL (SQL 2008) ?

I use ADO.NET or the sqlcmd utility to send sql scripts to SQL 2008. What is the difference between using ";" and "GO" to separate chunks of SQL? Thanks, NEstor ...

Which SQLCMD.exe to use (x64 or x86) -- SQL Server 2008?

I have SQL Server 2008 installed in a Vista x64 machine. When I look for the sqlcmd.exe, i find 2 versions, the x64 and the x86: C:\Program Files\Microsoft SQL Server\100\Tools\Binn\sqlcmd.exe C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\sqlcmd.exe Which one should I use ? Is there an advantage of using one over the oth...

How to assure that certain data in SQL Server 2008 can only be accessed with my software?

I’m distributing an SQL 2008 database with my c# application (only the data, which I restore in the client’s local SQL server). Is there a way to assure that the client can only access my data by using my application? (and not, for instance, using Management Studio, SQLCMD, etc) Thanks, Nestor ...

Visual Studio 2008 hangs if connection string set incorrectly

When opening a web site in Visual Studio 2008 with SQL Express 2008 on Windows 7 64-bit, it would open fine. In fact, several files would also often open fine. But when opening a particular control, VS would hang. 0% CPU usage reported, but watching the Resource Monitor showed that it was often "Waiting on Network I/O"; not always--somet...

Create new SQLCommand's or reuse the same one

I need to send a list of commands to SQL 2008 using ADO.NET, to be executed one after the other. Should I create a new SQLCommand for each SQL that I'm sending? Or reuse the same SQLCommand and just change the CommandText property? Thanks, Nestor ...

Sql Server: storing text and keeping newlines?

Hi, I suppose this question is kinda easy to answer, but I can't seem to figure it out. I'm trying to store text (email bodies) into a nvarchar(max) column, but when I go read it, the newlines are all gone. At first I thought this might be some encoding/collation problem, but it doesn't seem to be the case. I've searched around and ha...