This simple view will return the name, loginname,hasaccess,dbname and create date and updatedate where sysadmin or serveradmin is set to 1 from the syslogin table. If the hasaccess column is set to 1 the access is granted.
2001-12-28
1,342 reads
This is a script, similar to some you have seen in the past, that will monitor file growth on all databases for the given server. This script is not a fancy solution that has a tons of bells and whistles but, it is efficient. The script is a concantanation of the create table / populate […]
2001-12-21
3,413 reads
Having two tables Parent and Derived in ont-to-many relations we want to realize a cascade delete so that for a certain list of parent to delete all the coresponding items from Derived I use a INSTEAD OF DELETE.
2001-12-18
905 reads
Usually when we recreate or rename a table we need to give the appropriate access permissions to the SQL users...this is very common in database under development environment where frequently table structure changes and we have to recreate it....we can accomplish this with Enterprise Manager but what will you do if Enterprise Manager fails to […]
2001-12-18
856 reads
System Stored Procedure to List the Table Definition of a table as a printable report. The procedure must exist in the master database. This works for any table in the current database. Do not fully qualify the tablename. Calling sample: use pubs exec sp_listtabledef 'authors'
2001-12-18
3,448 reads
This script lists the columns with type and length. It eliminates system tables.
2001-12-13
797 reads
This script allows the capture of the locks to a table. After the capture, you can see the commands and the moment of the lock.
2001-12-13
3,021 reads
Thanks to Raul Sharma for his brilliant ideas. This is a modification of one of his scripts. The script takes only the user tables. Those tables which does not have PK are not listed!
2001-12-13
761 reads
These 2 files plus sleep.exe (Resource kit) gives an administrator a good view of important blocking statistics in almost a real time fashion. You can use this with profiler to obtain some unique information very fast on a lead blocker if your gathering the right counters in profiler and dumping them in a table and […]
2001-12-10
584 reads
Have you ever wished T-SQL allowed you to pass an array into a stored procedure? Well the spListToTable stored procedure listed below accepts a delimeted string and turns it into a table. Code your stored procedure to accept a varchar, create a temporary table, call spListToTable, and use the populated temporary table as if it […]
2001-12-10
2,889 reads
A RAG pipeline that answers questions in the demo is not the same thing...
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Working with SQL Server 2022 can be a great learning experience, but development tasks...
Comments posted to this topic are about the item Looking for New Blood
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers