Hello,

The error message is telling you the truth: You don't have enough space on the C drive to restore the database.   You will need to free up the amount required...

"Drop Database" is the fastest way to get data out of SQL server.

Bill,

Have a look at sp_procoption in BOL.  It will allow you to cause a sproc to run when the SQL instance starts.

From there, you can run msdb..sp_start_job to cause the...

What is the value of the Page Life Expectancy counter in the BufferManager object?  If this stays above 300, it usually means that you have enough memory, no matter how small your...

To elaborate on Tim's initial response:

You will have to create a global variable for this using persistent storage. (A Table)  Ignoring all philosophical/best practice concerns, I will offer a simple...

Have you verified the filesystem permissions?  Does the account running the SQL service have r/w access to the database files after they are moved to the SAN?

Are you getting any error messages?

Do you know the name of the backup software?

Hello,

Have a look at the following sproc:  master.dbo.sp_helpindex

The code in that sproc should point you in the right direction as to what you need to do to get at the index...

I read the question as how do I return two tables that are the same structure as if they were 1 table.

Select * from TableA

UNION ALL

Select * from TableB

jg

Nice job.  Now I don't feel so silly for writing a FORTH interpreter in T-SQL.

jg

When I had an Exchange-free environment, I used BLAT for sending notification mail.  Certainly not a great solution, but it worked well.

http://www.blat.net

jg

The DROPCLEANBUFFERS dbcc command makes SQL server perform like it was just started up, for the most part.  It causes the (page) buffer cache to be invalidated, resulting in everything...

Hello,

Check out...

http://support.microsoft.com/default.aspx/kb/310834

Are you using an MSA1000 by any chance?  I've run across this problem, and the long-term solution was to upgrade the firmware on the SAN.  Can't remember the...

Index away!  Below is a little example of how it behaves.    In QA, select the option to show the execution plan after execution.  Or press ctrl-K and run.

You'll see that...