already answered

http://www.sqlservercentral.com/Forums/Topic990901-391-1.aspx

have a look of this post :-

http://it.toolbox.com/wiki/index.php/Find_all_the_triggers_in_a_database..

if you not able to open it then 2 query mentioned there as:-

SELECT S2.[name] TableName, S1.[name] TriggerName, CASE WHEN S1.deltrig > 0

THEN 'Delete'...

what if you try with dettach and attach?

thanks for correcting me Gail.

most of the time there is deadlock in between of us and then my daughter give priority to mom SPID and kills mine .......

yuppyyy....finally someone understand me....will show this proof to my wife....:-D 😀 😀 😀

ok, are you able to connect using sqlcmd...

try with sqlcmd and let us know if you have same error ..

At the command prompt, type the following command, and then press...

this value you can compre using between operator.

I might not be getting your queries correctly, can...

where to between 45(or whatever you want to start compre from) and 65(till what you want to compare)

so just ex :-

if you looking between value in 45 to 65 then

where...

ok, is your TCP/IP protocol enabled?

Check in configuration manager--sqlserver network configuration--protocol for mssqlserver.

it might be disabled. Enable it and try to connect.

have a look of this article ..

http://support.microsoft.com/kb/173907

is sql enabled for mixed mode authentication or only windows authentication?

you can create a SP which will call other SP based on your if, else condition

have you tried between operator....

where .... between 45 and 65 ..... or whatever you want to put in between

few questions to dig the problem further :-

is your log are getting over written by new?

if you think its the copy step then try to configure some other location to...