Jared,

For some reason Object ID does not really work.

You can try the following: Select an Event SQLStmtCompleted. Filter by Database ID as you already do, TextData Like %FROM MyTableName%, Text...

I did not have problems even with databases running with compatibility level 6.5 when those databases were already upgraded to 7.0 and my tools were 2000 (version 8). Yes, there...

There is much more to it. Yes, Off-Site storage is the best answer from suggested, but here are other points:

1. 30 days of incrementals is not sufficient in any regulated...

You would also want to read in Books Online about transaction isolation level.

For example an article "Customizing Transaction Isolation Level" it has examples.

Yelena

Do not forget that when you backup or truncate log active transactions are not truncated.  Do

DBCC LOGINFO

What is the status? Is there a lot statuses that are not 0?...

What is the criteria of the progress? Does this procedure works with a cursor and the loops like While ....?

If yes, you can determine a number of loops to be completed and have...

There is a help topic in Office on how to rename or Change My Documnets folder location: just rename in Windows Explorer and copy somewhere.

I did another thing: right-clicked on...

Joe,

Do you have the access to code in the batch file? If yes then do the following:

Suppose the name of your folder is YourFolder. insted of specifying C:\YourFolder path that...

Faisal,

I have no problems exporting and importing registry entries for Registered Servers X but it only works for the same login. For example if I move the registrations ti another...

I have read the recommendations somewhere that if you really had to change accounts in Services applet for example to be able to start services at all you still need to...

I finally installed SP1 for Windowes 2003 and checked the "Incoming Caller Authentication Required' that I can see now. It resulted in more MSDTC error messages like described when running...

Joe,

Why don't you tell us a little bit more about your goal and we will be able to answer you better. What do you mean by running DOS program?

I have...

Hi,

The following class that contains TransactionPerSec counter is documneted:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wmisdk/wmi/win32_perfformatteddata_msdtc_distributedtransactioncoordinator.asp

Win32_PerfFormattedData_MSDTC_DistributedTransactionCoordinator

One can just assume that the type could be similar (NO Garantee). Type for it say uint32. TransactionsPerSec

Important!

We were carried away by the concept of moving files and did not talk about several other important things.

Bruno,  Are you changing the server name? Are you changing the IP...

Bill,

You are sure right about restoring Master. I learned my lesson with restoring Master way back with SQL 6.5. I am a good learner 🙂  When I say I change...