Viewing 15 posts - 106 through 120 (of 190 total)
Here is a quick, easy way that I do it:
/* =================================================================================================================== */
/* Load SQL Error Logs to a temp table for research
Whole script at:
http://www.sqlservercentral.com/scripts/Error+Logging/70611/
*/
CREATE...
May 11, 2012 at 7:21 am
Here is what I use to find blocking:
http://www.sqlservercentral.com/scripts/Head+Blocker/75366/
In the past month, had two occasions to use it. Worked perfectly. Someone was running a report in the...
May 11, 2012 at 7:14 am
Just did this last week for our developer. Is a table-valued function that returns a table with the values split out. Hope this helps.
(probably not very scalable, but...
April 30, 2012 at 11:54 am
Then I would say third-party software is the answer.
April 18, 2012 at 6:14 am
If it helps, here is the URL to a script I wrote to do a "Instance Security Audit Documentation" script. It will print in normal report format, or you can...
April 17, 2012 at 8:35 am
If your goal is to protect the data from prying eyes, you could use column-level encryption instead of TDE (although CLE has its own set of advantages/disadvantages).
Unless they have the...
April 17, 2012 at 8:27 am
No idea if this will help, but if you are deleting tens of thousands of rows, you don't have a commit, so it might have some trouble with deleting that...
April 17, 2012 at 8:18 am
To Lowell's point, if you are wanting a "who dunnit", then would it be possible to put all updates, deletes, inserts and selects into SPROCs, and log who runs what...
April 12, 2012 at 6:55 am
Here is the companion Data Dictionary script that utilizes the CLMNDOC extended property, along with others, to create a decent picture of the database. It's not perfect, nor slick,...
April 11, 2012 at 9:45 am
Here is a script I wrote to create a script to set the column definitions for every column in every table. When filled in, just run the finished product...
April 11, 2012 at 9:39 am
Keep in mind that CDC is only in Enterprise Edition (SQL 2008), and it doesn't track who made the change, just the changes that were made.
If each user logs in...
April 10, 2012 at 7:43 am
Lynn:
I look forward to seeing that. I do light to medium design work, mostly administration. My databases that I write are only used by small departments. I...
April 4, 2012 at 12:45 pm
If it helps, here are a couple of functions I created to do just that. First input is the full line of information to look at, and the second...
April 4, 2012 at 10:05 am
If it helps, here is the URL to a script I wrote to do a "Instance Security Audit Documentation" script. It will print in normal report format, or you...
March 30, 2012 at 7:02 am
Note that the script assumes that the structure of the table in the two databases hasn't changed.
March 22, 2012 at 8:58 am
Viewing 15 posts - 106 through 120 (of 190 total)