Reviewers: Please disapprove this change, thanks Sorry people, I had deleted this script due to red-gate copyright issue, prior to having the copyright confusion cleared up. I will repost if reqd.
2007-02-15 (first published: 2005-09-21)
209 reads
This procedure will give the list of columns included in the primary key for a given table of given database on given server.For. e.g.Get_PrimaryKey 'vrs-118','Demo_StDB','IMAGEREPOSITORY'
2007-02-14 (first published: 2006-08-25)
962 reads
As we all know, BINARY_CHECKSUM ignores columns of data type TEXT.This code is 100% compatible with MS original. That is, the result is identical.You can use it "as is", or you can use it to see that MS function does not produce that unique values one could expect.
2007-02-13 (first published: 2006-08-24)
188 reads
Perl script that reports SQL Server AD accounts which are now longer valid by verifying the output of sp_validlogins system stored procedure against SID stored in AD. This is done to ensure only accounts that do not exist are reported since sp_validlogins will only check the name and not SID against AD. Accounts that are […]
2007-02-12 (first published: 2006-08-08)
250 reads
This script is used to find out the free space in database filegroups and store output into a text fileInputs: database name, threshold value in percent, output file.
2007-02-09 (first published: 2006-07-01)
318 reads
This script will list out database(s) which has Unallocated space in negative and also generate script for correcting these.DBA needs to run the generated script to correct problem.
2007-02-07 (first published: 2006-07-27)
227 reads
This is another type of split function which disects 8000 byte varchar with given delimeter and returns table with disected values.It does that with single select statement (internally looped), without using explicit while loop.Works pretty fast
2007-02-06 (first published: 2006-08-18)
406 reads
Use this script ot be able to create DB Maintenance Plans fast. If you need to create the plans on servers similarly set up, edit the required parameters once, and when you create a new plan, you will only need to specify a database name and one task start time, run the script and the […]
2007-02-05 (first published: 2006-08-07)
985 reads
This script cycles through a chosen selection of databases, and grants permissions to all tables, views and stored procedures to a user or role.To use, change the ###text### to control which databases, permissions and the user/role concerned.
2007-02-02 (first published: 2006-07-14)
926 reads
Usage -Populate @list variable below with account(s),comma delimited list to script. -Save output to recreate:Login,Default DB,Server Roles,DB Access,DB Roles,DB Object Permissions. -- NOTE: -Stored procedures are created in Master, but are deleted -to limit by database see section /*Get a table with dbs where login has access*/ and change the where clause -to script all […]
2007-02-01 (first published: 2006-08-02)
4,442 reads
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
WA:08218154393 Jl. Jend. Sudirman No.38, Sumurpecung, Kec. Serang, Kota Serang, Banten 42118
Wa:0821-4447-7715 Jl. Ahmad Yani No.39 A, Rw1, Sidokumpul, Kec. Sidoarjo, Kabupaten Sidoarjo, Jawa Timur...
Wa:0817-866-887 Jl. Soekarno Hatta No.33, Trajeng, Kec. Panggungrejo, Kota Pasuruan, Jawa Timur 67111
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers