Viewing 15 posts - 37,051 through 37,065 (of 39,461 total)
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
Generally they are not indexed. The underlying table indexes are used. If you do choose to index a view, then it builds this index and takes overhead to update it...
July 24, 2002 at 1:54 pm
Items like stored procedure work against the object_id for the table, not the name. If recompiled, they will fix the dependencies.
Steve Jones
July 24, 2002 at 1:48 pm
Show off your vast knowledge in areas that have no relation to the contract. Like football!
Steve Jones
July 24, 2002 at 1:47 pm
Only way I know is to load each and read the header. Probanly can use DMO to do this.
Andy?
Steve Jones
July 24, 2002 at 1:44 pm
Viewing 15 posts - 37,051 through 37,065 (of 39,461 total)