This is what I have been using:

IF NOT EXISTS

(SELECT * FROM sys.server_principals

WHERE [name] = 'FORESTCITY\CorpSPLANDBAdmins')

CREATE LOGIN [FORESTCITY\CorpSPLANDBAdmins] FROM WINDOWS

I am migrating them from sql 2000 to sql 2008. And I see they have access to sql server in 2000 . Other windows level logins similar to them are...

Hi,

I copied the local dts packages from 2000 to 2008 using migration wizard. Then I downloaded and installed the 2000 dts designer components. And...

Hi , I got it resolved.

Thanks anyway.

SVR

Thank you for responding. I got it fixed. I used a download from the following link:

http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=3522

SVR

Hi ,

I am trying to analyse 2000 DTS Components using Upgrade Advisor. And it is throwing me an error saying

DTS Client is not installed...

Thank you for the reply.

the sql agent needed a restart.

and the job ran successfully.

SVR

Thanks!

The tables and the schema do not exist on the destination? Then how can it be done?

Thanks!

Thank you very much.

Can you suggest any ways that I can use to group the remaining logins.