1) It is likely udp/1434 is blocked. That's the SQL Server Listener service. That means you have to know the port SQL Server is listening on to connect. You would...

The auditor's request makes sense when you look at it from the perspective of, "Is it needed for the production application to run?" In that context, Books Online is unnecessary....

This one is also available on Safari... meaning you can read it on-line and not have to pay full price for the book (also have a subscription to other books)....

I've looked for another post where someone is having the same issue you are. Unfortunately, I'm not finding one. If the local security policy is indeed showing up with the...

And if you did run it, look for sqlsp.log in your %systemroot% directory. That'll tell you how the service pack installation went. But happycat59 is right. If SQL Server 2000...

Can you connect to the server from itself? Say Query Analyzer or Enterprise Manager running on the server? If so, what do the SQL Server error logs say?

If you're on SQL Server 2000 or 2005, use an INSTEAD OF TRIGGER. For instance:

CREATE TRIGGER [insertTrigger] ON dbo.CDSMaster
INSTEAD OF INSERT
AS
BEGIN
  INSERT INTO dbo.CDSMaster
  (CDSID, CDSCode, <... rest...

When you execute an UPDATE STATISTICS statement, SQL Server will look at the values for each index and recalculate the distribution of those values. You typically execute if there is...

Yes. For instance, take the following code:

USE AdventureWorks
GO

CREATE PROC Production.usp_MultipleRS
AS
BEGIN
SELECT * FROM Production.Product;
SELECT * FROM Production.ProductDescription;
END
GO

If you run EXEC Production.usp_MultipleRS from the AdventureWorks database, you'll see two resultsets returned.

If you used the WITH RECOVERY option, the database is brought back on-line for use. After that, no, you can't apply more log files. You need to use the WITH...

A table that will help make this understandable is found in Books Online. It's titled "Switching Recovery Models" and here's how you navigate to it:

Contents tab >>

Administering SQL Server...

Yes. However, it does mean taking the database offline on the first server. Basically, it's like this:

1) Write down what files make up the database to be copied. An easy...

If you can't set up a secure connection either by using SSL Certificates with SQL Server or over an encrypted tunnel like with VPN, you can always resort to transfering...

One other thing. After rebuildm, stop the SQL Server service and start it back up locally in single user mode... That'll ensure no users try to connect as you try...

1) Copy msdb and model databases to a safe location (assuming they aren't corrupted) because otherwise they will get overwritten..

2) Copy "starter" system databases off of the SQL Server CD...