I believe that will work.

If you have a test server (or desktop installation), you might try setting a simple job up that does something like insert a row into a...

I think you'll end up with locking problems if you do that. I've tried similar things on a running job, and I got error messages.

Don't double-post. Post the question in one forum on the site, please.

Are you using DTS in SQL 2005, or using SSIS?

I'm not that familiar with DTS, but I can definitely say that SSIS can import much more than 27k rows.

First thing I'd check is your settings. See if local help is disabled. Sounds like it might be.

Otherwise, I'd reinstall.

I don't believe you can use Select Into on a linked server. You have to create the table first, then use Insert Select.

Is this what you're looking for?

http://www.sqlservercentral.com/Forums/Topic447796-4-1.aspx

It will look something like this:

declare @Body varchar(max);

select

@Body =

coalesce(

@Body + char(10)+char(13) + 'Sell clientID ' + cast(Client_ID as varchar(10)),

'Sell clientID ' + cast(Client_ID as varchar(10)))

from dbo.tblClients

where -- I...

Some people are under the mistaken impression that adding an extra log file improves performance. I've seen that come up a few times. Someone may have thought that...

Won't make the difference in a proportionate font, Jack.

If you copy-and-paste the newly formatted code from the forums into an editor, you'll find that the tabs have been replaced with...

Here's a simple way to get all of them:

if object_id(N'tempdb..#T') is not null

drop table #T;

--

declare @Length int;

--

select @Length = 50;

--

create table #T (

ID int identity primary key,

String varchar(max));

--

insert into #T...

You can add a transaction log to any DB. Can be done by going into database properties in Management Studio, can be done by issuing commands.

Doesn't server a lot...

Greg Snidow (3/18/2009)

Gsquared, are you saying that in 2005/2008, I can access the inserted and deleted tables directly...

Try adding "set nocount on" to the top of each trigger (right after "as").

create trigger MyTrigger on dbo.MyTable

for insert

as

set nocount on; -- Right Here

...

These two articles and their discussions should get you well started on that:

http://www.sqlservercentral.com/articles/Auditing/63247/

http://www.sqlservercentral.com/articles/Auditing/63248/