Hi Gail,

That makes lot of sense now. Thanks.

I'm a big fan of your blogs. I'm up to Chap 7 of SQL Server Transaction Log Management as we speak.

Have a...

Hi Erland,

Thank you very much. I'll ask my our developers to look into the benefit of XACT_ABORT.

Your explanation is spot on on that the SP_GetNextValue was called by another...

Hi Jeff,

Implicit Transaction setting for both SQL Server 2008 and my query sessions is OFF.

After the reboot I couldn't replicate the problem anymore, I guess not until we have another...

Hi Jeff,

We did this test to check the overall response time on high number of consecutively updates, which is similar to the pattern the table is used in production....

Thanks to everyone, especially to Ryan. The solution in the first article works very well for our needs.

If this is happening to the same table object, I'd try reindexing it.

Microsoft's LogParser is quite a powerful commandline tool. It allows you to use SQL-like syntax to match strings and pipe output to various formats and even to a SQL database...

I've found the following script helpful:

Create proc uspRenameServer

@pNewName varchar(256)=null--If NULL we will attempt to rename server to the WINS machine name

/*

Purpose: renames SQL server.

Server: all

Database: DBAservice

Developed: Yul Wasserman...

I had the same problem and fortunately I was allowed to open all ports on the DB server:

Local Area Connection properties - TCP/IP - Advanced - Options tab -TCP/IP...

I ran into one of these two days ago and I don't think microsoft itself can pin point the cause without seeing the error code, based on what I read...

The solution suggested here ( http://www.databasejournal.com/features/mssql/article.php/10894_3296731_2 ) caused some problem for me because some services were turned off on the server.

I prefer some simple custom sp. I...

I got this from someone last week:

exec sp_addlinkedserver 'ALIAS', ' ', 'SQLOLEDB', 'SOURCE_SERVER_NAME'

exec sp_addlinkedsrvlogin 'ALIAS',FALSE,'sa','sa','sa_password'

Thanks, AJ, for pointing me to the security tab on the linked server. I manually typed in sa and its password and it helped.

And also thanks to Phill. Your tip...

Thanks, AJ.

Here is what I've done and got:

exec sp_addlinkedserver [GN5DB1\SQL2000], N'SQL Server'

(1 row(s) affected)

(1 row(s) affected)

exec sp_addlinkedsrvlogin [GN5DB1\SQL2000],FALSE,'sa','sa','service'

(0 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)

(1 row(s) affected)

create view dbo.ccsystemcontrol as select...

Thanks, Alzdba, for the additional insight.