Programming SQL

DTS - SQL Database to Access Database
Hi, I need some help on where I am stucked trying to export the whole SQL Server database into Access database used for analysis. I am trying to do this programmatically for a web app that a user will be able to download the access file into a folder on the web server. The problem is that I want to be able... 10 Dec 2005 01:23

sp_send_cdosysmail with priority
Does anybody know how to set the priority to high? I tried the code snippet below with the sp_send_cdosysmail without any success. Thanks $$$ -- Priority EXEC @hr = sp_OASetProperty @iMsg, 'fields("cdoImportanceValues").Value','2' EXEC @hr = sp_OASetProperty @iMsg, 'fields("CdoPriorityValues").Value','... 6 Dec 2005 12:59

case statement TSQL
I'm trying to do something like the following: SELECT * FROM leads WITH (NOLOCK) WHERE CASE WHEN @lead_id_lookup = 0 THEN lead_id >= @lead_id WHEN @lead_id_lookup > 0 THEN lead_id = @lead_id ORDER ... 6 Dec 2005 01:31

XP_CMDSHELL
I have a DTS that import from Excel in SQL server table some records. If i run the DTS from EM all OK! I want to run the DTS in a Stored Procedure with this command: EXEC MASTER.DBO.XP_CMDSHELL "DTSRUN /S SERVER1 /U sa /P password /N UPKG_IMPORT_EXCEL I have an error -2147467259 Failure creating File W... 2 Dec 2005 10:23

BULK INSERT with leading/trailing quotes
I am using BULK INSERT to load data from some CSV-file into SQL-server 7.0. The files use TAB to seperate fields and NEWLINE to seperate rows. However - we would like to be able to have these characters in the fields themselves, e.g. a TAB or NEWLINE in a field which contain free-text from the users. The st... 29 Nov 2005 06:35

varchar size
Is there any benefit to sizing a varchar in proportion to 2^x. For example, Name varchar(64), Description varchar(256), .... Also, does it help when pulling this data over a network? ... 22 Nov 2005 15:37

CASE statement
Hello, I created a view in SQL Server Express 2005 that contained CASE END statements. I use this view in a .NET 2005 project, which works fine on my machine. When I deploy my project to a machine that is running SQL Server 200, I get the following error: The Query Designer does not support the CASE SQL contr... 22 Nov 2005 15:37

app role
We can use sp_setapprole to enable application role. How to disable the app role? ... 21 Nov 2005 17:48

SQL 2005 Beta : Error with specific table
Hi, I have attached SQL 2000 database to Microsoft SQL Server Beta Edition Ver 9.00.1116 and kept Compatibility Level to SQL Server 2000 (80). While updating a table I am getting error for a specific record "Creating or altering table 'FakeWorkTable' failed because the minimum row size would be 8123, i... 21 Nov 2005 04:44

Correlated subquery question
I'm sure this is well-known to all you experts out there. I found the following on the Net: A frequent question posted on here is something like "How do I list all of my customers along with their most recent order". You can achieve this using a correlated subquery. A correlated subquery is a query within... 4 Oct 2005 10:57