Create a bcp format file for a specified table
This script will create a standard format file for a specified table for use with bcp or Bulk Insert.
2002-10-09
1,395 reads
Clinton Herring
sp_CompareTblCnts
This stored procedure does a quick table comparison between 2 databases that are supposed to be the same. Tables found on either db but missing from the other are reported as are record count differences for matching tables. Establish a linked-server with appropriate permissions to compare across servers. Compile in master.
2002-10-09
129 reads
sp_GetUserInfo
Returns database user information as a runnable script for the specified database. The default is master. Great for restoring user access and permissions after a restore to a development server. Run prior to the restore and save the output to an sql file.
2002-10-09
1,061 reads
Table count for non-system dbs
This script returns the table count for all non-system dbs on the server it is run against.
2002-10-09
290 reads
Find and replace column constraints
I submit this script as an example of how one might go about generating 'Alter Table' statements that find and replace specific column constraints. In my case I had to find all occurrences in a production db of suser_name() as a column constraint and replace it with suser_sname(). This script is only an example and […]
2002-10-08
264 reads
Easy table pivot
Pivot a table from vertical rows to horizontal results with a single select statement; no cursor.
2002-10-04
2,418 reads
sp_spaceused2
An update to sp_spaceused2. This update fixes some problems related to dbs that are non-accessible such being offline. This stored proc can be run from any database when compiled in master and can report information on all databases at once. Get information on all dbs, one db, one db and all its tables or one […]
2002-02-19
316 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Taman Pondok Indah No.Telp 083831617937
Whatsapp.083831617937 Ruko Taman Pd. Indah, blok A-16, Wiyung, Kec. Wiyung, Kota SBY, Jawa Timur...
BCA KCP Babatan Pantai telp:cs.083188951403
Whatsapp:083188951403 Jl. Babatan Pantai No.02-T, Dukuh Sutorejo, Kec. Mulyorejo, Surabaya, Jawa Timur 60112
BCA KCP PejatenTelepon 083110611866
WhatsApp 083110611866Ruko, Jl. Pejaten Mas Raya Jl. Raya Pasar Minggu No.Km.20 No. 98F &...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers