According to my experience,first one is more fast then other .

Check this spid in using sp_who2 proc,and check whether its wait for other request id(may be deadlock condition)

I don't know about partial backup .can any guys help me?

Its depends on requirement,any one will not always correct...

Good....

hi da-zero

you are right and also that is mention in msdn.

but we can do both by this statement,either insert explicite or implicit.for more clearity ,it should be include.

Both Question and answer don't have sufficient information about target.

What is the purpose of IDENTITY_INSERT ?

And answer

SET IDENTITY_INSERT allows explicit values to be inserted into the identity column of a...

Then,How we will restore this?

Just spelling changes?

i am sure with 2000 but asume that ssms.exe.so i was also wrong.

Thanks for this..............

I successfully created a view that already contain a image column.

what i say about your answer selection?

SQL Server does not support online restore from a snapshot backup. Restoring a snapshot backup automatically takes the database offline.

For more info visit url

http://msdn.microsoft.com/en-us/library/ms189548.aspx

Good question and best answer.

i never take any idia about this type problems.+

thanks

Answer should be nchar(1),if your have wide thinking about your data.