In books online (the documentation for SQL Server)

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/24b3311d-5ce0-4581-9a05-5c7c726c7b21.htm

or http://msdn2.microsoft.com/en-us/library/ms177429.aspx

describes step-by-step how to restore a full backup

Regards,

Andras

I'm glad I could help. Concerning books I'd start a new topic, so others could find the answers in the future. There are some book recommendations on the site already,...

Go to Tools->Options->Results->Maximum Characters per column, and set it to a higher number.

Regards,

Andras

A few things to check:

In the SQL Server Configuration Manager under the SQL Native Client Configuration tool could you check that Shared Memory is enabled and it is at the...

In the future, when your server is upgraded to SQL Server 2005 or later, you could use OPENROWSET(BULK ....

Andras

Hi,

What is your SQL Server Service Account set to?

What is the account the service is running as?

Are you specifying ".", "(local)", or a network address in your connection string. (local...

The above parameters should work, but one possible reason for this problem is a simple path setting. You may not actually be executing SQL Server's isql.exe. For example, Firebird has...

Carmen,

You can check what recovery mode you are in with

SP_HELPDB [database name]

Note, that even if you change it to FULL or BULK recovery mode, you will have to perform...

There is not really a "call stack" that you could use to find out what stored procedure caused a particular table update. However, it is executed within the same transaction,...

You can impersonate another user with

SETUSER 'foo'

(on 2005 you should use EXECUTE AS)

Is this what you are looking for?

Andras

Wim is correct about the change to schemas (it is nice to see that MS is embracing another chunk of the SQL Standard )...

As Markus mentioned, you can just enable xp_cmdshell using:

EXEC sp_configure 'xp_cmdshell', 1

However, I'm wondering why you are seeking a replacement. Anyway, in the broader sense there are alternatives to xp_cmdshell;...

Connection timeout and query timeout. These should be set by the client.

Regards,

Andras

In SQL Server 2005 many of the system views are hidden, and you cannot access them using a normal connection. The SQL Server 2000 system tables have been replaced with...

You could achieve this with pivots like:

SELECT [A], , [C]
FROM ( SELECT [Type] FROM [Test]) AS SourceTable
PIVOT (COUNT([Type]) FOR Type IN ([A], , [C])) AS PivotTable

Note that the columns A,...