Not according to the error you posted. The provider is named pipes.

Can you explain better what your setup is?

TRUNCATE TABLE: http://msdn.microsoft.com/en-us/library/ms177570%28v=SQL.100%29.aspx

From the permission section: The minimum permission required is ALTER on table_name. TRUNCATE TABLE permissions default to the table owner, members of the sysadmin fixed server role,...

Is Autoclose set on the databases?

I ran this:

CREATE TABLE TRLC

(

est_no varchar(10) default ' '

, right_no int default 0

, maj_auth varchar(15) default ' '

, [weight] varchar(10) default ' '

, idm_ht varchar(8) default '...

Just File | Open.

Is this stored in SQL Server or the file system?

Is your client on the same machine as the server? Can you switch to TCP/IP instead? I am not sure, but it seems there was some issue with named pipes...

Not sure, perhaps different permissions from the domain at work?

Could there be different versions of software somewhere? Is this the same OS?

That's probably true, and thanks for the comment. I suspect the companies that would be willing to do this are also the ones that are willing to invest in BI,...

Tom.Thomson (3/7/2011)

That'll teach you not to rely on...

One quick note: we use Standard Edition.

I was hoping to use Resource Governor to tune the newsletter load and limit the impact of that process on our servers, but it's...

Congrats, Paul. I haven't read it, but I've seen some good comments around the web about it.

SQLSearch will help you find these, but it can't help you fix them.

The issue is that it's not necessarily easy to determine what needs to be moved from the WHERE...

Note that you can stick the index rebuild in a maintenance plan by calling it from the Execute SQL task, or you can just put it in a job step.

Be careful about setting your own host. WordPress.com isn't a bad solution, and as long as you have a few people to admin it, it makes sense.

Just think beyond...

You can submit DCMAs here:

Blogger: http://www.google.com/support/bin/request.py?contact_type=lr_dmca&product=blogger

Wordpress: http://automattic.com/dmca/

I'll do those.