Viewing 15 posts - 61 through 75 (of 1,165 total)
you can do the same using alter database command...
ALTER DATABASE <DBNAME> set single_user rollback immediate...
check BOL for correct syntax...
May 19, 2007 at 4:06 pm
There were some issues related to maintenance plans in sql server 2005... make sure you applied sp2 before doing anything...
May 19, 2007 at 4:04 pm
Check the maintenance plan history and job history for any errors related this...
what are you doing in your maintenance plan?
May 19, 2007 at 4:02 pm
I believe you are trying to connect to sql server 2005 using Enterprise Manager which is not allowed....
where as you can open dts package and change your connection...
May 19, 2007 at 12:22 pm
Did you apply the service packs and patches after restoring master?
If not try after service packs and patches...
May 19, 2007 at 12:19 pm
If the users are not DBOs or don't have the access to the objects they don't see them because in sql server 2005 security is locked down very tight...
If you...
May 19, 2007 at 12:15 pm
Check the following Technical Articles from Kimberly...
http://msdn2.microsoft.com/en-us/library/ms345146.aspx
May 19, 2007 at 12:08 pm
Are you doing inplace upgrade?
where is your installation files on the local server or in the network... if you are upgrading using network path, copy the installation files locally and...
May 19, 2007 at 12:02 pm
Don't forget to check the server name using SELECT @@SERVERNAME after renaming the server and running the SP_DROPSERVER AND SP_ADDSERVER....to make sure sql rename completed successfully in sql server...
In BOL...
May 19, 2007 at 11:57 am
I believe it is third party backup or HW based backup because TYPE=VIRTUAL_DEVICE information writes when third party backups ...
May 9, 2007 at 12:16 am
Which one is better is depends on many factors...
http://www.sqlservercentral.com/columnists/pibison/logshippingvsreplication.asp
http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=20851
May 9, 2007 at 12:05 am
Don't you think it is time for SSIS instead of DTS?
May 9, 2007 at 12:02 am
I think so..
If the AUTO SHRINK database option is enabled, it will shrink automatically based on the free space other wise not...
May 9, 2007 at 12:01 am
As suggested open the case with PSS, generally you won't be charged if it is a bug...
May 6, 2007 at 11:41 pm
Viewing 15 posts - 61 through 75 (of 1,165 total)