We follow the old school "best practice" of setting the number of files to the number of cores and the size of tempdb to 2x the amount of physical RAM....

Does this happen to return anything?

SELECT name FROM syslogins WHERE sid = SUSER_SID ('YourDomain\YourLogin')

Have you verified that the user is setup in the domain SQLSRVR64? Have you tried just scripting it out and running as TSQL? Is your server in the...

Typically I would just give the answer, however, I think this is a good learning opportunity. Just checkout the RESTORE DATABASE syntax and the REPLACE option.

In cases like this, I will start by looking at overall performance. Here are sort of the high level things I do

1) Check overall CPU.

2) If CPU...

Thanks for pointing this out Lowell. The server that I tried this on, just happened to be a 2000 server. Didn't really even pay attention to the version...

The first thing I would probably try is create a simple ODBC connection through the Windows Data Sources. This would at least take everything else out of the picture.

You could always checkout the wait_type and last_wait_type from sys.dm_exec_requests.

However, I would have to ask what the problem is? Is this a performance problem you are looking into?

Network i/o...

Check out this post for decrypting stored procedures.

http://www.sqlservercentral.com/scripts/SQLInsider+Scripts/30622/

Any of the extended system procedures, and any TSQL for that matter, are going to get executed within the context of the current server connection.

However, You can create a server...

It looks like you may have a stored procedure that is attempting to convert dates and the result is an out of range condition. Have you checked the code in...

It looks like 2008 SP2 might fix the problem you are having.

http://support.microsoft.com/kb/954950

I believe this will grow to be a personal preference. We often use the backup/restore method as it doesn't create any downtime. However, you do have to have...

The example provided by ROI is good and will definately get you started. As for how SQL Server does it, I don't know the exact way, but my guess...

I'm pretty sure I ran into a similar problem some months ago and wish, for the life of me, remember what I did to resolve. I want to say...