It's great question and very useful discussion and worth to read. Thanks a lot for wonderful explanation.:-)

very nice article and must read article.

one question is every thing is true for sql 2008 or not ?

It's just great and i almost learn all the things about the Profiler.

Thanks for the Great Tutorials and i am looking forward in future so

learn like this.

how i give the usrename and password in the sql command?

:setvar Maindbserver "NHSserver"

:setvar Maindb "NHS_031209"

:Connect $(Maindbserver)

go

$ maindb

this is my code.

in this script how i can give user name...

Fatal scripting error. Cannot open connection specified in the SQLCMD script.

Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

i got like that error when i...

that is nice article.thnks for it.

but one thing is i dotn want recover from

log.

i need solution for how i can not inert in to

the log files

is there any...

Thanks for Support and answering my Question.

i got the solution for the Order by in sub Query ok thanks.

Thanks I understand what u said ok

so if Primary key then there no solution for the DBCC COmmand

but you can insert duplicate value in the table.

One more Question it...

I know Indentity_Insert = On .

my questiion is

Suppose there is one table and it has one primary key it's type is Integer.

currrenlty this table has 20 rows but...

That's right but then

what is the use of the set indentity ?

if we set it to max no value in the table.

so there no change in the table after...

but what about current data in the Table

what we do for this data ?

any solution because we set primary key for the identity column

so what happned for that...

This is NIce script but when ever NULL comes it's not working

and we need GO at the end of the every insert statement

so please add the go statement and...