SQL Server Performance

Restriction on creating Table Variables

Discussion in 'SQL Server 2008 General DBA Questions' started by Jayakumar.s, Feb 17, 2010.

  1. Jayakumar.s New Member

    Is there any way to restrict the creation of table variable and inserting into that variable ?
  2. FrankKalis Moderator

    Welcome to the forum!
    No, afaik, you can't keep someone from declaring a table variable. However you could possibly control it with via restricting SELECT permissions used in the INSERT statement. What your reason for asking?

Share This Page