Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag attach Rss

   Items 1 to 7 of 7   
 

Change Server Collation in SQL Server 2008

How can I change the collation of SQL Server 2008? Learn how in this short tutorial.  Read more...
By Kevin Sermijn 2011/03/15 | Source: SQLServerCentral.com | Category: collation
Rating: |  Discuss |   Briefcase | 5,920 reads

Moving Database Files Detach/Attach or ALTER DATABASE?

Learn why ALTER DATABASE should be preferred over Detach/Attach for moving database files on the same SQL Server from MVP Jonathan Kehayias.  Read more...
By Jonathan Kehayias 2010/09/24 (first published: 2009/05/27) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 28,869 reads

Dynamically script Create Database For Attach For All Databases

Modified version of a script that can be found at http://www.sqlservercentral.com/Contributions/InstallEditor   Read more...
By David Benoit 2010/05/20 | Source: SQLServerCentral.com | Category: attach
Rating: |  Discuss |   Briefcase | 2,967 reads

Moving Databases with the ALTER Command

A script that will move the files of a passed set of databases to a new data folder and log folder from James DiMauro.  Read more...
Rating: |  Discuss |   Briefcase | 8,360 reads

Attaching a database in Microsoft SQL Server 2008

Various methods of using the "For Attach" clause exist to overcome the limitations that face us when using sp_attach_db and sp_attach_single_file_db. The first installment illustrates the use of the "Create Database" statement for the "For Attach" and "for ATTACH_REBUILD_LOG" arguments, for a single .MDF file and single .LDF file.  Read more...
By Additional Articles 2009/08/24 | Source: Database Journal | Category: sql server 2008
Rating: (not yet rated)  Rate this |   Briefcase | 2,488 reads

Dynamically script Create Database For Attach For All Databases

Modified version of a script that can be found at http://www.sqlservercentral.com/Contributions/InstallEditor   Read more...
By David Benoit 2010/05/20 | Source: SQLServerCentral.com | Category: attach
Rating: |  Discuss |   Briefcase | 2,967 reads

Moving Database Files Detach/Attach or ALTER DATABASE?

Learn why ALTER DATABASE should be preferred over Detach/Attach for moving database files on the same SQL Server from MVP Jonathan Kehayias.  Read more...
By Jonathan Kehayias 2010/09/24 (first published: 2009/05/27) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 28,869 reads
   Items 1 to 7 of 7   
 
Tags
detach (3)    
administration (2)    
sql server 2008 (2)    
alter database (1)    
alter database modify file (1)    
collation (1)    
show advanced options (1)    
xp_cmdshell (1)