I recently did a lot of research on this.  ALZDBA makes good points about removing the /3GB switch and using PerfMon to see what's going on rather than task manager.

Two...

Thanks for both replies!  We resolved the problem with a restart of the DB Engine service during our maintenance window, and it did resolve the problem.

My bind is that the...

You can also explicitly specify what credentials are used by the connection object(s) in the DTS to authenticate to the destination servers.  If not specified, the connection inherits the credentials...

In the future, you can use this:

select

serverproperty('servername')

It immediately recognizes changes...

Table variables are stronger in 2005.  If you're using it, you're in luck!

This works in SQL Server 2005:

create

proc spTestInsert @tlike sysname

One other option is to create your table and insert into it the results of the exec(sql) statement.

A simple example:

create table t1 (firstname varchar(50), lastname varchar(50), phone varchar(15))

insert into t1...

I ran into something like this theo ther day - it turns out I was accidentally calling the stored procedure from itself.  This caused recursion and bombed at the 32nd...

Peter Larsson is (of course!) right that you can't execute dynamic SQL in a user-defined function.  This is unfortunate, but you can get around it.  If you need to "return"...

I keep  this link handy:

http://www.sql-server-performance.com/ac_sql_server_2000_undocumented_sp.asp

Two of the undocumented stored procedures are sp_MSforeachdb and sp_MSforeachtable.  Both iterate over a list of databases or tables respectively and execute the command text...

I have to agree with Steve that programmers are smart people and can see through the complexities of secure code to the example concept being demonstrated.  Give us the truth,...

The reason is that the data you're trying to put into one of the fields is longer than the definition for that field.

For example, say you have a table with...

I think your problem was probably an ambiguous column name error, but I'm guessing on limited info!

I think this will help you, but make sure my assumptions are correct. ...

I now live closer to my birthplace, about 10 miles, than when I grew up, about 50 miles.  Nonetheless, other than about three months in Miami, FL, I've lived within 100...

Well thought out, well written, concise and to the point.  I enjoyed and learned from this article.  I can usually say only one or the other about technical articles I read.

From...

Try opening Access but not the file that's corrupt.  From the Tools menu choose Database Utilities / Compact and Repair Database option.  You'll be prompted for the database you want...