I use a script to get the blocking query info. The attached script will give you the SPID, query text, loginname and hostname of the blocked process as well as...

You will have to delete some records from the sysmaintplans_subplan to delete the jobs. Take a look at this link

http://saveadba.blogspot.com/2011/12/sql-server-msg-547-level-16-state-0.html

If you are running the SP in a query window then you can copy the results to a text file or an excel file.

In SSMS go to QUERY menu and...

Open the job that contains the command to run the SP. Go to the step that executes the SP then in the top left corner you will see the 'ADVANCED'...

It is also listed in on SQL Server central

http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31598/

I found the script from here

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=111431

I have tested the script several times and not once it has generated a DENY command for users that are not part of...

Please show me the line where it does that. I have no malicious intent so if the script does that then I will remove my script and never use it.

The...

That is the location and name of the file that will have all the create job commands. Replace the directory with the directory you want the file to be stored.

You...

Assuming that this is SQL Server 2005 or 2008, use the following query and run it against the database

Use yourDBname

SELECT ps.page_count, ps.database_id, ps.OBJECT_ID, ps.index_id, si.name, ps.avg_fragmentation_in_percent,

(SELECT distinct so.name FROM sys.objects...

For jobs, I would rather use a VB script. The TSQL method puts a limitation on the length of a job step that is being scripted.

Check this

http://saveadba.blogspot.com/2011/12/sql-server-2005-generate-scripts-for.html

Check out...

I have found the powershell method and the VB scripting method is the best way. If you use TSQL method then any job step that has more than 8000 characters...

Please check the following website for more information.

http://www.virtual-dba.com/platforms/ms-sql-server

If you need more info then please let me know.

What if the disk on the secondary server got full and the backup files dont get copied. If this is not identified within reasonable time then the log backup files...

I had set up log shipping from 2005 instance to 2008 instance. The only problem I had was connecting to the 2008 instance via the management studio on the server...

First try to check the error logs on all servers involved and get the login failure message from there. That should give you more info on what database and what...