UPDATE abc SET z = y

You could use an application role which is a member of for instance db_ddladmin. Let your program use this role when it needs to execute that statement.

Sure, use MSDE. Or even the new SQL Server 2005 Express Edition if you can wait for it/go live with the pre-release golive license.

You can't. TRUNCATE TABLE is not grantable. Members of sysadmin, db_owner and db_ddladmin have permission to use it, as well as the object owner.

I agree that if you have got a hundred databases and need to optimize them all 'independently' you have got a problem, yes. But the fact is, to optimize transaction...

But there is no meaning throwing all (or anything more than one) log files on a single disk. You need separate disks for each log file. Is placing master's log...

I'm just trying to force you into changing your nick back.

The Question was asked to me. Is this going to be a "new" enhancemnt in sql 2005? Maybe it will go back to allowing Nulls, but also checking...

I agree with GilaMonster. Either you create a user table of your own and authenticate the users against it but let your application run as a single login. Or you...

Hey, no waste. As long as something was learned it is never a waste.

But why do you not just do this then:

CREATE proc sp_cp

(

@usr_id varchar(50)

)

as

begin

EXECUTE sp_password null, 'YC3STLXO32' , @usr_id

end

But how do you mean they will automatically be found in sysusers? Either you are storing rows there (by INSERTing), which you should definitely not be doing. Or you are...

First of all, why are you doing this with dynamic sql??

Anyway, here is how to do it:

Execute sp_executesql N'sp_password null,''YC3STLXO32'', ' + @usr_id

If @usr_id is a character type you need...

Also, it all depends on what data you have. You can compare execution plans and/or stats all day in a test environment, but the real question is how the queries...

The password in sysusers is not used as far as I know. BOL says it is for internal use, but I have never seen anything other than null for it....