Recreate a temporary table from TempDB

This Script can be used to pick out a temporary table from tempDB

you might want to Check and drop the table before you create it just in case , but I Haven't included it here

RE: How do Searches on a Form with Subforms work?

Aaron:This is an old question so you may have answered it by now. How is your subform related to the main form? Are you linked on a particular field? If you can clarify the issue, that may generate a better response.Thanks,Sam

RE: how to zip file

OK.  Makes perfect sense.  Thanks for the 411.  I'll take this under advisement and look into scripting more of my tasks whenever possible.  LanMan

RE: Importing data into a new db structure

Assume data types are the sameUpdate a  set jobtargets = b.id from old_jobtargets a  inner join new_jobtargets b on a.jobtargets = b.jobtargets

RE: Naming Conventions and You

Deutschland, Deutschland, uber alles.... Wie gehts? Not so happy with this anyway, but that's another story.I'm used to search in Google.de. But I think it's the same as when you search in Google.com, or is there a difference?

RE: Error Message

You have an extra ) in your first line.

RE: SQL SERVER 2000 trigger for Audit trail

Something like this should get you most of the way: create TRIGGER [name] ON FOR INSERT AS update set created_by = SUSER_SNAME(), last_modified_by = SUSER_SNAME(), date_created = GETDATE(), date_last_modified = GETDATE() from inserted where .Seqno = inserted.seqno; create TRIGGER [name] ON FOR UPDATE AS update set last_modified_by = SUSER_SNAME(), date_last_modified = GETDATE() from inserted where […]

RE: using replication to move data from buffer databases to central database?

Given the fact that you need to delete messages from the client machine you are forced to use a DTS package running at intervals.  The Replication models are just that - Replication of data from one server to another.  Therefore if you delete data at one end the other end will mirror this exactly.Once you […]

RE: Calling package from within another package

I was able to resolve the issue - indeed, it did have to do with an error in the filepath. It didn't cause package failure, it just silently tortured me for the past day!Thanks for all your help.

RE: Trigger update is being overwritten

Can you post your TABLE DDL and TRIGGER for us to get an idea of what you are doing fully please?