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.
| Author |
Topic |
|
calvinfoo
Posting Yak Master
129 Posts |
 Posted - 2012-04-01 : 22:00:51
|
| Dear Gurus,I copied my ASP script to another server, it works fine on the Development server, but when I run it on the Live Server, it does not work, it is basically calling a Stored Procedure to SELECT, duplication check, then INSERT statement.Permission problem?1. Return Record set - no problem2. Insert/Update SQL Statement with same login - no problem3. Call SP to return a record set - no problem.I can only narrow it down until call the SP to Insert having difficulty.Please advise. |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2012-04-02 : 14:19:42
|
| >>"does not work"why not? is there an error returned? if so post it. Try using Sql Profiler to capture the call to the database. perhaps the actual call is not what you expect it to be.Be One with the OptimizerTG |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-04-02 : 15:45:36
|
| sounds like issue is with retrieval of data at asp side if proc is working fine------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Unable to call SP to Update/Delete