Thank you sir I appreciate it.

I think you are grossly overestimating the amount of tables I build :D. I mostly deal in backups,access, and troubleshooting.  The only tables I've built have to deal with keeping...

I suppose the only time I've ever really USED identity column I also identified it as the PK.  I guess I'm not really sure why else you would...

I suppose the only time I've ever really USED identity column I also identified it as the PK.  I guess I'm not really sure why else you would use an...

Not really, the point is for them to be unique.. so; it does this with ints, what about GUIDs?

Also, cool, learned me a thing to day.  Thanks

So, if I created a test table right now, and made an identity column, added 10 rows to it, then rebooted the server, and added another row, you're saying the...

...is that actually a thing? restarting SQL Server increments identity fields by 1000? I've never seen that and it doesn't sound like a thing?  Maybe I'm not understanding the context?

I have seen this, I would have assumed that it disables the ability to print all together, which is not what I want, but I'll test it in test and...

• This reply was modified 3 years ago by  oogibah.

Fortunately, we are doing a major upgrade on the app that is on that system in July and we are mid testing a copy of it with 2017 SQL Server,...

we were hoping to use a different cardinality estimator on the mirror vs prod and putting queries that performed poorly against the mirror as opposed to prod.  Shame.

Hopefully you understand why the query works otherwise you won't do well on the test.

Yeah, the schedule was generated by reporting services when I created the subscriptions, I've decided to just delete these and instead create a schedule that runs every 3 months on...

• This reply was modified 3 years, 11 months ago by  oogibah.

Sorry Jeff, I did a sneak edit above... rundate/time doesnt make any sense either.   Job is enabled schedules are enabled.  None of this makes any sense.

• This reply was modified 3 years, 11 months ago by  oogibah.
• This reply was modified 3 years, 11 months ago by  oogibah.

Job history is blank, and the "Last run" on SSRS is december 2nd

also when querying for next run date

name                       ...

• This reply was modified 3 years, 11 months ago by  oogibah.

Good Evening,

I've run into this in the past and there is a couple things you can try.  First check to make sure there isnt any corruption in the database by...