I know I'm very late to the conversation, but a few things...

People learn in different ways. Just because there's an article out there describing RAID configurations doesn't mean Joe SysAdmin...

Are both the operating system and SQL Server Enterprise Edition?

This may stop the particular attack but it won't stop all SQL injection attacks. "Blind injection" is actually a phrase used for discovery of a database by taking advantage of...

One way is to query the Information Schema view for such information:

SELECT TABLE_SCHEMA, TABLE_NAME

FROM INFORMATION_SCHEMA.TABLES

WHERE TABLE_TYPE = 'VIEW'

The Service Principal Name (SPN) is for Kerberos authentication (the default authentication mechanism in Active Directory). Basically, if the client attempts a connection using a Windows account and all the...

This is one of those rare cases where cross database ownership chaining may be useful. Are you working in SQL Server 2000 or SQL Server 2005?

Profiler won't show you the CREATE PROCEDURE statement. You can get the execution of the procedure, but not the definition. If you try and run Profiler you'll get something akin...

John Smith (5/9/2008)

---

Regarding to your recommendation on stored procedures, I use them almost everywhere but only few places is more convenient to use inline code. Also the site is password...

The problem is that CREATE LOGIN and ALTER LOGIN won't take the variable. The way around this is to use Dynamic SQL. For instance:

CREATE PROCEDURE dbo.Create_Login

@username sysname

AS

BEGIN

SET NOCOUNT ON

DECLARE @sql...

Your best bet is Books Online that came with SQL Server or is downloadable from Microsoft. SQL Server runs as a service on the Windows operating system and can use...

If you install SQL Server 2000 on a Windows Server 2003 server, you must immediately install at least SQL Server 2000 SP3. Since SP3 is no longer supported, you should...

The database and its security will be carried over, but the login (which is at the server level) will not. Likely you will need to add the login to server...

Unless it is hard-coded to only use the default instance (CRM 3.0 was this way at first), you can fool the application with an alias at the application server. So...

Simpler solution. Set up a DDL trigger which rolls back any changes to the tables you need to protect (you can have it check against another table which has a...

It's a general practice to install the service pack with the virtual node residing on the physical node it was originally installed upon. What we typically do is this:

1 -...