It's a server with two named instances - it happens on both instances, in any database - but only when connected remotely, not when logged on to the server itself...

In this case it was just a connection from Query Analyser.

From SQL Management Studio, symptoms are similar, but the error message is a little different:

A transport-level error has occurred when...

In case you miss is, article Generating Insert Statements[/url] is republished today.

Also, there is my own article, Scripting INSERTs[/url], which is intended to do address a slight different issue -...

Well, yes - but producing binary inserts clearly loses some of the flexibility I often use a scripting procedure for in the...

I've got something similar I wrote that I use. Possibly worth pointing out that you can bind your own stored procedures to keys using "Customise" in SSMS and QA (e.g....

harry9katz (2/6/2009)

---

Right U are but U can see all the blocked paid's by order of waittime and can see what spid A is Doing by DBCC inputbuffur(spid a)

and decide if...

harry9katz (2/4/2009)

---

U can find the deadlock on line by running the script:

select * from master..sysprocesses where blocked>0 and spid<>blocked

order by waittime desc

and find the spid

then use :

dbcc inputbuffer (spid...

This seems to be addressing a different issue to the one I was trying to solve. First of all, it's pretty tied to SQL server 2005 and above - e.g....

Adam Tappis (12/30/2008)

---

Although I agree that there is merit in this technique (as I've used it myself on previous projects). I would say this "quick and dirty" attempt is like...

One key point about ths approach is that it's "quick and dirty" - if all you want to...

That means, if a table has 107 columns, then you'll only script 100 of them...does that make any sense? If indeed there is an obscure sql fault on greater...

I don't know of any nice clean way to join to it, but I've done the sort of thing I think you're after in fairly ugly ways with cursors. For...

Hardware has turned up, and we're just at the point where we'll be configuring the arrays. I'm still a bit concerned about the 30 disks in the external chassis. I...

Not seen this myself, but might it be something to do with SQL Agent alerts:

http://www.dbforums.com/archive/index.php/t-1104383.html

http://sql-server-performance.com/Community/forums/p/22262/128396.aspx

Tony

The performance comes from the fact that field like('%search_item%') cannot use any index - it generates a table scan. Note that field like('search_item%') (without the leading "%") is a completely...