Viewing 15 posts - 37,546 through 37,560 (of 39,510 total)
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
v6.5 does have some locking issues in places, especially if you make use of temporary tables.
I'd need more testing, but this doesn't surprise me.
Steve Jones
May 7, 2002 at 3:51 pm
Which exam?
The admin exam is different from the database exam.
I wrote the Sybex book for the database exam so I am biased.
Steve Jones
May 7, 2002 at 2:50 pm
The only way I can think of is to make some utility that will execute BCP or a DTS package and set a row end there. For a data import,...
May 7, 2002 at 1:19 pm
I used DBArtisan and RapidSQL a couple years ago. Nice products, but nothing special over QA. The SourceSafe integration was kind of fuzzy. I used EditPlus for ASP/HTML, and I...
May 7, 2002 at 12:23 pm
Profiler snags an event, I believe when the process starts. The last command, should be in DBCC InputBuffer. Are you sure the spid is still active? It might have timed...
May 7, 2002 at 12:19 pm
Antares has great advice. If you use EM to restore on the new server from backup, you change the path's for the files on the "Options" tab.
Steve Jones
May 6, 2002 at 10:42 am
Viewing 15 posts - 37,546 through 37,560 (of 39,510 total)