Viewing 12 posts - 1 through 12 (of 12 total)
It's great question and very useful discussion and worth to read. Thanks a lot for wonderful explanation.:-)
February 14, 2012 at 11:26 pm
very nice article and must read article.
one question is every thing is true for sql 2008 or not ?
August 10, 2009 at 5:53 am
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.
May 19, 2009 at 3:57 am
how i give the usrename and password in the sql command?
:setvar Maindbserver "NHSserver"
:setvar Maindb "NHS_031209"
this is my code.
in this script how i can give user name...
March 24, 2009 at 6:07 am
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...
March 24, 2009 at 5:11 am
that is nice article.thnks for it.
but one thing is i dotn want recover from
i need solution for how i can not inert in to
the log files
is there any...
February 19, 2009 at 2:10 am
Thanks for Support and answering my Question.
i got the solution for the Order by in sub Query ok thanks.
January 21, 2009 at 2:16 am
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...
January 20, 2009 at 11:40 pm
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...
January 20, 2009 at 11:07 pm
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...
January 20, 2009 at 9:31 pm
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...
January 20, 2009 at 7:23 am
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...
January 20, 2009 at 7:11 am