Viewing 15 posts - 37,306 through 37,320 (of 39,818 total)
add up the results.
Why do you need this? It's not necessarily a useful number.
Steve Jones
August 8, 2002 at 4:05 pm
If you can mark record to timestamp them,
Use SQL instead, something like this pseudo
select top xx rows from your table that INNER JOIN with the other database and perform updates...
August 8, 2002 at 3:57 pm
You are welcome. Let us know if something doesn't work right.
Steve Jones
August 8, 2002 at 9:29 am
They are stored as binary and retrieved with a select statement, like any other field.
The trick is on the front end. It has to be able to read the values...
August 8, 2002 at 9:18 am
negative. No attach. You must restore, which can be tricky. Your segment and device layout must be the same. Be sure you script the database creation exactly on the old...
August 8, 2002 at 9:16 am
For saving and recovering packages:
http://www.sqlservercentral.com/columnists/sjones/recoverthosepackages.asp
links to the save article inside.
Steve Jones
August 8, 2002 at 9:07 am
Entirely possible. The Windows protection should prevent older files from being written. I'd suspect that SQL might write older files than SP2. Install SQL 7, add the service packs and...
August 8, 2002 at 8:39 am
If I run this in Northwind, it works
select orderid, customerid
from orders
for xml auto, elements
Not sure what the issue is for you. Are you running this from QA?
Steve Jones
August 7, 2002 at 4:45 pm
Don't believe this is possible. i think you will need to restore to v6.5 and then DTS or make some other type of copy.
Steve Jones
August 7, 2002 at 4:42 pm
Services will shutdown for an orderly shutdown.
If this is just for SQL, and you do not need to reboot the server (sometimes you do and sometimes not), you can make...
August 7, 2002 at 9:45 am
I'd just let the app check every xx seconds. It's going to do this in the background anyway with your solution. I'd also just check a table for a new...
August 6, 2002 at 12:38 pm
I emailed them and am waiting for some more technical documentation, but it uses replication. I suspect instant transactional replication to work. With scripts for the failover.
Steve Jones
August 6, 2002 at 12:35 pm
Use tinyint or a datetime instead. Easier to track.
Steve Jones
August 6, 2002 at 12:33 pm
Viewing 15 posts - 37,306 through 37,320 (of 39,818 total)