No this is for a SQL Server linked table to a legacy system

thanks for your help, when I rebuilt the new server I had applied the latest patch.

The other problem I have identified is that you can't get the Sa password out using the sp_help_revlogin stored procedure see my other thread.

http://www.sqlservercentral.com/Forums/Topic1002245-146-1.aspx

Thanks. Ran the T-SQL and it generated the following script:

ALTER LOGIN [SA] WITH PASSWORD = 0x01004086ceb66433e82f3f8946c27e33641a8179e4ad419c5811 HASHED, CHECK_POLICY = ON, CHECK_EXPIRATION = OFF

But it still generated the same error:

Incorrect syntax...

Lowell (10/11/2010)

---

i see what you were refering to...if you run sp_rev_login with no parameters, every login EXCEPT sa is scripted.

if you pass a specific login name, it gets scripted if...

Lowell (10/11/2010)

---

sp_help_revlogin is a script provided by microsoft which scripts out logins and...

Huh? (http://support.microsoft.com/kb/918992/) is sp_help_revlogin. The issue is with regards to transferring the Sa password.

So what have to do is install SQL Server + SP2 (re-release version); restore your database and patch it up to your supported version level 9.00.3050. Before restoring it into...

**BUMP**

great spotted all the april fools jokes so far to day except this one

Alvin Ramard (2/26/2010)

---

... but only if the only way they can create a new database is by using this procedure. You...

I have found a way to do this through Melton's suggestion. However this is my first experience with policy management. I have evaluated the policy and it confirms that existing...

I want them to be able to Create databases, but for the locations that...

Any help would be gratefully apprieciated. Has anyone been able to install SQL server standard 2005 on windows server standard 2008 x64 bit ?

I have done this on two...

Yes I have, and I have repeated...