I had this problem when I was loading rows in bulk. I used use:

sp_tableoption '<table_name>', 'table lock on bulk load, 'true'

This locks the whole table whilst you load the...

select distinct <account name>, <Account type>, sum(<funding>) as funding

from <table_name>

group by <account name>, <account type>

order by <account name>, <account type>

Jeremy

You need to use CONVERT to convert one of the smallints to decimal:

select convert(decimal(18,8),var1)/var2

Jeremy

Look at this thread:

http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=10992

Jeremy

If you insert the results from master.dbo.xp_cmdshell into a temp table you can use the table to check for certain results such as the file name, network path not found...

Just a thought, but why use a trigger?

If you are building this from scratch, if you use a stored procedure to do the inserts and updates, you can put the...

No you cannot restore a backup from SQL 2K into SQL 7.

What you could do is use DTS to copy the database from one server to the other.

Jeremy

Change the return statement:

declare @result int

master..xp_fileexist '\\backup\04032003.bak' @result output

return

-- Returns 1 if file exists, 0 if it doesn't

Jeremy

Jeremy

I haven't done any memory related stress testing.

I have done lots of concurrent runs of this type - each month we get around 20 update files which we...

Dalton,

What I do in my ASP scripts is to open the database connection at the top of the page, execute as many sql statements as I need for the page...

One (small) benefit of having several files is if you have to move the database to another server.

Recently, I had to move my database (100Gb) from one server to...

Just another thought, why bother with a single SQL statement anyway? Why not have a separate query for each table? There will be a small performance overhead in...

So, please explain me what You mean by "make sure that each select statement outputs the same column names in the same order" -- more specifically: "the same column names"!

I...

If you take a copy the table with the current indexes, you can practice on that table to a: get it right and b: see how long it takes. ...

select count(*)

from sysobjects

where xtype = 'TR'

Jeremy