hi,
i try to create storeproc with smo but i 've an exception
"Create failed for StoredProcedure 'dbo.TEST'"
{"Cannot create StoredProcedure '[dbo].[TEST]' if parent is not yet created."}
but sp.parent is created
please help me
attache my work
StoredProcedure sp = new StoredProcedure();
sp.Schema = "dbo";
sp.Name = "TEST";
sp.Parent = new Database(new Server("serveur"), "db_TEST");
sp.IgnoreForScripting = false;
sp.TextMode = false;
sp.ImplementationType = ImplementationType.TransactSql;
sp.Parameters.Add(new StoredProcedureParameter(sp,"@.toto, DataType.DateTime));
sp.TextBody = "Select 1";
sp.Create();
Database db = new Database(new Server(), "db_TEST");
db.Create();
StoredProcedure sp = new StoredProcedure();
sp.Schema = "dbo";
sp.Name = "TEST";
sp.Parent = db;
sp.TextMode = false;
sp.ImplementationType = ImplementationType.TransactSql;
sp.Parameters.Add(new StoredProcedureParameter(sp, "@.toto", DataType.DateTime));
sp.TextBody = "Select 1";
sp.Create();
No comments:
Post a Comment