Viewing 15 topics - 259,531 through 259,545 (of 283,959 total)
Topics
Started by
Posts
Last post
Hi, I have 3 tables TBL_MAIN, TBL_A, TBL_B. TBL_MAIN has a primary key PRIM1 and both TBL_A and TBL…
3 replies
A client’s database is highly normalised (master/details) and uses natural composite keys. Th…
9 replies
I have to download a file from remote server using http://FTP. The problem with DTS FTP …
2 replies
I am attempting to verify non clustered indexes that I'm going to drop and recreate in another file…
1 replies
I am having trouble with a transformation that loads data into a table that has an Identity field i…
5 replies
I'm trying to select a bunch of rows but I only want the latest trips (trip_id) for each recor…
4 replies
My network admin fried the box SQL server was on. A new box was built, but now when I try to restor…
3 replies
I do not understand why the following script is returning all values of 1853/01/01 in my destinatio…
7 replies
Before I again attempt to retype my original message for the fourth time... I will drop this …
4 replies
I have generated a DTS pkg that executes successfully when I run it manually but fails when I sched…
7 replies
I am importing a text file with '~' column delimiter and my text has in the file has some format.If…
2 replies
Hi- Given I have a table which contains three foreign key ID's(Primary key int's) - what's the…
3 replies
I am trying to set up an automated way to set up backup jobs using sp_add_job with sp_add_jobstep.&…
6 replies
DECLARE @BackupLoc varchar(50) DECLARE @SQLStr NVarchar(250) DECLARE @Thistable varchar(50) SET @Ba…
1 replies
Hi, I have a server with 4 cpus with 2 gbs and use the minimum plan threshold cost as 5 (defa…
2 replies
Viewing 15 topics - 259,531 through 259,545 (of 283,959 total)