Do you know what Network Libraries the server is listening on? Is it a full-blown SQL Server or an MSDE install?

Also, you can tell the instance name by examining the...

#1 is much, much easier than #2. #2 there are some articles on, but the term "DBA" now is used for a rather broad set of duties. For instance, in...

If it's adding logins to SQL Server, you'll actually need one additional permission.

Ability to add logins to SQL Server: securityadmin fixed server role.

BTW, the securityadmin fixed server role does have...

Where is this SQL Server located in relation to you? Is it on an internal network with you or are you connecting over the Internet? Also where is your ASP.Net...

And both are failing to register or is it just the one on the AD DC?

Well, @param1 should probably be param1 without the @, but other than that, unless the database has case sensitivity, that follows the basic values. I think I used adParamOutput but...

What is @param1? Did you mean param1?

Also, what happens if you execute the stored procedure in T-SQL with an OUTPUT parameter say through QA? Do you get a value back?

It looks like the file was corrupted then, the main one (the .mdf). based on:

2005-11-20 13:37:10.09 spid10 The header for file 'C:\Program Files\Microsoft SQL Server\MSSQL\data\62NOSP1_Data.MDF' is not...

You'll want to take a look at the following in order to get the databases/security principals moved successfully.

HOW TO: Move Databases Between Computers That Are...

When you look at the local security policy, say a few hours after you make your change, has it reverted back? In other words, the SQL Server account no longer...

Speaking from a SAN/Cluster Administrator perspective, you still have to do the proper planning and deployment with respect to supporting databases, whether they be SQL Server or Exchange. A lot...

It sounds like there may be corruption in the files or files are missing. Are you sure you were able to recover all the files (include any .ldf and .ndf...

The application works by putting osql into a loop. If it detects blocking it dumps it to a file... I suppose you could modify it to send an email, but...

MSSQLServerADHelper only runs when SQL Server needs it to. It doesn't run all the time.

As far as the name... If you run from a command prompt ipconfig /all you'll get...

Microsoft's PSS usually directs you here:

How to monitor SQL Server 2000 blocking (271509)

There is a new tool, called Sherlock, which takes the information from the sp_blocker_pss80...