Wednesday, March 21, 2012
Need Data for Titleauthor
triggers, I deleted all the data in the titleauthor table. Where an I get
the original data to import? Lesson learned....should have had a back-up!Sash wrote:
> Sorry to post something so silly. In doing a homework assignment on
> triggers, I deleted all the data in the titleauthor table. Where an
> I get the original data to import? Lesson learned....should have
> had a back-up!
See the instpubs.sql file in the C:\Program Files\Microsoft SQL
Server\MSSQL\Install folder on the server.
--
David Gugick
Imceda Software
www.imceda.com
need brief answers
how queries run by MSDE
how stored procedures run in backend by MSDE
how triggers run by MSDE
where triggers and stored proc stored in MSDE and in which form
where logs are being maintained of transactions/DML statement by default
what are pseudo tables - Never heard of them, you may mean Derived Tables (A table created in a query that lives only during that query), or Views (a sql statement describing a virtual table)
how queries run by MSDE - You have to use a tool, like Query Analyzer or a client application to send queies to the MSDE engine
how stored procedures run in backend by MSDE - Same as above
how triggers run by MSDE - Triggers are run automatically by the database engine when the proper event happens to a table with a trigger on it.
where triggers and stored proc stored in MSDE and in which form - They are stored in system tables, you access them to create and edit them through Enterprise Manager or writing a DDL query in Query Analyzer
where logs are being maintained of transactions/DML statement by default - The log file(s) are where ever you tell the database to put them when you create a database. By default I think they are in the <SQl Server install location>\Data folder.