This script will generate insert statements for the given tables. You can pass the tables names, separated by commas, into sp_DataAsInsCommand stored procedure as in the example below:EXEC sp_DataAsInsCommand 'employee,titleauthor,pub_info'Updated on 5/25/01 to correct an issue with columns that are short like a column defined as char(1), to correct another issue with the Identity column […]
2005-06-01 (first published: 2005-05-05)
360 reads
Stored procedure usp_CheckMissingPermission_for_User checks missing exec permission for given user or group on all the stored procedures within the database. It not only detects missing exec permission, but also generates a scripts for you to fix the problem.
2005-05-30 (first published: 2005-05-09)
241 reads
This script generates filegroup listing on a given database for each table within the database. This will be very handy to indentify which table is built on a particular filegroup. This is useful for a VLDB (very large database).
2005-05-27 (first published: 2005-05-09)
454 reads
This script is userful in CaseSensitive environment. This will detect a values from a table column which are lower case.
2005-05-26 (first published: 2005-05-09)
93 reads
Generating WITH MOVE Statements for restoring backups on a different servers which has different disk layout.
2005-05-25 (first published: 2005-05-09)
225 reads
I have the need to backup multiple MS SQL databases and email to a support email address.I have added on an original script to produce a fairly robust db back and email script.You can either email the db or just a notification of backup.Script will also maintain db's for a set length of time before […]
2005-05-20 (first published: 2005-01-26)
338 reads
This script uses the DTS object model to create a simple package, execute the package, and properly check for any errors.
2005-05-19 (first published: 2005-04-01)
268 reads
Hans asked if it could be faster. This is about 10% faster; not much. His is admittedly more readable, and mine will act very strangely with invalid hex digits.How does it work? I'm converting the string '1234' to the value 0x31323334 (for example), then subtracting '0000' so that it is 0-based in each byte (CONVERT(INT,0x30303030) […]
2005-05-16 (first published: 2005-05-04)
157 reads
Based on the script by Paul Delmarche ( http://www.sqlservercentral.com/scripts/contributions/1482.asp ).Updated to now include the spid, username, blocked and blocking SQL statements in the email (still logged to table).Schedule the procedure to run at defined intervals (I use 2 minutes)
2005-05-12 (first published: 2005-05-02)
1,445 reads
This script uses the same information sp_spaceused does. It just formats it in a different way.
2005-05-10 (first published: 2005-04-26)
214 reads
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Comments posted to this topic are about the item Why SQL Server Database Attach...
Comments posted to this topic are about the item Fixing P1 Queries
Comments posted to this topic are about the item BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers