Thanks Dewey! I also, found out from management studio when you create a new sql ce db the "options" button on the lower right corner of the connection window...

I put 2 nonclustered indexs on the two most heavily joined columns on the temp table and it reduced the tempdb locks down to a bare minimum!  But, when running...

but isn't index going to slow down the updates cause with indexs you have to update not only the table but the indexs when an update occurs?  I just remember...

No i don't think so.  I would have to ask my senior dba as I just started this new job.  I am in the process of analyzing and trying to...

can you give me some examples of using functions badly?  appreciate it!

Sorry I can't find the link i was googling it and can't remember my search criteria.  Anyways the answer is as stated before by others is using sp_helpdb or sp_databases. ...

If the linked table that your referencing is not huge in size then you could possibly select that table (use a select into clause) into your local machine as a...

Check out the below link.  I'm not sure if their is or not a system sproc...If it's not listed in sql books online (i'm sure you checked) their probably isn't. ...

NICE! thanks all for your help!... Scott the select statement worked...

select * from dbo.fn_GetClosestZip(98052)  

Thanks for the insights!! I'm screwing around learning....Thanks a million!

what happened?

Thank you very much!  I think this help me out!

select zip, subdistrict, city, state from Feed1

select zip, subdistrict, city, state from Zips

So if zip field from Feed1 matches with zip field from Zips then go ahead and check if subdistrict,...

actually i just did it through enterprise manager deleting the foreign keys and then just truncated the tables in query analyzer and then used Import and Export wizard to transfer...

Hi Steve,

Yup that worked!  I deleted the foreign keys on the table and then trucated all the tables and reloaded the data.  Then recreated the foreign keys.  Appreciate the help!