Viewing 15 posts - 37,306 through 37,320 (of 39,720 total)
Don't think it works. I think you need Outlook or windows Messaging only.
Steve Jones
July 26, 2002 at 11:37 am
detach, backup to tape or another server, reinstall, and then attach.
Steve Jones
July 26, 2002 at 11:27 am
use substring to parse the data into a certain format and build the string that you want. Then use convert.
Steve Jones
July 26, 2002 at 11:25 am
Antares has good information. The best thing is to research and be wary. There are sometimes installation orders as well.
Steve Jones
July 25, 2002 at 4:30 pm
Doing this in a trigger essentially implements 2 phase commit between two servers, what DTC does. If your 2nd server is unavailable or the network is slow, you will not...
July 25, 2002 at 4:28 pm
On server run select @@version and reference here:
http://www.sqlservercentral.com/faq/viewfaqanswer.asp?categoryid=2&faqid=123
Steve Jones
July 25, 2002 at 4:23 pm
Since the logs are sequential, it's nice to have them on their own disk so the heads don't move. Do you currently have data and logs (all databases) on a...
July 25, 2002 at 4:21 pm
You'd have to use scripting and ActiveX to create a reference to the package, then do a save. Not sure how you'd do this from a .dts file.
Steve Jones
July 25, 2002 at 4:17 pm
Not to discount the other work, but I'd capture all T-SQL and then drop into a table. Then delete the select statements.
Steve Jones
July 25, 2002 at 4:14 pm
you'd have to manually spool it, but your question was fragmentation. If so, you have to look at tables.
If you want free space, then that is by database, sp_spaceused
Steve Jones
July 24, 2002 at 4:01 pm
Both and no alerts on mem or cpu.
The cpu can easily peg for moments on a query and I don't want to know it. It usually resolves itself. If it...
July 24, 2002 at 3:50 pm
DMO might be the best way. There are articles on moving logins (and passwords), but there is also a DTS task to do this. To move the master stored procedures,...
July 24, 2002 at 3:48 pm
Viewing 15 posts - 37,306 through 37,320 (of 39,720 total)