Viewing 15 posts - 1,441 through 1,455 (of 2,044 total)
Could be of a connection setting implicit transaction on/off. Sure that any begin transaction has a matching rollback or commit transaction statement?
Have you checked your stored procedure with microsoft best...
July 4, 2006 at 2:55 pm
surely
CREATE PROCEDURE dbo.USP_BATCH
AS
EXECUTE dbo.USP_BATCH_START
EXECUTE dbo.USP_BATCH_MIDDLE
EXECUTE dbo.USP_BATCH_CLEANUP
July 4, 2006 at 2:51 pm
Can you post the full content of filteringstr?
debug.print filteringStr
a guess
if Me.Discharged_.Value = 0 then
if filteringStr="" then
filteringStr =qryNotDischarged.Discharged=0
else
filteringStr = filteringStr & " AND qryNotDischarged.Discharged=0"
end if
else
end if
July 4, 2006 at 2:41 pm
The added latency could have increased the time the locks are held. Do you close your recordsets as soon as possible?
Is it possible to have the printing done not by...
July 3, 2006 at 5:38 am
You can also figure it out with sp_who,sp_who2,sp_lock.
The client tools version matches the sql server version (in terms of servicepacks)?
July 3, 2006 at 4:50 am
Have a look at http://www.connectionstrings.com/ for all possible connection strings.
Things to check:
Servername htm is known on the other pc.
Is your sql server configured for windows or mixed mode? If windows...
July 3, 2006 at 4:47 am
Care to elaborate a bit?
Is this about using the identity datatype or using a default value?
July 2, 2006 at 4:14 am
Have you checked security delegation for the linked servers?
A guess in the dark, have you rebooted the machines to make sure that MSDTC is started before sql server?
The windows servers have...
June 28, 2006 at 2:30 pm
Have you checked the consistency of the database (DBCC CHECKTABLE)?
When I had that error there were some consistency errors.
June 27, 2006 at 2:50 am
What operating system do both sql servers have?
In case of windows 2003 you have to be aware of:
June 27, 2006 at 2:47 am
You could also try sp_updatestats on your databases (updating statistics)
A query plan on a very large table changed from a clustered index scan to an index seek
June 22, 2006 at 3:27 pm
*msdb is largely a database for sql server agent, to store dts-definitions, scheduled jobs, backup history...
Sql server is quite selfconfiguring (buffers, updating statistics,recompiling,...).Chanches are that you have to tweak memory allocation...
June 21, 2006 at 2:07 pm
Seperate drives for the logs :ok
Seperate drives for the mdfs: ok
Seperate drives for the backups (the ATA drive) (could be on a removable drive as well so you don't have...
June 21, 2006 at 11:05 am
A great start is to have a look at http://www.sql-server-performance.com/sql_server_performance_audit.asp
about how to do a sql server performance audit.
Here is a list of all the waittypes:
http://www.sqldev.net/misc/waittypes.htm
Since it is pageIOlatch_sh ...
June 21, 2006 at 10:55 am
Too bad I don't have the books online at hand at the moment. The text field like an image/binary field. It is stored separately from the record.
Have a look at...
June 21, 2006 at 10:46 am
Viewing 15 posts - 1,441 through 1,455 (of 2,044 total)