Viewing 7 posts - 1 through 7 (of 7 total)
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...
June 19, 2013 at 4:33 pm
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...
March 10, 2013 at 7:06 pm
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...
July 27, 2009 at 4:30 am
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...
July 26, 2009 at 1:36 pm
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...
July 18, 2009 at 4:20 am
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...
July 6, 2009 at 5:01 am
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...
July 6, 2009 at 4:44 am