Dear Eko, Coba sintax ini, aku kopi dari SQL Books Online : 1. untuk detach DB : USE master; GO EXEC sp_detach_db @dbname = N'pubs'; GO 2. Untuk attach DB :
USE master; Go EXEC sp_attach_db @dbname = N'pubs', @filename1 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs.mdf', @filename2 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs_log.ldf'; GO Catatan : database yang diattach / detach adalah database PUBS, silahkan modif sesuai keinginan. semoga membantu Best Regards, Dhani Aristyawan, S. Kom. IT Supervisor PT. ALP Petro Industry Desa Kebonsari - Legok Pasuruan - 67155 Phone : +62 343 853308 Ext. 62 FAX : +62 343 853307 Visit me @ <http://dasmaniacool.blogspot.com/> http://dasmaniacool.blogspot.com _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of eko_hariyanto_mdn Sent: Wednesday, July 25, 2007 8:25 AM To: [email protected] Subject: [indoprog-vb] T-SQL hi temen2... ada yg tw ga t-sql untuk attach database di sql server 2000 klo ada yg tw sharing ke aq pliss... thx best regard [Non-text portions of this message have been removed]
