Viewing 15 posts - 37,486 through 37,500 (of 39,456 total)
The package will run if it is run from a machine with the SQL2000 tools. The client tool DLLs are the ones that have these tasks. If you save the...
May 10, 2002 at 9:26 pm
I've had luck with mapping drives under the SQL User and them being there when the server starts. I think the UNC method is safer, however.
Steve Jones
May 10, 2002 at 9:24 pm
Only gotcha is you need to use the WITH MOVE option if there is any physical path difference.
Steve Jones
May 10, 2002 at 9:22 pm
May 9, 2002 at 9:41 pm
Intersting idea. Not sure I like this over my method :), but it's worth a look. Nice way to obfuscate things if you are delivering code to a customer as...
May 9, 2002 at 4:40 pm
Not sure if any tools do it, though I suspect DBArtisan from Embarkadero will do this. Be easy to write a script to handle this based on table changes though.
Steve...
May 9, 2002 at 4:37 pm
You can use a dynamic properties task in DTS if this is SQL 2000 to change the package based on some value.
Steve Jones
May 9, 2002 at 4:33 pm
I do agree that quick identification can be usefu. One reason why I put the tablename first is so all items relating to the table are close together.
As far as...
May 9, 2002 at 11:33 am
Thanks for the comments. As far as DTS pacakges go, I haven't done enough work in a multi-DBA environment to come up with a good one. I have done the...
May 9, 2002 at 9:25 am
thanks for the followup.
You can also do a "start notepad.exe" to spawn the process.
Steve Jones
May 8, 2002 at 10:43 pm
Not sure. It's an add on and not as stable as the rest of the product. I've had some random errors with it I can't explain as well.
Steve Jones
May 8, 2002 at 10:41 pm
If you backup the log, it contains this information, but you need a tool like Log Explorer to get at it.
Steve Jones
May 8, 2002 at 9:39 am
Not sure, this should be functioning the same. Can you create a new job that only does xp_sendmail and see what happens?
Steve Jones
May 8, 2002 at 9:37 am
Antares has some good points. Another item I had read was each filegroup uses a separate thread, so this can also speed up filegroups, but probably only if you have...
May 7, 2002 at 4:07 pm
It basically needs to stream out of the database. If you get it in a result set, you need to handle it as a stream and not a set of...
May 7, 2002 at 3:59 pm
Viewing 15 posts - 37,486 through 37,500 (of 39,456 total)