Do I really have to try, as suggested, to use 'repair_allow_data_loss'?

I guess so but please make sure you have a good backup of the database before you run that.

check this articles. you need to set up security account delegation

http://www.sql-server-performance.com/tb_kerberos_protocol_transition.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_24tv.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_security_2gmm.asp

Aaron

I think i remember of running into this one. All i can think about is deleting all references to Microsoft SQL Server and MSSQLSERVER(or your named instance if you have...

Instead of using print, try using select. i.e.

print 'hello'

use

select 'hello'

The dependencies are displayed from the sysdepends table. you don't have to recompile the procedure. SQL server will take of re-compilation after you make changes(drop/re-create) the objects referenced

Frank,

Feel free to post the script on the site.

Below is the updated version which also takes database name as a variable. and with all the instructions

'This script will give the...

Sorry, should have mentioned that. Paste the script in a notepad and save it as find_procedure.vbs.

You can then run it from the command prompt and pass in the parameters next...

Check this out.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;115333

Also Fully qualify the procedure name. Make sure the owner of the procedure is the same in all environments.

RAID 10 is the best option for your data files. A mirrored volume can give you better performance for the log files if you have the flexibility of having both...

As Brian said, You need to assign the SQL Server Agent account SA privileges. Actually, SQL Services does not need SA privileges to start and only SQL sever Agent priviliges...

Below is a vbscript i wrote to find a variable. If you want allthe procedures, don't enter anything for variable.

'This script will give the name of all the procedures wiht...

Below are your answers.

Old Hand,  if you stop sql on the active node of the cluster, with cluster active, wouldn't it just attempt an automatic failover to the passive node? ...

Below links also have some information

http://www.windowsitpro.com/Article/ArticleID/14047/14047.html

http://www.windowsitpro.com/Windows/Article/ArticleID/492/492.html

I like Wesley's suggesstion of copying the logins and passwords. Below is the script which you can use to script out the username and password. For DTS packages, you can save...