Problem inserting data in SQL Server 2000
-
Hi, I have faced a problem while inserting data into the sql server 2000. First I have made a database and related Store procedure in SQL Server 2005. When I run a store procedure in SQL Server 2005, it works fine. But I have generated SQL script from SQL Server 2005 and run in Server 2000 (after some changes in script). Tables and store procedure are created in SQL Server 2000. Then I made a database user and allow it all permissions (Set this user as dbo). When I insert data into the sql server 2000 table it runs the store procedure but no insertion will take place
-
Hi, I have faced a problem while inserting data into the sql server 2000. First I have made a database and related Store procedure in SQL Server 2005. When I run a store procedure in SQL Server 2005, it works fine. But I have generated SQL script from SQL Server 2005 and run in Server 2000 (after some changes in script). Tables and store procedure are created in SQL Server 2000. Then I made a database user and allow it all permissions (Set this user as dbo). When I insert data into the sql server 2000 table it runs the store procedure but no insertion will take place
May I see the full script with storred procedure which you have ran on sql server 2000 db