Is this an Active-Active cluster or Active-Passive?

You must assign the resources from Cluster manager and then specify the possible owners. Make sure the node you have SQL running on can...

Why open a cursor when you can do it in a simple way..try this..

alter database [db_name] set SINGLE_USER with rollback immediate

go

alter database [db_name] set MULTI_USER with rollback immediate

go

Thanks!!

The results returned by sp_spaceused cannot be relied as perfect. Run DBCC updateusage (yourdatabase) with no_infomsgs,all_errormsgs and check what is the free space again.

Thanks!!

What activity is it? with that I mean to ask if its a query or SP or job that is taking too long all of a sudden..

Also as Gail said...

nitin.saha (1/23/2009)

---

I had a similar problem in SQL 2005. The issue turned up to be that my id lost execute authority on the SP. I had to re-grant the execute...

Well, it being an interview question you have to answer this in a stipulated amount of time, the answer could be as:

1. If report is not working then run profiler...

Running CHECKDB is fine, to avoid performance issues I would be glad to do it on a test box, by grabbing a copy of the production backup. But even with...

If you wanna corrupt it time and again after you try repairing then backup the clean database before you start corrupting it..

Thanks!!

Thanks Paul for your insight, also thanks Gail for your suggestions.

Apparently I got rid of all the errors from CheckDB by running repair with allow data loss statement. Also there...

Run profiler and check for events like SP:starting ,SP:Recompile,SP:stmtcompleted and SQL:Batchstarting while running this report.

Not to mention the code for this SP can also be checked by viewing the execution...

One way to investigate, is to run the SQL Server Profiler with the default template. If you see an Audit Login event, then there is a new connection.

If you see...

My advice would be to go for a Windows 2003 Cluster, which is more stable and easy to install. What are your options- Inplace upgrade or side by side?

Thanks!!

The user who creates the database is set to as the owner of the database, which you can see in the options tab of properties...and yes, it can be changed...

AndyG (1/14/2009)

---

I think the question that needs answered the most is the earlier one about whether the log file ballooned overnight or has just grown over time because you aren't...

Looks to be a problem with your disk, check and see if it needs to be defragmented.

Also what RAID array is it? If so how many spindles is it made...