Here's a simple SQL to give you locking information.The SQL tells you what resource type you are using, the object name, lock request mode, lock status, and also the calling program's name.And all this from a simple query on sysprocesses, and syslockinfo!
2002-07-10
687 reads
This SQL Server stored procedure generates more readable output from the system sp_lock procedureinstead of getting object ids and session ids it returns the object name and user name
2002-07-10
1,055 reads
this procedure is an interface to bcp it gets database name,table name , file and path,,mode E/I for export/import and seperator character user and password and exports/imports text files from / to SQLSERVER
2002-07-10
1,436 reads
this script describes the steps neccessary to implement full text indexing in TSQL on your SQL SERVER systemCan be used programatically in tsql code
2002-07-10
740 reads
This is a very simple and small stored procedure which will help you identify repeated rows on any given table. This is specially useful for situations when you want to clean up a table and add a primary key on it, but you cannot until all duplication is eliminated. Only two parameter are necessary; table […]
2002-07-08
1,094 reads
Deletes the duplicates from a table based upon any fields in the table leaving a single copy of the record in the table.
2002-07-04
944 reads
This script allows you to dynamically alter all the tables in your database. In the script i am building up an alter statement that adds a 'TimeStamp' column a table.If anyone knows a better way to do this kind of thing, feel free to drop me a mail (jamie.moffat@infographics.co.uk)
2002-07-04
775 reads
Returns the key fields of all duplicate rows in a table based upon any fields in the table.
2002-07-04
758 reads
Returns an ordered column listing for the specified table, stored procedure, or view.
2002-07-04
489 reads
Generates a rowset with a datetime values for every day between a start datetime and end datetime.
2002-07-04
651 reads
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...
How I used AI for this postChatGPT to generate images based on info specifically...
Comments posted to this topic are about the item Demo Tracking Dropped Objects
Comments posted to this topic are about the item Randomly Selecting Columns and Rows...
Comments posted to this topic are about the item How Can SQL Server Detect...
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers