Thanks, its useful information.

Coming to the main article where the Author speaks about scheduling the job as a SQL agent job for every minutes or seconds, will that cause any...

What kind of performance impact is involved if scheduled to run every seconds in SQL2008 R2 enviroinment or scheduled to run every minute in SQL2005 enviroinment.

This job queries registry parameters...

The client insists that he wants the output as a table format, xml\html ,

Since all belong to Sharepoint , the GUI is set byitself and created by them for...

My Database names are big and the entire name gets missed , even if i remove the columns DB file name and Drive on

The Database Space Results Are As...

Yes thats a well made statement, offcourse when sysadmin is going to apply windows patches it can affect the database with bounce..

Eben

Syed,

If we have developed an application which relies on dotnet 3.5 or later then we can define failover connection in the connection string of the application, this will work automatically

Can...

Thanks Syed, the info is useful

Many Thanks Stefan and Shaiju , the answers were really useful for me.

I am going to lock out my SA per auidit need. Even if i use control server option, i can addd database and remove database, but i am not able...

Same applies to me, It doesn seem to work well with SQL 2008 SSMS

Sounds fun...

Let me speak and try to resolve it; the effect of rollback in SQL2000 dint strike me and would be more a disaster.

Thank you guys for all your patience.

Eben

Guys,

Thanks a lot for all your response. I have actually missed to inform that my set up is an SQL2000 Enterprise edition so i am left out with using DMV's.

The...

Hi,

Thanks for the info

Friends,

Thanks a lot. I have added the history clean up task and specified the Historical maintenance plan history to be deleted every 2days.

If this doesn work out i will disable...