| Author |
Topic |
|
txgeekgirl
Starting Member
18 Posts |
 Posted - 2012-09-13 : 13:22:32
|
| In 2008 R2, trying to create a Trigger - I have it coded out and go to Save - it wants to save as a Stored Procedure. Didn't there use to be a way under File/Save AS to connect to the Table?In 2008, how do you connect to the table? |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2012-09-13 : 13:29:28
|
| ??? CREATE TRIGGER....-Chad |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-09-13 : 13:32:12
|
| what? what do you mean by save as stored proc?so far as you use CREATE TRIGGER it will only create a trigger and not a proc------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
txgeekgirl
Starting Member
18 Posts |
Posted - 2012-09-13 : 14:28:30
|
| Went to the Table/Triggers right clicked Create Trigger - coded the Trigger and wanted to save. It saves as a Stored Procedure and does NOT come up under the Table/Triggers. I need to associate the trigger to that table. |
|
|
|
txgeekgirl
Starting Member
18 Posts |
Posted - 2012-09-13 : 14:30:30
|
| Sorry - it's New Trigger.In the code I have CREATE TRIGGER Trigger Name on Table Name |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-09-13 : 14:31:43
|
quote:
Originally posted by txgeekgirl
Sorry - it's New Trigger.In the code I have CREATE TRIGGER Trigger Name on Table Name
sorry i dont understand whats your actual issue yet!------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
txgeekgirl
Starting Member
18 Posts |
Posted - 2012-09-13 : 14:34:46
|
| The code with the Trigger does not show under the Table/Triggers area - it is stored in Projects. I need it to be tied to that table. There are a million different examples on how to create a trigger but none on how to associate the trigger with a particular table in the Management Studio. |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2012-09-13 : 14:36:43
|
| Did you execute it? You have to execdute the CREATE TRIGGER code for the trigger to actually get created (And show up under Table->Triggers-Chad |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-09-13 : 14:37:05
|
quote:
Originally posted by txgeekgirl
The code with the Trigger does not show under the Table/Triggers area - it is stored in Projects. I need it to be tied to that table. There are a million different examples on how to create a trigger but none on how to associate the trigger with a particular table in the Management Studio.
once you execute the trigger code you'll be able to see the trigger within associated tables in object explorer. you may need to refresh it once to reflect latest trigger info though!------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
txgeekgirl
Starting Member
18 Posts |
Posted - 2012-09-13 : 14:39:20
|
| Visakh16 - thank you so much! |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-09-13 : 14:40:10
|
| did you spot it?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2012-09-13 : 14:41:29
|
quote:
Originally posted by txgeekgirl
Visakh16 - thank you so much!
I thought I said the same thing first  -Chad |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-09-13 : 14:50:58
|
quote:
Originally posted by chadmat
quote:
Originally posted by txgeekgirl
Visakh16 - thank you so much!
I thought I said the same thing first -Chad
I think catch was on suggesting to refresh  ------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
TRIGGERS