Stored Procedure Help - SQL Server Forums

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

General SQL Server Forums

New to SQL Server Programming

Stored Procedure Help

Author

Topic

jcb267
Constraint Violating Yak Guru

291 Posts

Posted - 2015-04-02 : 06:54:43

Hello -

I have a fairly large stored procedure that is run through a font end in MS Excel. In the SP, I have a query that creates a temp table. It runs fine for me but appears to be creating problems for others. Do you know if it is a bad idea to have a temp table within an SP??

Thank you and enjoy the day!!

John

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2015-04-02 : 08:38:01

There is nothing wrong with using a temp table in a stored procedure. What kind of error messages are the other users getting? Do they have permission to run the stored procedure?

jcb267
Constraint Violating Yak Guru

291 Posts

Posted - 2015-04-02 : 09:22:00

i got it to work, thanks James! the user said they were exiting sql but they really weren't!!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources