 |
|
|
|
Next: datetime debug arg
|
| Author |
Message |
External
Since: Mar 06, 2007
Posts: 9
|
(Msg. 1) Posted: Mon Feb 05, 2007 2:20 pm
Post subject: table modification history
Archived from groups: microsoft>public>sqlserver>programming (more info?)
|
|
|
|
|
| Back to top |
|
 | |
| Related Topics: | Help with group by on log history table, optimization and .. - We have a table were we store log4net entries with a datetime. I created a query that returns a resultset per day of the last 14 days where each log entry type is summed. 1. When I just look at the query it seems that is can be optimized *heavily* but ...
History of data for documents - Hello, I have following situation: CREATE TABLE [dbo].[Address] ( <font color=purple> ; [Id] uniqueidentifier ROWGUIDCOL NOT NULL ,</font> <font color=purple> ; [CityId] [uniqueidentifier] NOT NULL ,</font> <...
Relational "history," ala, data-audit trail - Long story short: small company, 1 technical called upon to perform several roles. I've created a web-site allowing users to edit/insert/delete records. There are 8 tables involved here. The DB is relational. I have the task now of creating a site that..
Selecting job history information from sysjobhistory in msdb - Hi all, using SQL 2000 When selecting "message" column from "sysjobhistory" table, doesn't contain the entire error message compared to the job history option, from right clicking on a certain job under SQL Server Agent - Jobs. For...
Joining history records with matching record versions - Here is a tough question for you... I have a database in which there are many parent/child tables, and history tables for both the parents and the children. All tables have a timestamp representing the moment the record was updated (both parent, child,... |
|
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum
|
|
|
|
|
|
|
FAQ
Search
Profile
Private Messages
Log in
