Click here to Skip to main content
15,921,203 members
Home / Discussions / Database
   

Database

 
QuestionData Table and Data View Questions Pin
HurricaneDan2-Jul-07 15:15
HurricaneDan2-Jul-07 15:15 
QuestionSQL 2005 Remote Connection Error Pin
Amit Kumar G2-Jul-07 15:04
Amit Kumar G2-Jul-07 15:04 
AnswerRe: SQL 2005 Remote Connection Error Pin
Sathesh Sakthivel2-Jul-07 16:25
Sathesh Sakthivel2-Jul-07 16:25 
AnswerRe: SQL 2005 Remote Connection Error Pin
Sgg2453-Jul-07 1:26
Sgg2453-Jul-07 1:26 
QuestionWhy is it called "Hibernate"? Pin
David Veeneman2-Jul-07 12:59
David Veeneman2-Jul-07 12:59 
AnswerRe: Why is it called "Hibernate"? Pin
originSH2-Jul-07 22:34
originSH2-Jul-07 22:34 
QuestionScript-generating commands? Pin
PIEBALDconsult2-Jul-07 10:20
mvePIEBALDconsult2-Jul-07 10:20 
AnswerRe: Script-generating commands? Pin
Mike Dimmick2-Jul-07 11:01
Mike Dimmick2-Jul-07 11:01 
You can right-click the database in Enterprise Manager, select All Tasks, Generate SQL Script. From there, click Show All. Then select the tables and views that the triggers are attached to and click Add to move them to the 'Objects to be scripted' box. On the Options tab, check Script Triggers.

That will get you the table definitions as well as the triggers. I don't know of a way to just get the triggers.

The contents of stored procedures, triggers etc are stored in the syscomments table.

Stability. What an interesting concept. -- Chris Maunder

GeneralRe: Script-generating commands? Pin
PIEBALDconsult2-Jul-07 11:45
mvePIEBALDconsult2-Jul-07 11:45 
QuestionDifference between sql server 2000 and 2005 Pin
Malayil alex2-Jul-07 8:16
Malayil alex2-Jul-07 8:16 
AnswerRe: Difference between sql server 2000 and 2005 Pin
Pete O'Hanlon2-Jul-07 9:40
mvePete O'Hanlon2-Jul-07 9:40 
AnswerRe: Difference between sql server 2000 and 2005 Pin
leckey2-Jul-07 11:45
leckey2-Jul-07 11:45 
QuestionSubquery returned more than 1 value Pin
Sam Heller2-Jul-07 5:47
Sam Heller2-Jul-07 5:47 
AnswerRe: Subquery returned more than 1 value Pin
jonathan152-Jul-07 6:56
jonathan152-Jul-07 6:56 
GeneralRe: Subquery returned more than 1 value Pin
Sam Heller2-Jul-07 7:00
Sam Heller2-Jul-07 7:00 
GeneralRe: Subquery returned more than 1 value Pin
jonathan152-Jul-07 7:09
jonathan152-Jul-07 7:09 
GeneralRe: Subquery returned more than 1 value Pin
Sam Heller2-Jul-07 9:53
Sam Heller2-Jul-07 9:53 
AnswerRe: Subquery returned more than 1 value [modified] Pin
Harini N K3-Jul-07 0:58
Harini N K3-Jul-07 0:58 
GeneralRe: Subquery returned more than 1 value Pin
Praveen02928-Aug-07 0:29
Praveen02928-Aug-07 0:29 
AnswerRe: Subquery returned more than 1 value Pin
DQNOK3-Jul-07 5:05
professionalDQNOK3-Jul-07 5:05 
Questionsecure DB Pin
merwa2-Jul-07 0:21
merwa2-Jul-07 0:21 
AnswerRe: secure DB Pin
leckey2-Jul-07 11:48
leckey2-Jul-07 11:48 
AnswerRe: secure DB Pin
Mike Dimmick2-Jul-07 12:28
Mike Dimmick2-Jul-07 12:28 
QuestionMSAccess Pin
nitin32-Jul-07 0:19
nitin32-Jul-07 0:19 
AnswerRe: MSAccess Pin
martin_hughes2-Jul-07 0:29
martin_hughes2-Jul-07 0:29 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.