Hi

The error means that the Login is correct but the server couldn't be accessed.

Create an Alias using...

Hi

It's a permissions issue. Please check that whether you have all required proivileges.

...

Hi

Lowell is correct.

If you are a sys admin then XP_CmdShell uses the credentials of SQL Server Engine...

Hi Koteswara Rao,

As it is a 32-bit...

Hi AKP,

You can cange the Max memory setting using TSQL as you have already mentioned...

Hi Striker Baba

Download 64bit Oracle Provider for OLEDB from the following link.

http://www.oracle.com/technology/software/tech/windows/odpnet/64-bit/index.html

Check...

Hi Jason,

Server A has SQL Server 2000 on Windows 2000 (32-Bit)...

Hi Cath,

Thanks a lot for your reply. We tried that solution. But of no help.

...

Hi Jeff and Jason,

Thank you very much for your...

Hi Jason,

If we are restoring the db from Server 1 to a database (Server 2 not having the logins,...

Hi Sourav

Try this.

...

Hi

Any help please?

Thank You,

Best Regards,

SQLBuddy

Hi K,

If you the db is a Prod db and if you are using Full Recovery Model (which I think should...

Hi Ram,

You can script the Job from the SSMS.

...

Hi Jason,

You are always very quick and wonderful. Thank you very much for your help.

...