Read Queue extremely high SQL Server 2005 with fix 6
Thu, 25 Sep 2008 01:23:02 -0700
Hi all,
We have a problem with performance of our Microsoft Dynamics SQL Server 2005
box.
It is a HP DL350 with P400 Controller (with battery and 512MB cache on
controller)
on controller 8 disks
2 mirror disks drive c
2 mirror disks drive e (SQL Log)
4 raid 10 disks drive f (SQL Data)
When performing ...
|
About MSSQL Audit Logout issue
Thu, 25 Sep 2008 14:21:10 +0800
hi
I have a database server with MSSQL 2005 installed and two webserver
work on VS.NET 2.0
It works fine before.But when connecting the dbserver from another
remote WebServer with TCP/IP( connection string as "Data
Source=192.168.0.202,48525;Network Library=DBMSSOCN;Initial
Catalog=MyDB01;User ID=dbu ...
|
Error running Maintenance Plan on SQL2005
Wed, 24 Sep 2008 13:15:29 -0700 (PDT)
I have created a simple maintenance plan which should call a stored
procedure to perform database maintenance. I add a T-SQL Statement
task with the following code;
USE [Investran53]
GO
EXEC INV_spSQLJobSchedule
GO
When I run this code directly from Query Analyser everything runs ok
so the stored procedure ...
|
A significant part of sql server process memory has been paged out
Wed, 24 Sep 2008 12:42:12 -0700
Calling all MVPs,
I am seeing this error on a new server build.
A significant part of sql server process memory has been paged out. This may
result in a performance degradation. Duration: 0 seconds. Working set (KB):
39336, committed (KB): 89208, memory utilization: 44%.
Environment:
HP DL580 G4 32GB Ram ...
|
Exclude Statement
Wed, 24 Sep 2008 12:09:23 -0700 (PDT)
In the following code, I need to exclude anyone who has a
gs.giving_amount that is greater than $500. The problem is that the
results are separated by year. If the individual has ever given a
gift of more than $500, they need to be excluded entirely from the
report. Right now it is just excluding the data for ...
|
"An existing connection was forcibly closed by the remote host" (RESOLVED)
Wed, 24 Sep 2008 12:05:32 -0700
When I came in to work today, I booted up a dev web server that also has SQL
Server 2005 running on it. When I tried to connect to the main server
instance via Management Studio, I saw the following message:
TITLE: Connect to Server
------------------------------
Cannot connect to EBI-W2003E-BASE.
---- ...
|
viewing .trn files
Wed, 24 Sep 2008 11:39:00 -0700
Hello,
This may be a dumb question, but I have a Sql DB being hosted at a third
party vendor. We have had some problems and I had them send me the
transaction logs for the DB. They sent me .trn files.
But how can I view those files so I can actually see what transactions have
taken place?
Thanks
-- ...
|
|
|
SQL 2000 and workgroup mode
Wed, 24 Sep 2008 09:52:12 -0700
I have a question about how many licenses we have and how many connections
can be made to this setup.....
The windows version is Windows Server 2003, The server is in workgroup mode
(not domain/AD mode)
User accounts are local to the unit.
SQL 2000 is installed in Per processor mode = 4
Application is i ...
|
Cannot open tables in SSMS
Wed, 24 Sep 2008 09:36:07 -0700
Not a new install. Everything was working last week. No messages in logs
that I can see. But now when I try to open a table in SSMS, I get the
message: Object reference not set to an instance of an object. (SQLEditors)
Saw that SL2005 SP2 was indicated as a resolution but that is already
installed. Wha ...
|
Is a SQLEXPRESS DVD image available?
Wed, 24 Sep 2008 09:26:24 -0700
I know I can get the download for SQLEXPRESS (about sixty meg) from the
download site.
The thing is, I would like to offer my clients the opportunity of installing
my software without being connected to the internet.
That means getting the entire SQLEXPRESS image/package and dumping it to an
installation DVD ...
|
