This is...

It's probably best to create a different set of domain groups. We try to have a set of domain groups per clustered instance. Also, make sure the new disk resource...

Manu is right. Only via a Profiler or server-side trace are you going to be able to see what logs in and what databases are used. SQL Server doesn't record...

Is the database in 80 or 90 compatibility mode? If it's 90, you're in SQL Server 2005 mode, meaning the objects aren't owned, they belong to schemas which are owned....

In SQL Server 2000 you can get the database ID. If you restrict it to just login/logout and minimize the columns to only what you need, it probably won't have...

I just realized a mechanism did get published... Decrypt SQL Server Objects, SQL Server Magazine, August 2007, by Omri Bahat. If you're an on-line subscriber, you can access the SQL...

This means exactly what it says. Look at the event log entries to find the location/name of each occurrence. Your directory services administrator is going to need to delete the...

Database or server? Database is impossible without tracking every SQL statement that goes through. Server is possible through a server trace. You can build that using SQL Profiler. If you...

Likely the registry is being read to determine password policy settings from the operating system. The operating system reads them from the registry, so this is where SQL Server would...

davidthegray (6/16/2008)

---

Examining the code was really interesting to me, because I had never seen such a destructive code put into action. The attacker has some brain, and deep knowledge of...

We tend to use the method specified in the Microsoft KB article. We also script out the logins and store it in a location that gets backed up to tape...

SP2a is 9.00.3042.

Build Info:

SQL Server Version Database

We pretty much follow the Microsoft recommendation. And as far as the cumulatives, there was enough community outcry so SP3 should be...

If you get a subscription to Safari (not the browser from Apple), they have a lot of technical books on-line, including certification books. It's a great resource, especially if you...

The short answer is yes, you can use the passive node. The rule of thumb is to make sure there is enough overhead on all physical nodes such that if...

I believe we're at SP2a (no hotfixes beyond the re-released service pack). However, have your Citrix admin make a call to Citrix support. They should be able to tell you...