While there is no "last record", you might have a look at MAX(), which should be the equivalent.

May I ask why you have a separate table for each merchant?

When you think some time about it, there is actually only one way to do this efficiently.

Remember that the leaf level of a nonclustered index contains the RID when there...

Not quite right!

It does run, however it is not supported. See here:

http://www.microsoft.com/sql/howtobuy/windowsnetsupport.asp

Me too!

I guess, nobody will laugh when you can (and should) use the INFORMATION_SCHEMA views.

Anyway, there might be an even easier way to determine this property.

SELECT COLUMNPROPERTY( OBJECT_ID('authors'),'au_lname','AllowsNull')

returns 1, if...

What about SUSER_SNAME()?

This one might proabably be interesting to you:

http://vyaskn.tripod.com/track_sql_database_file_growth.htm

Yes and no.

While it is technically possible to create a trigger on some system tables of msdb, it is not possible to create trigger on tables in master. And it...

You might want to have a look at BOL for IF UPDATE to test in your trigger if your column is updated.

One possible way would be

set nocount on

/* cut here */

use tempdb

create table #the_table(the_value varchar(10));

insert into #the_table(the_value) values('a1');

insert into #the_table(the_value) values('a2');

insert into #the_table(the_value) values('a21');

insert into...

See, if this helps:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;307487 

for shrinking tempdb. And this

http://support.microsoft.com/default.aspx?scid=kb;en-us;224071

how to move it

I'll help a little bit with the URL

http://www.cs.arizona.edu/people/rts/tdbbook.pdf and

http://www.cs.arizona.edu/people/rts/cdrom.zip

See, if this helps:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;315886

http://support.microsoft.com/default.aspx?scid=kb;EN-US;312839

http://support.microsoft.com/default.aspx?scid=kb;EN-US;263556

http://support.microsoft.com/default.aspx?scid=kb;EN-US;311231

Yes, every user has permissions to create temporary tables.