SSC Rookie: I am afraid this advice will not work. In order to have permissions to run the sp_start_job command, the user would need to be granted one...

I think the part that is missing here is that you were called upon to 'fix' the database, which you are not officially supporting. I have been aware of...

It is unfortunate that the question did not mention anything about cost or licensing, but only what was possible. Snapshot replication *is* possible with Standard edition, which is why...

http://msdn.microsoft.com/en-us/library/cc645993.aspx

I believe that the answer to this topic is incorrect. Per the above URL for sql2008, both Enterprise and Standard editions support Snapshot Replication. As Developer...

Another method is to use the stored procedure:

sp_helpdb 'db_name' -- of course replace db_name with your database name

It will provide information on the database other than just the...

Have you thought of the option of shrinking all of the data out of one of the transaction log files (see DBCC SHRINKFILE) so that it is empty, and then...

The reason that the 'fail' occurs is that all of the cluster resources on the original/'active' server must be shut down on the physical server hosting those resources so that...