Fixed user protion of the script. Sorry had the test script mixed with prod. I was asked to create a report listing all of our SQL Servers, and the databases on them. I was also asked to list everyone that has access to each database and whether it was a standard, windows or windows group […]
2002-10-15
1,063 reads
The script allows you to prepare an xml document as you would use the sp_xml_preparedocument but by specifying a SQL statement. i.esp_xml_preparedocumentfromcolumn @iDoc OUTPUT, 'SELECT TOP 1 documentColumn From myTable'
2002-10-12
580 reads
A user defined function to return a table af tokens from a delimited string.Uses text variable so string can be of unlimited length, performs better than a list of xml elements. Now supports returning of tokens by position
2002-10-12
813 reads
This script will create a standard format file for a specified table for use with bcp or Bulk Insert.
2002-10-09
1,403 reads
I wanted to be able to prepare a script of User Roles and permissions for objects in a database so I can be prepared for backup and disaster recovery scenarios. I also wanted to be able to audit the permissions for each role.I wrote this stored procedure to do this. The usage is:Use NorthwindgoDECLARE @RC […]
2002-10-09
951 reads
I have wriiten this Procedure which Drop all primary keysin whole database Dynamically. Create This Procedure in any User database . Execute it . It Will drop all Primary KeysEnjoy
2002-10-09
304 reads
Enter the name of the field you want to search, in the varchar variable @fieldname al the tables having this particular field will be listed
2002-10-09
271 reads
This stored procedure does a quick table comparison between 2 databases that are supposed to be the same. Tables found on either db but missing from the other are reported as are record count differences for matching tables. Establish a linked-server with appropriate permissions to compare across servers. Compile in master.
2002-10-09
130 reads
Returns database user information as a runnable script for the specified database. The default is master. Great for restoring user access and permissions after a restore to a development server. Run prior to the restore and save the output to an sql file.
2002-10-09
1,064 reads
This script returns the table count for all non-system dbs on the server it is run against.
2002-10-09
295 reads
By Vinay Thakur
This blog series on Audit/Compliance/Security, this is first blog where we would discuss about...
In the previous post, we've built a SQL Server 2025 sandbox in an OrbStack...
By Steve Jones
Thanks to everyone for attending my talk today at Day of data Baton Rouge...
Comments posted to this topic are about the item Can You Really Downgrade from...
Comments posted to this topic are about the item What is CPU Usage?
Comments posted to this topic are about the item Limiting Checkpoints
If I use the -k parameter with a number after it, what does this change in SQL Server?
See possible answers