Elliott Whitlow (12/9/2013)

---

If they are a member of the sysadmin server role you can't. My understanding was that effectively that role bypasses all security checks, so even a deny...

So we have the following: restrict a single user that has sysadmin rights through a group membership. What are the restrictions you want? No access?

This shows that your system is experiencing memory pressure at that time. Have you confirmed that nothing new was installed on your box that could be causing external memory pressure...

I don't understand your question. You currently have a user that has sysadmin rights to your SQL server and you want to restrict their access? How far do you want...

You can not prevent the index rebuilds from growing the LDF file. As for the second question it really is up to you if you can rebuild your indexes once...

sqlfriends (12/5/2013)

---

Thanks, let me redescribe some of the info. Note I deleted the copied over backup files from production to test after restore.

We do backup on both test server and...

That is great that you are testing your backups by restoring them. I believe that your question is this: If I restore a backup (full + diff + tlogs) do...

Can you post the entire statement that is causing the error?

Welcome! Please take a look at the article in my signature about posting questions to the forums. Table definitions and sample data is always useful. What I would recommend iswith...

In your script that you have to create the logins in dev you need to add the following:

, CHECK_POLICY = OFF to turn off the password policy. After that try...

When you test this procedure please note the size of your transaction log and then pre-grow the tlog in production. You don't want to have your tlog auto-grow in production...

Have you viewed the error log? http://technet.microsoft.com/en-us/library/ms187885(v=sql.105).aspx If so, what was listed?

500,00 tables? Wow :crazy:

Why wrap the script in a transaction? Does it have to be an all or nothing type thing? Also, there is no way to grammatically return the...

I have used that same whitepaper with great efficacy. I would double check that you have both publishers (principal and mirror) configured to use the same distributor with identical settings....

Here is the query:

SELECT

USER_NAME(memberuid) as Member

,USER_NAME(groupuid) as [Group]

FROM

sys.sysmembers

WHERE

USER_NAME(groupuid) = 'db_owner'

and you can use sp_MSforeachdb to run it for all databases on your...