Viewing 15 posts - 36,946 through 36,960 (of 39,524 total)
You can do this with WMI. I started down this path and it was annoyingly complex. No good object model.
I may take another look. Testing Patrol right now and...
August 23, 2002 at 10:08 am
don't know the answer, but I wouldn't be surprised if there is a buffer limit. Some funny size limits seem to occur in passing data or returning it at times.
I'd...
August 23, 2002 at 10:02 am
Thanks. I suspected as much. We've seen some other similar issues since then.
The linked server is an AS/400 with millions of rows, so I'm not surprised the linked server is...
August 23, 2002 at 10:00 am
You can if you stop SQL Server. The other alternative is run perform a SQL Backup to a flat file (usually a .bak file) and backup this.
Steve Jones
August 22, 2002 at 3:35 pm
I completely agree with Jay, but I too, like line numbers.
I usually edit stuff in EditPlus and like the line numbers. I wish QA would give them to me, even...
August 22, 2002 at 3:30 pm
what do you mean? run a filesytem .sql file from T-SQL? You can do this with isql and using xp_cmdshell.
Steve Jones
August 22, 2002 at 2:05 pm
I do not believe this is correct. (above post).
In SQL 2000 you can specify whether text data is stored in the row, up to some size.
From Inside SQL Server:
Prior to...
August 22, 2002 at 2:04 pm
Be sure you have test servers that you can afford to have down while you reinstall first.
Then follow Andy's advice. Read about it, and install it. You will probably have...
August 22, 2002 at 1:30 pm
Also, be sure you are storing this data from the SQL server not the ASP server. Will prevent time issues when comparing things.
Steve Jones
August 22, 2002 at 1:28 pm
I think the service account for SQL Server needs to be an account other than Local System.
Steve Jones
August 22, 2002 at 1:23 pm
Embarkadero was pretty good until 2000. Now with templates, color coding, I think QA works great. RapidSQL sorta had VSS integration, but didn't work well for me. Haven't looked...
August 22, 2002 at 1:21 pm
One other nice thing. RapidSQL used to work offline, no SQL needed. However with the personal edition in 2000, not sure this is a big selling point.
Steve Jones
August 22, 2002 at 1:21 pm
In that case, the index build would fail and would essentially be rolled back. At least that's what happened in v6.5 (no autorgrow).
You should have a fair amount of free...
August 22, 2002 at 1:15 pm
Not sure about 7. In 2000, there is sp_settriggerorder.
It also mentions that AFTER triggers are fired in random order.
Steve Jones
August 22, 2002 at 10:08 am
multiprotocol is the easiest. Could use IPSec, PPTP, or others if you want.
Steve Jones
August 22, 2002 at 10:04 am
Viewing 15 posts - 36,946 through 36,960 (of 39,524 total)