I have not run across a problem.. yet.. but does this problem also cover indexes on temp tables? Thus is there any issue with me doing the following?

CREATE TABLE [dbo].[#History](

[Extract_Date]...

MyDoggieJessie (3/26/2015)

---

Interesting! I have no experienced this issue.

It could be that you're filling up your files faster than the job is able to pull them out...so it's getting overwritten...

Thanks for sharing .... I seem to have found a bug though... we are missing some changes and the point of failure that I am looking at.. is when the...

MyDoggieJessie (3/17/2015)

---

Not sure if this is something you're looking for but I recently posted a process on SSC to track these types of things. Feel free to check it...

Thanks for your help.

GilaMonster (3/17/2015)

---

No, SQL doesn't track object change history.

You can look at sys.objects in each database and look at the create_date and modify_date, but I think there are things you can...

CASE figures out what type it is returning before the query is executed. It is not expecting to get different types for different rows. If thats what you give...

For some reason it is trying to convert my data type to a number... one is varchar and the second is an ID field.

, CASE @Sort_Sel

WHEN 'Resource' THEN R.RESCODE

ELSE D3.DATEID

END...

Thanks... did not know you could put case into ORDER BY ... it is a good day when you learn something new..

Thanks for both of your replies.. During lunch I read through the article. Will try and get back to this project tomorrow.

David

Ok thanks.. got misled by it stating job step.

BTW I created a script task for each server, that way I could disable a server's removal of database files if needed (this came up last week and we needed...

I did finally get the C# syntax for 2008... so this is what I ended up with, in the script task box. Note it connects to our file and print...

Forgot about that.......

Ok, thanks...

CREATE TABLE...