It could be a no brainer. How many other indexes are there? How many keys? One I hope. No, you cannot do this with out dropping the primary key....

Hope I'm allowed to disagree somewhat. The databases mdf/ldf files including master, model, and msdb should be installed on drives seperate from the OS and SQL Server applciation. That said,...

My pleasure

John Zacharkan

Open the DTS package right click on package click on properties. Setup up your error handling here. If you need more info create a workflow on error branch and have...

quote:

---

The next question is this: what parameter do you use for sp_delete_backuphistory? In other words, how long a history do you...

try Books online

John Zacharkan

one stupid question, Do you have a job that is running the following somwhere? Might want to review the parameters being passed.

exec msdb..sp_delete_backuphistory @oldest_date

John Zacharkan

Right click on SQL Server Agent, click properties, under job systems is there a set limit in the job history. You might need to increase this.

See what is reporting....

All of these are great ideas, but why not just cycle the server? One the scariest things I know of is approaching a box that hasn't been cycled in 18...

The following should answer your question

You can use the DBCC BUFFER console command to print out the buffer headers and pages from the buffer cache.

Syntax

DBCC BUFFER ( [@dbid|'@dbname' ]

[,@objid|obname...

If you can, look into what whoteegan suggests. There is some work and investment in setting it up, but at the end of the day you'll never worry about your...

Gottcha, so you restore the database from 7 to 2K and left it in standby, what happens when you try restoring the first transaction log.

Never mind, I'm setting up...