Hi Steve,

Yes pretty sure I was logged in as a sysadmin, I also ran sp_password in isolation outside the userpass_test SP in the same Query Analyzer session and it worked...

Hi John,

The message reported when executed in QA is "Password Changed",  Also I changed the line

EXEC @returnvalue=sp_password @new=@pass, @loginame=@user

SELECT @returnvalue

and @returnvalue contains 0, but the password is...

Ahh, thanks Rudy, I had made the mistaken assumption that sp_changedbowner was a system sp that was only in the master database

Cheers

With a bit of Jiggery Pokery, I've managed to get a solution using xp_cmdshell and osql

DECLARE @dboname varchar(200)

DECLARE @CMD VARCHAR(200)

DECLARE @OSQL VARCHAR(200)

SET @dboname = 'NewDBOName'

SELECT @CMD = 'USE ' + @dboname...

Thanks for that Brian, I must admit that I had found out where to enable the LLS, but uncharacteristically forgot to add something to this post when I had found...

Hi Gaurav,

Originally had a problem opening licensing in Control Panel, but have now managed to do it. 

Thanks

Hi Yelena,

Thanks for that, that seems to be exactly what I am after .  

I had found seen some limited notes on renaming a SQL...

Thanks Antares,

Yes it was a field that doesn't allow nulls, I should have specified. the column = 0x00 works fine

Cheers

I would equally be interested on any thoughts with regard to auditing Text Fields and how people approach it

I have the requirement to have to do this with a SQL 7 Server Soon.  The Instructions for this would seem to be

• Rename the physical server by going

Thanks

This is what is happening

Cheers

Colleague has just installed SP4 on client tools and this has resolved the problem

Thanks Jo

Looks promising jo,  My colleague's Client tools look like they've never been SP'd as they are an earlier version of mine which is SP4 (8.00.2039).  Let you know whether it's...

Doh! where's that hand slapping forehead emoticon.  Well spotted guys - this could be the problem

Thanks

Simon

Just for completeness and for reference purposes, the reason this wasn't working was due to a typo by me in the filename, once I corrected this the original syntax worked...