The first part will create 2 stored procedures with self-explanatory names. The second is a standalone SQL that may be used in any stored procedure, script or DTS package.The generated string does not have any spaces and include only lower-case letters. To include anything else just change the boundaries for ASCII codes in the script.The […]
2002-09-26
575 reads
Every want to keep everyone from updating all your users database? If so this script will set each database to read only status.
2002-09-26
349 reads
The objective is to find circular references in a single table related to itself. The script deals with a sample table Skills that have a SkilGUID (primary key) field and a SkilParentGUID field which is a foreign key to the record's parent from the same table. The number of levels in the hierarchy is not […]
2002-09-24
1,109 reads
Quick and dirty script to generate the required SQL to reinstate permissions on each user object. This can be saved off for DR purposes.
2002-09-24
466 reads
Every want an easy way to set all database to DBO only and single user mode? Well here is a script to do that for you. This script is useful when you want to keep users out of the all the databases.
2002-09-23
1,334 reads
Here is a companion script to "Set All databases to DBO only and Single User Mode" that will turn off dbo and single user mode for all databases.
2002-09-23
537 reads
for both 7.0 and 2000. It generates log table and triggers for main table.Its avaliable for all dbs on current server.
2002-09-21
693 reads
Others have asked for this throught the disussion threads so I thought others might benefit as well.This SQL-DMO script will create multiple files for server logins (SIDs & encrypted passwords), database users, tables, procedures and views.1. Alter the script to reflect your server and path for output files.2. Create the job (ActiveX Script).Be great!Michael
2002-09-20
1,217 reads
Recently at my site we had a need to gather current capcatiy of all databases as well as table obejcts on our servers. although there are some out of the box stored proceudres to assist in this effort as well as some schema objects, they mostly would return information on one database at a time. […]
2002-09-20
290 reads
This DTS package reads a list of servers from an XML configuration file, connects to each server, and writes a list of all failed jobs to a web page on the web server. Each morning, I just need to open my browser and I can see the status of all 42 of our servers.
2002-09-19
700 reads
I am excited to host T-SQL Tuesday for the first time. I want to...
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Comments posted to this topic are about the item Measuring Productivity
Comments posted to this topic are about the item Importing Excel files into SQL...
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers