how can i achieve throu SMO

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ramesh Subramaniyan - 03 Jul 2008 10:40 GMT

EXEC sys.sp_bindefault @defname=N'[dbo].[def_UserID]',
@objname=N'[dbo].[tAA_MAD_Type4].[InsertedBy]' , @futureonly='futureonly'
GO

Reply to this Message

EugeneZ - 03 Jul 2008 12:53 GMT

try C#
see example:
http://www.megasolutions.net/Sqlserver/SMO_running-a-stored-procedure-in-C--6890
3.aspx

--
also see:
How to: Create, Alter, and Remove a Stored Procedure in Visual Basic .NET
http://msdn.microsoft.com/en-us/library/ms162553.aspx

Signature

http://www.sqldbatips.com/showarticle.asp?ID=34
and
http://www.sqlservercentral.com/articles/Stored+Procedures/usingparameterswithst
oredprocedures/2004/
Thanks,
Eugene Zhitomirsky
MCT, MCDBA, MCP, OCP

> EXEC sys.sp_bindefault @defname=N'[dbo].[def_UserID]',
> @objname=N'[dbo].[tAA_MAD_Type4].[InsertedBy]' , @futureonly='futureonly'
> GO

Reply to this Message