Viewing 15 posts - 37,141 through 37,155 (of 39,769 total)
Try using the OLEDB for ODBC driver and pointing to a DSN for the dbase file.
Steve Jones
September 6, 2002 at 10:09 am
no. the table will be altered and the contraint must be removed first.
Steve Jones
September 6, 2002 at 10:01 am
There is no good way to do this. Andy has some suggestions that will work, but are a hassle.
Best idea would be to administratively handle this. Use auditing or a...
September 6, 2002 at 9:59 am
Detatch should work.
I used Andy's article to move from one box to another here. Std to Ent are the same versions, more features enabled in Ent.
Steve Jones
September 6, 2002 at 9:56 am
I believe it connects to the IPC$ share or to port 445 to poll the server and see if it is running. Not sure if this would result in an...
September 6, 2002 at 9:54 am
I know that the default instance, EM uses 445 to connect as well as 1433, 1434. Are you using some redirection with SSH?
Steve Jones
September 6, 2002 at 9:51 am
be very very careful with this. Like dynamic sql, this is asking for an injection attack.
Is there a reason not to use isql or osql?
Steve Jones
September 4, 2002 at 2:22 pm
the gains from a middle tier come (with a well designed app) from offloading CPU cycles from the web server and the sql server onto another box. Like crunching numbers...
September 4, 2002 at 10:40 am
Not sure you can. I'd suspect this is in the registry or a cfg file if you can. Most likely it's hard coded.
Steve Jones
September 4, 2002 at 10:30 am
Most likely the tape is too full and it's not set to overwrite the tape.
Steve Jones
September 4, 2002 at 10:14 am
You can attach this without shutting down the server.
Steve Jones
September 3, 2002 at 3:59 pm
Either that or detach/attach. Raul Sharma has an article on usnig that on this site.
Steve Jones
September 3, 2002 at 9:56 am
The speed of SS2K is plenty, just depends how things are implemented. There are lots of tricks you can do, use triggers to keep a summary of data current in...
September 3, 2002 at 9:48 am
Depends on load. For smaller apps, I've dropped everything on the same RAID 5 and no big deal. Nice to separate out, so if you move the hardware later, the...
September 3, 2002 at 9:42 am
Viewing 15 posts - 37,141 through 37,155 (of 39,769 total)