无法使用存储过程在SQL Server2008上创建表
问题描述:
我创建了一个存储过程,该过程选择一些值,创建一个临时表并将选择值存储到临时表中,最后删除该临时表.
当我在本地sql服务器中运行此存储过程时,此存储过程工作正常,但在Web上尝试此问题时出现问题.
存储过程无法创建和删除该临时表.
那么任何人都可以告诉我如何解决此问题吗?
在此先感谢.
I have created a stored procedure which select some value, create a temp table and store the select value into the temp table and finally drop that temp table.
This above stored procedure works fine when i am running this in my local sql server but the problem arise when i am trying this on web.
The stored procedure unable to create and drop that temp table.
So can anyone please tell me how to solve this issue?
Thanks in advance.
答
它可能与SQL Server的权限有关.确保要连接的用户对要连接的数据库具有创建/删除权限.
It is probably related to permissions on SQL Server. Make sure the user you are connecting as has create/drop permissions on the database you are connecting to.