Viewing 15 posts - 4,321 through 4,335 (of 7,429 total)
BOth NT and 2000 can be enabled to run more than 2GB of memory based on a switch added to the Boot.ini and enabling in SQL. Look at AWE and...
November 11, 2002 at 7:22 pm
I have done things like this in the past without issue. Can you also post your code where you are using ADO to return the data (please alter any security...
November 11, 2002 at 4:36 pm
Can you post the full message text and please post the asp code you use to call this (please alter any security items for safety)? Has to be the way...
November 11, 2002 at 4:30 pm
I have always been told by vendors that it is better to have completely seperate RAID controllers, unless you only have one then using channels is better.
Log and database files...
November 11, 2002 at 4:25 pm
The only way you will be able to do what you are asking is to build a dynamic statment so that you can use a variable to reference the database...
November 11, 2002 at 4:15 pm
First how are you running the app? What options does it give you when the error window pops up? Also, if you know the line will fail then trap it...
November 11, 2002 at 4:12 pm
Not to my knowledge, other than the ones configruable for Server Properties most all items related to databases are in the sys.... tables of each db or in the master...
November 11, 2002 at 4:07 pm
When you install SQL to an NT server it will add serveral counters to Performance Monitor that you can select and use. Check out http://www.sql-server-performance.com there are several helpfull item...
November 11, 2002 at 4:05 pm
The minimum requirement is Pentium 166Mhz, I have even tried it on a P166(which was snail speed in working). As long as you are faster than that doesn't matter brand,...
November 11, 2002 at 4:02 pm
Databases in 2000 cannot be resotred to 7 and 7 databases attached to 2000 servers cannot be moved directly back. There are internal changes made to the file that make...
November 11, 2002 at 3:55 pm
No the database actually lives on the server. ADP files are the project files for the access application, deleting it will not make the DB go away. I would open...
November 11, 2002 at 3:50 pm
Or even better put a marker on the row that is inserted to check for backorder items. Just needs to be a bit and requires no interaction other than a...
November 11, 2002 at 3:47 pm
You should not use wildcards with dates. Dates are not really char types they are numeric type when they are stored and are formated in the output. To get all...
November 11, 2002 at 3:42 pm
Once the condition is over you may not be able too. If the SPID was to an item that has not disconnected them sp_who or sp_who2 may help. If the...
November 11, 2002 at 3:36 pm
Viewing 15 posts - 4,321 through 4,335 (of 7,429 total)