Viewing 7 posts - 1 through 7 (of 7 total)
You should be able to link the tables to the SQL data from the access database. From my past experiences with doing this it will work and you get...
July 5, 2012 at 4:02 pm
I think the QOD's are great. They get you thinking and researching the answers if you don't know them. I feel this will make me a better administrator/programmer.
The problem lies in...
March 2, 2004 at 4:12 pm
I agree with Amit. I got my answer from books-online (SQL2k sp3 Updated), and even tried it on a test table. I received no errors from query analyser.
March 1, 2004 at 11:17 pm
Thanks for that Jonathon.
The rowstamp field is a timestamp.
I did try using just the rowstamp in my testing, but soon discovered that some entries were inserted out of sequence rowstamp...
October 29, 2003 at 5:34 pm
Create a task that backs up the main database and restores it to the test database
using scripts similar to the following:
BACKUP DATABASE [<DBName>] TO DISK = N'Replication.BAK' WITH...
October 22, 2003 at 11:57 pm
Whether you go for 15k discs of 10k like has already been said depends on teh hard drive load. I would probably go for the 15k drives, as databases...
October 13, 2003 at 10:12 pm
I had a lot of trouble with DTS packages, until i tried a different "Loading" method. Using the method you use, I was unable to get the package to...
October 13, 2003 at 1:40 am
Viewing 7 posts - 1 through 7 (of 7 total)