Are there personnel on your team with a strong skillset in these areas? Perhaps doing brown bag lunch sessions will help impart the knowledge. If you've got strong personnel, asking...

The WITH ENCRYPTION doesn't solve your problem with deploying the scripts, however. The WITH ENCRYPTION is used in the CREATE PROC[EDURE] statement (which is in cleartext and subject to modification...

SQLRecon and SQLPing are both by Chip Andrews. SQLRecon is descended from SQLPing and SQLPing2. Therefore, SQLRecon is the preferred tool now.

Also, the osql -L command works based on talking...

So the network access was enabled after the configuration of DTC as a cluster resource (and after the application of the service pack)?

We went back and forth with Microsoft support on this because in Windows 2000, DTC was on the quorum drive. However, the recommended configuration for Windows 2003 is for DTC...

What service pack (operating system) are you on? Also, have you configured DTC for network access?

The patch GRC had available actually came from Ilfak Guilfanov, one of the main developers of IDA Pro. His patch basically modified the .DLL image in memory, removing access to...

Yes. You can remove the BUILTIN\Administrators as a login. However, before you do, make sure the SQL Server service account and the SQL Server Agent service account have logins and...

I don't know if there are any benefits per se to switching it from sa to the service account. In that case it doesn't matter a whole lot, I wouldn't...

_Do_ _It_ _Properly_. Put a DC on the remote site. You've probably got an old PC knocking around of sufficient spec, and what's a Windows 2003 Server licence? £300 in...

Keep in mind the index builds off a column or columns. So you're basically creating a column of user-defined values and indexing that column. In the SQL Server 6.5 and...

1) If the database owner is something other than sa, say it's a Windows account, then that person can do anything he/she wants on the database. For instance, once upon...

Your OS is why you are getting the error. Things are really locked down in Windows Server 2003, unlike Windows 2000. You'll potentially see this on any Windows Server 2003...

Depends on your timeline and motivation. For instance, if you know you're going to need a job in the very near future, MCDBA 2000 would be the answer. However, if...

Not without revealing some sort of information, no. If you were wanting to do a sort order, that's one thing, but if you want to be able to search for...