Procedure: usp_testddl Procedure: usp_testddl| Property | Value |
|---|---|
| Name | usp_testddl |
| ID | 1847677630 |
| Schema | dbo |
| Owner | dbo |
| Type | SQL STORED PROCEDURE |
| Execute As | Caller |
| Encrypted |
|
| ANSI NULLS |
|
| Uses Quoted Identifier |
|
| Published |
|
| Schema Published |
|
| Execution Replicated |
|
| Replication Serializable Only |
|
| Skips Replication Constraints |
|
| Is Recompiled |
|
| Uses Database Collation |
|
| Null on Null Input |
|
| MS Shipped |
|
| Modify Date | 7/22/2011 7:34:46 PM |
| Create Date | 7/22/2011 7:34:46 PM |
| Script |
|---|
| SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON create procedure usp_testddl as begin declare @sql nvarchar(max) set @sql = N'create table t5000(id int)' exec sp_executesql @sql end |