无法使用存储过程在SQL Server2008上创建表 [英] Unable to create table on SQL server2008 using stored procedure

问题描述

我创建了一个存储过程，该过程选择一些值，创建一个临时表并将选择值存储到临时表中，最后删除该临时表.
当我在本地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.

这篇关于无法使用存储过程在SQL Server2008上创建表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！