you can also use the sql profiler

I had the same problem at one time.I deleted the log file and did what Gilamonster said you should do and it worked fine.

Hie

For this i usually use enterprise manager.First detach your database, copy the mdf and ldf files for the db and put them in a seperate location from the current db's...

Hie

is the identity column a part of the primary key.may be put an example of your data so that i can come up with a solution.

Hie

try to customise this strored proc that I got from http://www.sqlteam.com.I think it will solve your problem

Create procedure sp_ParseArray

( @Array varchar(1000),

@separator char(1) )

AS

-- Created by...

The difference lies in the concept.User defined function can be used in a query like the example below shows.I got the example from SQL BOL

*************************

User-defined functions take zero or more...

>Can any one tell me how to export structure of views without any data.

views do not have any data in them when you export them its the definition that is...

i think DTS is a very good option.