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
211 reads
By nelsonaloor
As a SQL database administrator, I am responsible for maintaining our organization's SQL Server...
As we all know, there are various numeric data types, such as TINYINT, INT,...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
hi guys! Problem: 1) Every time I overwrite an existing shared dataset (with a...
Hi, We just installed SQL Server 2019 on a new server and moved...
Comments posted to this topic are about the item Disclosing the How
Ask SSC