One option is to include a field of spatial type Geography and insert into it a polygon of the geographic area. Review the Spatial data types in BOL for...

The execution plan is probably dropping from the procedure cache based on factors referenced in this link.

From BOL:

You can reduce the default size of an empty file by using DBCC SHRINKFILE target_size. For example, if you create a 5-MB file and then shrink the file to...

Thanks for your help. I think I will call this post resolved, I think the question would make a good book.

Thanks, but they have to use the dbo.

In a past life I had the report procs in a separate database and used the rpt schema, but that won't...

To answer my own question, a ddl trigger based on object type might do the trick.

Great script! I don't see synonyms, can that be added, and the "object level perms for users tied to database roles I had created" from above?

I like the story, its a good example of how we SQL junkies get it done.

I would have refused the work. Almost every time I have had to crank...

This is just a stab in the dark, but if it helps . . .

AND (T_EQUIPMENT_LOG_DATA.READ_DATE BETWEEN '1/6/2010' AND '1/14/2010')

becomes (if the datatype on the table is a datetime)

AND (T_EQUIPMENT_LOG_DATA.READ_DATE...

update m

set m.orderid = m2.orderid

from dbo.main m

inner join dbo.main2 m2

on m.listid = m2.listid

Would you be willing to share your SSIS template? That could really help the push for SSIS in my space.

Thanks

Have you looked into the PIVOT command?

"I have a stored proc on my system which allows me to enter a number and it returns a list of related numbers"

Can you convert that into a function?

I will look at a way of logging the time per file. Looking at the network is an excellent idea.

The source for these files is numerous polling servers, these...

Thanks for your replies.

Zipping at the source is not an option.

Breaking out the files into separate streams is probably the best option, it is a natural way to create more...