Hi:
I have thought that TSQL Store Procedure IS COMPILED, but I'm proving Store Procedure SQLCLR (asembly in SQL SERVER 2005) ,
and now I think that TSQL is only a script TSQL stored in the
DB.... I'm wrong
Thanks for your comments!
TSQL Store Procedure is really COMPILED?
Hot Topic
- Printing Reporting Services Reports from a Access Report(VBA)
- Guidelines for creating a database snapshot on a mirror database
- How Can I retrieve Sql 2000 Encrypted Column Data From SQL 2005 Stored Proc?????
- Generating and Printing Reports
- Restore a set of databases from a SQL2000 server to a SQL2005 server
- 64 Bit SQL Server try to access 32-Bit
- Can't Call Stored Procedure in SqlFunction
- connection time outs in a script component
- Can not see columns in query "Design View"
- Search for data inside a Recordset Destination
SQL Server
- apologies for the multiple postings with the title "crossjoin problem?" - having problem deleting the duplicates
- MDX Query
- How can i transfer a database from Access to Sql Server 2000?
- remote connection
- Grant Database Access
- Update XML Source and generate new xml
- Display Vlaue
- Lock out user for database structure update
- Analysis Server database stop responding...
- SP2 and BackupExec means failure
TSQL Store Procedure is really COMPILED?
DSent
Thanks!
mikalush
Have a look here for more information http://www.microsoft.com/technet/prodtechnol/sql/2005/recomp.mspx
HTH, Jens K. Suessmeyer.
----
http://www.sqlserver2005.de
----