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...

I don't understand your server environments. Are your servers in different locations on different domains ? Can you use IP address (111.222.333.444) instead of server name ?

I lloked up cleantable and it says it is for reclaiming space after dropping a 'max' column, so I don't think that would help me. No jobs set to "append"....

matt.newman (6/23/2011)

---

I never thought I would be trying to perform and exorcism of ghosts as a DBA.

I have found a few more resources. Since the issue is recurring and...