Viewing 15 posts - 91 through 105 (of 302 total)
I'm not a DB2 person either but we do have an ODBC connection to one. We are using an IBM DB2 version 7 driver, and the info that works for...
October 26, 2006 at 6:21 am
Do you reindex the tables regularly on the cluster? Are the databases the same size (the test server & cluster)? Are there cluster errors in the NT logs? Do you...
October 24, 2006 at 10:31 am
I really doubt that attaching / detaching a database would affect performance. You said "we did detatch this copy of the online database during last nights EOD run, and the...
October 19, 2006 at 8:55 am
I tested the procedure using LogParser and it's exactly what I need. Thanks again!
October 18, 2006 at 12:07 pm
Wow. That looks interesting and may do the trick, but I may have to jump through a few hoops to get the LogParser installed on both nodes of the cluster...
October 18, 2006 at 10:37 am
Selecting the opton will change the port to 1434. Make sure that won't matter to how your application connects.
October 16, 2006 at 11:37 am
Actually, you can place the system databases on another drive during the installation--ours are currently located on D. There is an option during the installation to change the location of the data...
October 12, 2006 at 10:08 am
Good for you! I've discovered that quite a few applications are built on the 'sa' account (or an account with sysadmin privileges) just because they were developed that way--security wasn't...
October 5, 2006 at 10:51 am
Well, since we have RAID 5 I may need to wait. Our server is going off lease next year and we won't be using it (thankfully). Also, next year we are...
October 4, 2006 at 8:59 am
We used to get out of memory errors on a linked server to Oracle until I added a startup parameter to SQL Server. See Books on Line topic "Using Startup...
September 26, 2006 at 8:37 am
Happened to me once before. Try looking here: Go to the toolbar and select Tools, Replication, Configrue Publishing, Subscribers, etc. Then go to the Subscribers Tab and hit the elipsis next...
September 21, 2006 at 11:59 am
You may want to check how your application is designed too. We had a bad situation once where the log file was huge and the SQL Service was stopped. The...
September 11, 2006 at 7:03 am
I don't see it under the first key and the second one doesn't exist. I'll look around a bit. Thanks.
September 5, 2006 at 11:49 am
I found an article similar to that one, but if you'll notice it applies to NT 4 and earlier. When I query a 2003 machine I get the error "RegOpenKeyEx()...
September 5, 2006 at 8:26 am
Viewing 15 posts - 91 through 105 (of 302 total)