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)
 drop command issue

Author  Topic 

ajith_ad
Starting Member

3 Posts

Posted - 2012-03-20 : 01:42:29
Hi,
I am using a Stored procedure in which I am creating a table and droping that table at the end of execution. This SP is calling every 10 second (but no concurrent access) from my application. Is there any issue using the drop table command in the SP? will it create any memeory fragmentation issue in SQL server?

X002548
Not Just a Number

15586 Posts

Posted - 2012-03-20 : 02:07:03
why are you creating the table? Is it a temp table?

Post the code of what you are doing please

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx


Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/


Go to Top of Page
   

- Advertisement -