prashanthreddymr (4/17/2013)

---

Am a junior DBA and We have an issue from last couple of days. We have a server of Windows 2003 Standard Edtion of x64 bit with SP2. SQL...

In SQL 2005 Trace may be your best option. If you're just looking for ad hoc then SQL:StatementStarting might catch all your cases with a filter on Text for that...

crmitchell (4/22/2013)

---

opc.three (4/22/2013)

---

crmitchell (4/22/2013)

---

Eric M Russell (4/18/2013)

---

If you're a member of sysadmin, then you can grant or deny whatever privillages you know are really required. You can...

crmitchell (4/22/2013)

---

Eric M Russell (4/18/2013)

---

Dree Vasquez (4/18/2013)

---

Hi All

Thanks so much for all the suggestions. I really appreciate it.

I asked the Global developer and they said their procedures cannot be changed....

Absolutely! And testing will show that shipping a TVP to...

Achilles

WITH EXECUTE AS can fall down if there are cross-database calls.

To answer your question, yes, there is a way to setup your database security such that the Database User only...

1. CHECKSUM would likely catch straight mods to a page outside the engine. That's their reason for existing. Point was that the engine is supposed to disallow out-of-bounds data values...

It ensures that data in your columns adheres to that column's data type. Nothing more really. But once you run it once WITH DATA_PURITY you'll always get those checks out...

Definitely run in prod. Chances are good if it ran clean off the restored copy it will run clean in prod. CHECKDB is not going to make mods to your...

Fries

Sequence

Given that this was a 2000 DB and UPDATEUSAGE had not been run, it compels me to ask you if you have ever run CHECKDB WITH DATA_PURITY. If you have...

I am not in a place where I can test, but it seems like simply adding a .* before and after the regex that matches your CC# pattern would make...

You're using an undocumented proc. See if the documented proc I mentioned will be more helpful or research differences in the interface for the one you are using on 2012.