Not quite sure what you're asking

Select * into Table_A from Table_B

Did you try my reply in your cross-post ? (which is generally frowned upon)

http://www.sqlservercentral.com/Forums/Topic1538824-392-1.aspx

I run this as a SQL scheduled job on my Windows 2003 server:

[font="Courier New"]ForFiles /P D:\objectscripts /D -180 /C "CMD /C if @ISDIR==TRUE echo RD /Q /S @FILE &RD...

Earlier versions have it too.

If you took the backups using native SQL, and they are stored in the same location as the time of backup, then I think you can use the GUI to...

Thanks !

Can you buy additional TS licenses ?

ChrisM@home (1/30/2014)

---

homebrew01 (1/30/2014)

---

We haven't written any code like that in a while. It is easy to search for '*=' and find the left joins. Not so easy to find...

We haven't written any code like that in a while. It is easy to search for '*=' and find the left joins. Not so easy to find the inner...

You can also look to see if processes are getting blocked.

I run a job every hour that queries the system tables looking for job step failures. If it finds some within "x" time frame, it sends me an email.

Pro: It...

Can you contact TSM support ??

How about a .BAT file invoked from SQL ?

Or perhaps FORFILES function ? I use it to delete files older than X days. I don't know what...

Jeff, the code above is really just a snippet example using the OUTPUT to a temp table.

In the real code, the import table also has a RecNum identity column. During...

Are you trying to load the data into a SQL table that already exists, with slightly different column definitions ?

I usually let the import wizard build a table based on...