Why not add a option to sql server to disallow multiple sql statements in one execution. (basically get rid of the ; in ad hoc queries). that would halt many...

Also regarding logging in - I am in a funny situation where I have users (i.e. other developers) logging in to the db with full rights (it would be very...

ok - thanks a bunch for the explanations

Ok - sorry again but I am having trouble running the functions from a non master database - I keep on getting

Could not find stored procedure 'dbo.xp_encrypt_aes'. The statement has...

I didn't - but isn't that why I am encrypting the data - so that if somebodu does get a login all hell see is gibirsh.

If the user does not...

Sorry - I am a bit confused.

How does it help me to have the data encrypted - when a maluser who has a login (obviously the person i am trying to hide the...