Stored Procedure will list all objects, object type, and linked server name. The stored procedure can either be passed in a linked server name as string or null.
2012-09-17 (first published: 2012-08-23)
1,080 reads
The query will help to find whether my database backup to a specific instance of SQL Server is running fine. If HH> 1, this would signify that the backup is running, else this is a failure.
2012-09-13 (first published: 2012-08-25)
1,250 reads
Powerful function to find strings containing or excluding classes of ASCII characters.
2012-09-10 (first published: 2012-08-28)
1,064 reads
2012-09-07 (first published: 2007-11-15)
3,507 reads
2012-09-04 (first published: 2008-04-24)
1,161 reads
Find missing and mismatched views and stored procs between 2 Databases
2012-09-03 (first published: 2008-05-29)
1,731 reads
This script helps you to constitute insertion procedures for tables in a millisecond.
2012-08-30 (first published: 2007-11-05)
2,338 reads
A simple way to find any term in all banks or only in a specific database.
2012-08-28 (first published: 2012-08-17)
814 reads
A few brief selects to expose snippets of data which may be useful for debugging larger issues.
2012-08-27 (first published: 2012-08-15)
3,773 reads
2012-08-24 (first published: 2007-09-29)
1,702 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