If you have the timestamp from table A stored (varbinary) in table B, then you can compare those to find out which rows have been updated, and then update the...

"Attachments" to a table??

The problem is that you are using some sort of unique terminology that probably only exists in the company you work for. Unless you define these...

I call mine "Numbers" because Robyn Page and Phil Factor used that in the article that got me using them. http://www.simple-talk.com/sql/t-sql-programming/the-helper-table-workbench/ has a bunch of good stuff on using...

I guess I don't understand your question, then. You said you want to know how to enable the FK, but then you say it's already there ("the two structures...

Good article. I've been looking at virtualization for dev and QA, and the article and discussion are definitely going to affect how I set this up.

You should be able to do this by setting up alerts on the server.

Books Online has an article on this: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/65d2c5c1-921f-4eff-9ef7-149170ab61e8.htm

SSIS is probably the best solution for this. I think you're on the right track.

"Keep Identity" will work so long as the Access tables have the identity data in...

Just to be blunt, your lead programmer who insists on a cursor in that trigger should be told to step away from the database and keep both hands visible. ...

I ended up with the correct-correct data size, and remembered the 2 extra bytes for variable columns, but missed a few of the overhead numbers that Hugo had. Good...

I have a question on the Questions of the Day: Should I limit the complexity of the question by any arbitrary means? Like a specific word-count or anything like...

Simple mode won't necessarily speed them up, but it will help to keep the log file from growing. Any speed increase will really be from not having to stop,...

I've been using Vista since beta, and there are some problems with it, but for the most part, it does a good job for me. I use it at...

Most of the time, I find the QotD at least interesting. I have a personal policy of not looking it up before I try to answer it, but I...

If you turn Identity Insert on, in the import, then you have to provide that data in the import. Otherwise, turn off Identity Insert in the import and make...

I just did a test on a 3-million row table.

Added a varchar(100) column, plugged in some data in all of it (first names, if that matters), and then indexed it.

The...