Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Store Procedure

Author  Topic 

raguyazhin
Posting Yak Master

105 Posts

Posted - 2011-01-19 : 01:44:01

We Using SQl Server 2005 SP4 For ASP .Net Application
in this application run a store procedure no affect the records in DB
but Manually run a Store procedure in SSMS in it affect the records.

what is the problem?

please suggest me.

--
Ragu Thangavel
Junior SQL Server DBA

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2011-01-19 : 03:05:36
are you running it in the correct database ?

is the login user from the App has the necessary insert / update rights on the tables ?


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page
   

- Advertisement -