What is the difference in your outputs?

Hi Lexa,

Try running ALTER TABLE mytable WITH CHECK CHECK CONSTRAINT FK_key

More here... http://www.simple-talk.com/sql/database-administration/foreign-keys-and-their-states/

Cheers

Gaz

Is it SQL Express you have installed? SQL Agent is not part of SQL Express.

On other versions SQL Agent should show up in the object explorer when connected to the...

Well, good luck mate. I don't envy you the situation!

Hope it goes well. 🙂

raotor (2/7/2012)

---

Yes, I do remember reading that somewhere.

However, this wasn't aluded to in the article I mentioned. In fact, the article showed an example of how using a CLUSTERED key...

Hi Steve, if you're not using an order by clause, there's no guarantee on the order of the results returned.

Also, given that DBA's sort of sit at the juncture of DB's, Dev's, and Infrastructure, there's plenty of ways to move!

Good grounding for any of PM, Release Manager, Scrum Master,...

Erm, guesses, but are you referencing tables by 4-part names? Or the jobs not targeted at the local server?

Jobs aren't mirrored as they're stored in the msdb database which...

Ha, so basically, what Gail said... 😀

Hi Damian,

That's the core of it, yes, but that trigger will just prevent a login having more than 3 sessions.

You'll need to change the IF to check APP_NAME() is LIKE...

I'm with you there Dev - I wouldn't usually recommend logon triggers either but I guessed from what Damian had said that he's in the situation he's in!

Also if mixed...

Great discussion on this - very informative. Cheers all!

Hi Damian,

Only way I can think you might be able do this is via Logon Triggers: http://msdn.microsoft.com/en-us/library/bb326598.aspx

Using ORIGINAL_LOGIN() & APP_NAME() to check for user/SSMS

Any good to you?

Cheers

Gaz

How about the XML method(s)?

Hi,

As you're using a case-insensitive collation (SQL_Latin1_General_CP1_CI_AS) then a64 and A64 are seen as identical, and therefore violate the PK.

Using a case-sensitive one (e.g. SQL_Latin1_General_CP1_CS_AS) will allow you to insert...