Viewing 15 posts - 946 through 960 (of 1,160 total)
As per Microsoft documentation is not possible to "uninstall SP3".
After SQL Server 2005 SP3 has been applied, it cannot be removed without uninstalling the entire product
July 31, 2010 at 1:36 pm
You did not post the job step output log. Does it have any information?
July 31, 2010 at 1:25 pm
GilaMonster (7/31/2010)
sys.dm_db_indx_physical_stats
Just an FYI. There is a typo. "e" is missing in index.
July 31, 2010 at 12:27 pm
This will give you the Reserved and Used space details for all the indexes in a table. If this does not meet your requirement, just tweak the query.
...
July 31, 2010 at 12:06 pm
Please go through this MSDN documentation.
July 31, 2010 at 3:28 am
Dropping a database does not leave behind the data and log files.
July 31, 2010 at 1:14 am
SQL Server has just dumped the backup information to the file and the operating system did not allow the file to be processed. This backup file is irrecoverable
July 30, 2010 at 10:02 pm
Get the Service Name from services.msc for those services. As you did for the other services, use NET STOP servicename
July 30, 2010 at 10:00 pm
You can check in sys.processes to see if any backup job is running against a database. Put this logic in the Shrink TLog job step
July 30, 2010 at 9:56 pm
Could not see SQL Server element in the question
July 30, 2010 at 2:08 pm
Description = The server name or address could not be resolved
From the error message it does not look like an issue with SQL Server. Check the server which is being...
July 30, 2010 at 1:42 pm
Just put those commands in a notepad file and save it as .bat. You are good to go !
July 30, 2010 at 10:41 am
Add an output file to the job step --> advanced. With this the job execution will be fully logged in a text file.
July 30, 2010 at 10:40 am
Viewing 15 posts - 946 through 960 (of 1,160 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy