Generate "CREATE...FOR ATTACH" stmt. dynamically

In instances where you have over 16 data files, or you need to move data files to a new location when you are moving a database you must use a CREATE...FOR ATTACH statement.  This script will generate the CREATE...FOR ATTACH statement dynamically given a database name.  It will take into consideration the file sizes, growths […]

2003-05-07

210 reads

Blogs

VMworld 2020 – Top 10 Database Sessions (Part 2)

By

Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member...

Daily Coping 25 Sep 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

VMworld 2020 – Top 10 Database Sessions (Part 1)

By

Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member...

Read the latest Blogs

Forums

SQLServer Agent not sending dbmail on job completion

By maxo85

Hi Everyone! I have a problem with a SQL Server 2017 with dbmail. I...

Ignore the entire record if a matching record is found

By SQL_Hunt

Hello, Kindly guide me with the following code in T-SQL. I need to only...

New Stuff Can Be Scary

By Grant Fritchey

Comments posted to this topic are about the item New Stuff Can Be Scary

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers