Look at the events that are available for tracing in the link

http://msdn.microsoft.com/en-us/library/ms186265.aspx

and the filters that can be used at

http://msdn.microsoft.com/en-us/library/ms174404.aspx

Be careful with not tracing too much information, since depending on the...

The OS is Windows 2008 and I'm able to add an account from abc domain in to the xyz domain. I'm also suspecting that this is a AD error, however...

Refer to:

http://www.sqlservercentral.com/articles/Administration/2960/

http://support.microsoft.com/kb/959420

Have you verified that you have the correct version of the patch? There are QFE and GDR versions of these

I don't believe DMV's would give you this information since most of the information the DMV's return is not persisted. The information that you're looking for would have to be...

SQL Server 2008 client tools gives you this information for both SQL 2005 and SQL 2008. Below is the query it uses. You can modify it to retrieve the information...

You can also look up the data itself if there is any columns with date time information.

Another configuration could be

RAID 1 - System (2x146Gb) - Total available 146 GB

RAID 1 - Data (2x400Gb) - Total available 400 GB

RAID 1 - Logs (2x400Gb) - Total available 400...

Not unless you have some kind of auditing setup on the database. You can look at the default trace, but the information in those traces can for a very limited...

I would start with the Upgrade Advisor on the SQL 7.0 instance. You should be at least at SQL 7 SP4 to be able to upgrade.

So was this an AD replication issue?

I'm getting the same "Token" based error when I add a user from a new domain to an existing domain. I've detailed the problem...

See the information at

http://support.microsoft.com/kb/269196

But there are drawbacks of above code.

1. For sql logins it will again and again password, as much times it will be executed. As we are not storing already...

while we're at it, there's also

DR server

Reporting Server

OLAP server (but that would be the same as BI or would it???) 😛

I've set the Lock Pages in Memory before configuring AWE. sp_configure 'awe enabled', 1 gave an error without this privilege.

I suspect that reboot the server in the same breadth as...