Viewing 15 posts - 16 through 30 (of 30 total)
I don't think you need to update the owner password in maintenance plan after changing it in SQL Server. It will automatically take it from the SQL Server. If you...
Regards
Shashank Srivastava
MCITP - SQL SERVER 2008
INDIA
Follow me @ http://shashanksrivastavasqldba.blogspot.com/
July 3, 2013 at 4:56 am
Thanks for the nice suggestion ,its really good. But here i was doing it by the maintenance plan name so didn't want to use package type.
Regards
Shashank Srivastava
MCITP - SQL SERVER 2008
INDIA
Follow me @ http://shashanksrivastavasqldba.blogspot.com/
July 3, 2013 at 4:53 am
Thanks.
Regards
Shashank Srivastava
MCITP - SQL SERVER 2008
INDIA
Follow me @ http://shashanksrivastavasqldba.blogspot.com/
July 2, 2013 at 9:42 am
Thanks for the new addition. These are really helpful.
Regards
Shashank Srivastava
MCITP - SQL SERVER 2008
INDIA
Follow me @ http://shashanksrivastavasqldba.blogspot.com/
May 29, 2013 at 10:19 am
You are welcome 🙂
Regards
Shashank Srivastava
MCITP - SQL SERVER 2008
INDIA
Follow me @ http://shashanksrivastavasqldba.blogspot.com/
May 20, 2013 at 2:47 am
Hi Steve,
You can change the SQL server virtual name and not the instance name.
Regards
Shashank Srivastava
MCITP - SQL SERVER 2008
INDIA
Follow me @ http://shashanksrivastavasqldba.blogspot.com/
May 16, 2013 at 4:12 am
Hi Steve,
Please have a look at below article.
http://msdn.microsoft.com/en-us/library/ms178083.aspx
We can change the SQL Server virtual name but not the instance name.
Regards
Shashank Srivastava
MCITP - SQL SERVER 2008
INDIA
Follow me @ http://shashanksrivastavasqldba.blogspot.com/
May 16, 2013 at 4:05 am
Hi Steve,
As far as I think, change of named instance is not possible. You need to uninstall and install again.
Regards
Shashank Srivastava
MCITP - SQL SERVER 2008
INDIA
Follow me @ http://shashanksrivastavasqldba.blogspot.com/
May 16, 2013 at 4:00 am
Nice connection OldFashionGang.
Regards
Shashank Srivastava
MCITP - SQL SERVER 2008
INDIA
Follow me @ http://shashanksrivastavasqldba.blogspot.com/
May 16, 2013 at 2:16 am
Thanks for the advice. Learnt a new scenario and issue today.
Regards
Shashank Srivastava
MCITP - SQL SERVER 2008
INDIA
Follow me @ http://shashanksrivastavasqldba.blogspot.com/
May 16, 2013 at 1:03 am
Hi,
Nothing happens to existing databases. All databases and configuration will not be affected.
Shashank
Regards
Shashank Srivastava
MCITP - SQL SERVER 2008
INDIA
Follow me @ http://shashanksrivastavasqldba.blogspot.com/
May 15, 2013 at 10:56 pm
Thanks for the suggestion.
Regards
Shashank Srivastava
MCITP - SQL SERVER 2008
INDIA
Follow me @ http://shashanksrivastavasqldba.blogspot.com/
May 15, 2013 at 10:50 pm
Thank you for the modification . Yes we need to make those changes to include databases that have spaces.
Regards
Shashank Srivastava
MCITP - SQL SERVER 2008
INDIA
Follow me @ http://shashanksrivastavasqldba.blogspot.com/
May 15, 2013 at 10:48 pm
Happy to help you. Thanks
Regards
Shashank Srivastava
MCITP - SQL SERVER 2008
INDIA
Follow me @ http://shashanksrivastavasqldba.blogspot.com/
May 15, 2013 at 10:46 pm
Thanks.
Regards
Shashank Srivastava
MCITP - SQL SERVER 2008
INDIA
Follow me @ http://shashanksrivastavasqldba.blogspot.com/
May 15, 2013 at 10:46 pm
Viewing 15 posts - 16 through 30 (of 30 total)