That's a good question. I'd open the MS case, since they will need to give you proof anyway.

Love to hear the answer. My suspicion is they'll say it won't work....

This was in administration. I moved it 😉

Can you query the raw data in msdb and see what's listed? sysjobhistory?

Please do.

Also, just to be clear, are you connecting to the actual instances or virtual instances?

Any failover events? Can you double check that

- you're hitting the virtual instances...

If you have 3 separate NICs, you might be able to do this, but my suspicion is that the default instance will bind to 1433 on all NICs.

If this...

As soon as you limit it, someone will come along and ask for more.

You could easily do this with an identity and set a trigger to stop anything after 999....

Sorry, edited my post as well. I think B (using datetime) makes more sense. Include the other int columns if it helps performance.

Can you give an example? Are you using two post windows/edit boxes at the same time?

I agree. I'll look around a bit more.

Can you give an example?

The thing is, you should be learning this stuff. 431 includes simulations, and you need to be able to actually do the work. Work with objects,...

You should be able to add a login from another domain. You might need an AD trust of some sort.

Easier to add the login with SQL Server (sql auth), set...

Don't do this. USe an identity, add a 2nd computed column if you must that pads things out with the 0s (meaning it's a char ) col.

SQL handles this well....

Please put these in the appropriate forum. A better chance of getting an answer.

Also, which version of SSAS is this?

Use Option B. There are functions to work with dates and you don't need to reinvent them. Too easy to make mistakes.

If you need to query on year or month...

If there's a chance for a lot of updates, I wouldn't do a trigger. Better to do with the archive.

I'd actually do a "with exists" test first

if exists( select xx...