yeah I know that. What I meant was if someone has a query which will return all the users which are member of sysadmin,dbcreator and db_owner.

see if uniqueidentifier can help you

what do you mean by when placing a trigger on a file or column ?

You must be using a full recovery model. under full recovery model all the chnages will be log. Based on you database requirement consider changing recovery model and also consider a...

correct

where

       COALESCE(col1,'') <> COALESCE(col2,'')

DECLARE @SQLStr VARCHAR(30)

SELECT @SQLStr = CAST(Num1 As VARCHAR(10)) + Text1  + CAST(Num1 As VARCHAR(10))

FROM A

EXEC ('SELECT ' + @SQLStr)

You may have to add this in a loop for all the...

EXEC sp_update_job @job_name = <Job Name>, @owner_login_name = <Your Name>

Job owner or member of SA can view job. You can ask the SA to give you the ownership of the jobs.

I do not think so. Remember with multiple instance SQL Server listen on dynamic port. So it depends if your server have many application running which use port dynamically then...

I assume you restore database at 3.00 AM and then ran some delete statement sometime in the day. Now you want to recover those records.

If you are not using any...

I completly agree employee get frustrated that progress doesn't seem to be made in a certain direction because my manager seems to be dragging his feet.

Worst part at end of...

yes. the account running the agent nees permissions to that shared drive

Just do step 1 and step 10. You job is done

I am not able to understand your question