Viewing 15 posts - 166 through 180 (of 395 total)
default properties of MSDTC above should be read as default values
November 9, 2006 at 12:40 pm
Well, it is a good question. I use pretty much same approach and since we have hundreds of SQL Servers, both W2K ( most of it is still...
November 9, 2006 at 12:38 pm
sp_who2 active shows the list of active t/a's, processes and connections running on your server
November 7, 2006 at 11:54 am
If you can isolate your table on physical disk, then you can set a perfmon counters with physical writes\reads for that drive, or you can set a profiler...
November 2, 2006 at 2:39 pm
maybe you should call ms and hardware vendor..?
October 31, 2006 at 3:40 pm
You might want to flip your DB in a Simple recovery mode for completing reindexing.
October 24, 2006 at 12:42 pm
can it be something to do with schema(2005) and dbo rights in 2000?
August 31, 2006 at 11:42 am
"...Stack dumps happen when SQL Server has an error that it cannot handle.
The dumps are designed to be used as a debugging tool for Microsoft.
They can sometimes clue...
August 31, 2006 at 11:38 am
can you start with server - side traces?
August 24, 2006 at 1:38 pm
Would it be of any help to you?:
http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx
August 22, 2006 at 4:27 pm
If checking for DB status, you may want to go that way:
SELECT DATABASEPROPERTYEX ('YourDB','STATUS')
August 16, 2006 at 4:40 pm
can you run profiler ( or rather server-side traces)?
August 11, 2006 at 6:21 pm
you incorporated ActiveX in DTS package. Can't you just pass it in the job as:
DTSRUN /N"ReadFailedJobDTS" /E /SYourServer
August 10, 2006 at 8:33 pm
Is it in the EM by moving Clustered Index to another Filegroup you can also move table ( which has that Clustered index?!)
August 9, 2006 at 4:06 pm
Thinkpath Training (on the Lower Broadway) and New Horizons ( on 42 street) are pretty good...
August 7, 2006 at 2:33 pm
Viewing 15 posts - 166 through 180 (of 395 total)