You do backups because you know the server will crash if you don't.

corollary

The server will crash just before you notice the backups have been failing.

Cobol was a language where typing speed made a difference - looks like we're getting back to that.

As to the original question - I would go for the network or...

Interesting - thought I replied to this too. Didn't get an error.

Agree not a good thing to do in a trigger.

Why not have the trigger insert into a table then have another scheduled task which does the output.

What are you doing...

>> I just used a while loop with a print statement in T-SQL ...

That's similar to my first solution. It's what I always do to create things manually as it's...

I probably couldn't type that in 10 mins.

The two examples I gave you took a couple of minutes each (but then I haven't run them.

Just by the amount of code...

Two immediately obvious ways are

(this is they way I usually do it)

create table #a(s varchar(100))

declare @i int

select @i = 0

while @i < 400

begin

select @i = @i + 1

insert #a select...

>> Sure, but did he copy/paste the line 399 times? Use a cursor, cross join, dmo, ?

Does it matter? Whatever you find easiest and generates reasonable data - I usually...

You can easily generate the table by using dsql or alter table statements to add columns.

You can also generate an inserts by doing a select from syscolumns.

I tried it and...

is there something strange about the name of the column or any column? like it's got an invalid character in it.

If you use the profiler you can see what enterprise...

I have an SP which I run on dtabases to keep track of table growth which you can find at http://www.nigelrivett.com.

You will notice that

select max(rows) from sysindexes

should be

select rows...

try alter database modify file then restart the server.

7.00.623 is with no service pack.

Before sp2 sql server had lots of problems - basically locking didn't work very well and the server could return incorrect data.

This was fixed with...

Whatever method you use I wouldn't consider trying to merge directly into a production table. Treat the data import as a separate task from the merge. Better to import into...

You could also use bulk insert / bcp from a scheduled SP.