Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
fvinagre
Starting Member
29 Posts |
 Posted - 2004-11-22 : 11:24:42
|
| Dear Dbas:I have an small database with 2 tables. First table (Results) contains information of the msbd database of 70 sql servers. I load the data using DTS's. Exist one DTS for each server.The DTS runs every day at 9:00 AMThe second table (Servers) contains a list of servers to control if all the servers has send the data every dayHow can I compare both tables to ensure that the all servers send the data?Best RegardsFernando My question |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-11-22 : 12:55:13
|
| Post the DDL of the tables for a startBrett8-) |
 |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2004-11-22 : 13:10:43
|
| What about putting a column in the Results table:alter table Results add regdate not null default(getdate())rockmoose |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-11-22 : 13:31:28
|
well probably a join between two tables on server_name or some other relation key would do.and those that don't return a row aren't sent, no?but as brett said: post the DDL (Create table statements)Go with the flow & have fun! Else fight the flow  |
|
|
|
|
|
|
Compare SQL Server tables