Jeff Moden (8/7/2015)

---

SQLRNNR (8/7/2015)

---

jasona.work (8/7/2015)

---

Another day, another "how do we prevent sysadmins from doing something" post. Which almost always boils down to essentially "we don't trust anyone, and we...

Sean Lange (8/7/2015)

---

For what it is worth, the text datatype has been deprecated since sql server 2005 in favor of varchar(max). If at all possible you should update your tables...

I'd have to agree, we need a bit more information. Maybe something that helps repro your exact issue.

Victor

jasona.work (8/7/2015)

---

Another day, another "how do we prevent sysadmins from doing something" post. Which almost always boils down to essentially "we don't trust anyone, and we think this will...

You can't prevent an sa from doing anything in sql server.

Implementing Big Brother wreaks of a lack of trust for your DBAs. Do your Domain Admins have to access AD...

It's been said but just to be sure:

One shared ID is an extremely bad idea. Administration doesn't become any easier and compliance to audits only becomes more of a bear.

Sean Lange (8/7/2015)

---

ShorePatrol (8/7/2015)

---

Hi Folks,

I have some indexes over 30% fragmented. Some are much more...

I have a job maintenance plan to "re-organize" indexes every Sunday on all databases. I didn't...

Bonasera

fnndala2 (8/6/2015)

---

@jeff Moden that might be true....SQL-Server training takes the whole day and I might missed some of the query I should reference from .

Thank you:-)

I wrote the test again...

Sean Lange (8/7/2015)

---

WhiteLotus (8/6/2015)

---

Thanks for the reply . I wonder how to combine that statements into my current script . I want to rewrite the current script but have no...

Danville

YW.

I'd have to agree, membership <> grantor permission.

Interesting. I just tested it and am seeing the same thing. I just checked the documentation and it is confirmed that server roles are supposed...

What was the means used to grant these users access to that role in the first place (the users that are now able to grant that role access to a...