Triggers in sql server

[Elad]

Hello!
How to create trigger on remote server?
(Sql server)

CREATE TRIGGER
[dbo].my_trigger_name
ON [ip/ server name].[table_name]
AFTER UPDATE
AS
{sql_statements...}

 

[Skydiver]

How is this a C# question?

 

[Elad]

How is this a C# question?

How is this a C# question?

I did not really understand?
I posted on the sql category no c #

 

[Skydiver]

If you look at the description of the SQL Server subforum, it says:

Discussion related to SQL Server and MSDE with C# development

Where is the C# development part of this question?

Would you ask about how to get your fingers unstuck after accidentally supergluing them together in the "glues" subforum of a woodworking forum?

 

[Elad]

If you look at the description of the SQL Server subforum, it says:


Where is the C# development part of this question?

Would you ask about how to get your fingers unstuck after accidentally supergluing them together in the "glues" subforum of a woodworking forum?

Okay, so I did not notice that mistake.
can you help anyway?

 

[Skydiver]

Most people would just run the SQL commands to create the trigger. What problem or errors are you running into?

 

[JohnH]

It can be done in C# with SMO: Creating, Altering, and Removing Triggers - SQL Server

 

[Joelias]

I Wish to select all store procedures with its contents from Database and records all in a folders. Is this possible using SMO?

 

[alexhortdog95]

Let me help you.....

If you get the inkling to create a trigger.....

DON'T.