July 27, 2011 at 3:18 am
Hi can anyone please help me on
Login transfer using maintenance plan.... in SQL Server 2005 environment.
Sagar Sonawane
** Every DBA has his day!!:cool:
July 27, 2011 at 5:49 am
I do not know that you can do it in a maintenance plan.
There other ways to do it.
The following link has a script that may be of help to you.
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=111431
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 29, 2011 at 4:01 am
I found Script on http://support.microsoft.com/kb/918992
now i can do it in maintenance plan.
But it will be better that not to use it in maintenance plan.
Sagar Sonawane
** Every DBA has his day!!:cool:
July 29, 2011 at 7:20 am
What?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 1, 2011 at 9:00 am
If it is T-SQL , then I think you could do it as a job under SQL Server Agent.
This is another way to run it, it is easier to maintain then having to create a ssis package.
My question is creating a stored_proc on the master database, is this practical?
Is this a best practice, it is a Microsoft support fix, so I am guessing it is okay?
I would remove the stored_proc after you are done.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply