Thanks for the reply . Those are actually 6000 lines of Insert into table statement to insert data... Can u please tell me the name of the undocument stored procedure...

Before inserting,

I SET DATEFORMAT ymd

and now it works fine. I am no more getting this error. May be this is the solution as you suggested earlier

Problem is solved.

Since I was connecting to SQL 2000 database and ALTER LOGIN command does not exist in SQL 2000 and exists in 2005 onwards, my commands were failing. Instead...

I am connecting to SQL 2000

I had by chance deleted the default database for my login id. But now when I try to login , I get the error

)...

When I try to execute the query

USE master;

SELECT *

FROM fn_my_permissions(NULL, 'SERVER');

GO

I get the error message

Invalid object name 'fn_my_permissions'.

The Database is in Simple Recovery Mode. Where will the log files be stored ? Can you paste a pic of the location.

Hi,

Thanks for the help. Now I am able to script out the database

i.e. Right click on your database -> Tasks -> Generate scripts and follow up the wizard

and am...

I just added GO statements between those scripts for triggers and it started to work again. Here is the working script.

--BEGINING OF INSTEAD OF TRIGGER FOR DELETE on TABLE_A-------

...