2016-08-23 (first published: 2015-05-01)
1,452 reads
2013-04-17 (first published: 2013-04-03)
1,452 reads
2013-03-19 (first published: 2013-03-01)
1,047 reads
Get Detach or Attach all user databases script
Script to generate script to detach or attach user databases
2013-02-15 (first published: 2013-01-29)
5,714 reads
Reorganize indexes for all tables in all user databases
Script to reorganize all indexes on all tables in user databases
2013-02-14 (first published: 2013-01-31)
3,250 reads
2013-02-06 (first published: 2012-12-27)
1,840 reads
Change database compatability level of all databases
Changes the database compatibility level of all databases to the given level.
2013-01-31 (first published: 2013-01-07)
927 reads
2012-12-03 (first published: 2012-11-07)
2,012 reads
2012-10-04 (first published: 2012-04-10)
2,012 reads
2012-07-25 (first published: 2012-07-12)
2,507 reads
Blogs
Advice I Like: Failure
By Steve Jones
If it fails where you thought it would fail that is not a failure....
Data Conferences – Worth Every Dollar
By Kevin3NF
Some of the best career enhancers you can buy. Why I Go to...
SQL Server 2025 RegEx and AI
By Steve Jones
One of the language changes in SQL Server 2025 that I’ve seen a lot...
Forums
SQL 2022 stuck on xp_delete_file
SQL 2022 hangs on xp_delete_file, it works for a while when sever is rebooted...
Getting the Object Code
Comments posted to this topic are about the item Getting the Object Code
Question of the Day
Getting the Object Code
What happens when I run this on SQL Server 2022 in the AdventureWorks2022 database?
SELECT OBJECT_DEFINITION (OBJECT_ID(N'dbo.uspGetBillofMaterials')) AS [Object Definition]; GOSee possible answers