Viewing 15 posts - 37,216 through 37,230 (of 39,720 total)
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
Yepper, this is the case. Can cause frame of reference issues (like local paths).
It's a design decision. I run many from the server, but it can be like a program....
August 6, 2002 at 12:31 pm
No easy way. I've seen some complicated SQL (using count() and subqueries), but nothing I'd recommend. Any reason not to do it on the client?
Steve Jones
August 6, 2002 at 12:29 pm
I have had issues with the install, but that was early on. I know there are some Q articles about workarounds, but we experienced corruption and strange unreproduceable errors. Following...
August 6, 2002 at 12:27 pm
I think it's a matter of design. functions are usually reused in your code somewhere and can be cleaner than calling a stored procedure (like in a select statement). Otherwise...
August 6, 2002 at 12:22 pm
Your packages are in MSDB, restore this, not master.
Steve Jones
August 6, 2002 at 12:16 pm
Not bashing Fox, in fact, I used Visual Fox (first version) to rewrite a Fox for DOS app into Windows with a SQL 65 backend. It worked great, though in...
August 6, 2002 at 8:31 am
There are great explanations in Inside SQL Server for SQL 2000. Some are in tempdb, some are populated as you retrieve rows. Depends.
For your cursor, it is accepting default options,...
August 6, 2002 at 8:27 am
Viewing 15 posts - 37,216 through 37,230 (of 39,720 total)