Viewing 15 posts - 25,591 through 25,605 (of 26,487 total)
I am still not sure what your procedure is supposed to do. What is the input and what is the expected (not actual) output from the procedure?
August 6, 2007 at 9:34 am
Brandie,
Actually, I haven't purchased any of the "test help" books. I have quite a few of the MS Press books related to SQL Server 2005 which I rely on, but...
August 6, 2007 at 9:08 am
FTP in DTS is pull only. Once you move to SQL2K5 and SSIS, that changes.
![]()
August 6, 2007 at 8:52 am
What would help even more is sample input data and wha the results of the process should return based on that output.
![]()
August 6, 2007 at 8:48 am
Sometimes, cursors and dynamic sql make sense for a particular job. This may be one of those cases.
![]()
August 6, 2007 at 8:44 am
You should be able to put all that in a script that you run using ftp to rename the file. We did that many times at my previous employer's. Unfortunately,...
August 6, 2007 at 8:37 am
Also, you can have multiple snapshots on a single source database, so, if you have a snapshot of a database at 9:00, 10:00, and 11:00, and you need to revert...
August 3, 2007 at 3:58 pm
You can't access the # temp table after your exec (@sqlcmd) because the # temp table no longer exists, it is dropped after the exec completes. You could change your...
August 3, 2007 at 10:47 am
That may be part of the problem. Do you have the space available on your server to backup directly yo disk and then move the backup file?
August 3, 2007 at 10:09 am
Are you backing up to a local disk or across your network to a network share?
August 3, 2007 at 9:17 am
How big is your database?
August 3, 2007 at 9:10 am
Yes, the SQL Server 2000 and SQL Server 2005 Client tools can coexist on the same system. I have had no issues with this on any of my systems.
August 2, 2007 at 9:14 am
Either that, or just run it at 6:00 AM to import the file created the previous day at 8:00 AM.
![]()
August 1, 2007 at 9:38 am
Would it be possible to get the DDL for the tables (including indexes) and the query in question?
![]()
July 31, 2007 at 4:27 pm
Viewing 15 posts - 25,591 through 25,605 (of 26,487 total)