February 2, 2010 at 12:31 pm
I need to copy a database but have no information in it. (need the fields & tables & such, just no data).
February 2, 2010 at 1:24 pm
as part of the sp_addarticle procedure used to publish the articles for replication, one of the parameters is @filter_clause. I've never used it, but you could potentially put a filter clause on the article where it wouldn't return any rows (1=0).
For better, quicker answers, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 2, 2010 at 1:32 pm
Have you looked at the Generate Scripts option in Management Studio? That'll create all the objects in a database, without any data.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply