You need to move the login to a different SQL Server using sp_help_revlogin

Follow the procedure here and choose only that login you need to move..

http://support.microsoft.com/kb/918992/[/url]

It doesn't have the info regarding the failure. Do you have any error logging for the SQL Job or Maintenance Plan ? That would give more info.

As Paul indicated, that would not help solve the OP required task.

Performing an In Place upgrade would be tricky, it would result in not having a...

Yes you need to create a linked server with RPC settings enabled.

You are welcome !

Use this script.

Change the @PCTFULL value to filter the files with more than X % fullness

DECLARE @PCTFULL INT

SET @PCTFULL = 80

DECLARE @sql VARCHAR(4000),@sql2 VARCHAR(4000),@body varchar(8000), @SUBJ VARCHAR(1000)

DECLARE @dbName...

I would like to know,...

Do not post duplicate threads.

All replies here

http://www.sqlservercentral.com/Forums/Topic868403-145-1.aspx

CirquedeSQLeil (2/18/2010)

---

Steve Jones - Editor (2/18/2010)

---

PASS has also been good about moving registrations for a company if someone leaves or can't attend.

If you haven't been to Seattle much, there are...

I am sure I have not understand it completely.

If you have to start a different job upon completion of the current job, I would rather add a final step in...

George, correct me if I understood you wrong, are you suggesting database snapshots in the above statement?

That's not the points in the forum, it is in the entire SSC site.

When I see a user posting such...

Good to hear that Dan.

Ninja's_RGR'us (2/18/2010)

---

That post from bru as the first reply would have taken the edge off my *** feeling :

Can I forward the links in the interview ?

There are a...