Viewing 14 posts - 1,756 through 1,769 (of 1,769 total)
The setup is like Karl Klingler said.
Every weekday I plan a full backup of each database at 5.00 am (normal batch end time), should have finished around 8.00 am.
Saterday: full batch...
August 22, 2005 at 2:56 pm
I removed the truncate log step and the no_truncate clause.
So far so good. Thanks for the advice.
I'll repost in a few days.
August 22, 2005 at 3:05 am
It might be not needed if it isn't visible to the outside world, but every service pack fixes some bugs.
August 20, 2005 at 12:07 pm
although not a security tester, microsoft released a tool to report how properly your sql server is configured.
August 20, 2005 at 11:51 am
1)It is very likely your network is congusted, because your query launched locally just runs fine.
Any hubs remaining? Working on a WAN,dial-up?
Returning a very large dataset ?
ps Sure that SET...
August 20, 2005 at 11:46 am
we use the following connection string in DAO & access 97
"ODBC;DRIVER=SQL SERVER;Description=SQLServer;SERVER=10.0.5.100;UID=user;PWD=user2;DATABASE=master;Network=DBMSSOCN;Address=10.0.5.100,1433;APP=BT
August 19, 2005 at 7:12 am
I would recommend an extra 1 GB as it is quite cheap these days.
Are the two queries related to each other?
Is the first a long running one?
August 19, 2005 at 5:44 am
What edition is your sql server?
If it is a standard edition, it will maximum use 2 gb.
With the /3gb switch, the system will have 1 gb, sql server the 2...
August 16, 2005 at 2:28 pm
are you working with DAO or ADO in Access?
I'm almost certain that DAO only supports one set of data returned
August 15, 2005 at 2:15 pm
Hello,
I've got no experience with clusters yet.
But there is an article in MS knowlegdebase that discusses how msdtc should be configured on a win 2003 cluster
http://support.microsoft.com/default.aspx?scid=kb;en-us;301600
perhaps you need this...
August 15, 2005 at 12:40 pm
Inserting in a table yields no order (like throwing stuff all in a big bag)
Order is done via your query/stored procedure ...
August 15, 2005 at 12:35 pm
On what OS are the sql servers operating?
There might be some issue with the new features (rpc security) msdtc got with windows 2003.
According to this site, it is because sqlserver service...
August 13, 2005 at 8:27 am
On what OS & servicepack is your SQL-server (servicepack?) running?
August 12, 2005 at 1:16 pm
Viewing 14 posts - 1,756 through 1,769 (of 1,769 total)