Glad we could help. Let us know how it goes.

jasona.work (11/20/2015)

---

So, it's looking like we're going to get our first snow of the year tomorrow night or so...

3-6", and it looks like they're predicting it'll be that nasty rain...

Nothing like staying up late two nights in a row to do releases, get called back ten minutes after the second release to be told I forgot to move scripts,...

Phil Parkin (11/20/2015)

---

Sounds a bit too damp for my liking. 'Whet' is the word I think you were...

You are not wrong. Usually.

There...

Luis Cazares (11/19/2015)

---

I made the code work by adding 4 characters in different parts...

Bah. I thought I was being clever, but I have an error I can't find.

HA!

DECLARE @CurrentTime DATETIME, @TallyCount INT, @Adhoc_SQL NVARCHAR(50);

DECLARE Time_Cursor CURSOR FOR

SELECT DISTINCT N FROM dbo.Tally WHERE N < 500

-- Open Cursor of Users

OPEN Time_Cursor

FETCH NEXT FROM

Time_Cursor

INTO

@TallyCount

-- ...

Luis Cazares (11/19/2015)

---

jasona.work (11/19/2015)

---

I was going to post this over in Steve's call for Good Basic T-SQL Exercises but decided not to pollute the topic with fluff...

So I'm posting it...

Sounds like an orphaned user to me. Check the database level security and the server level security in the GUI. Remove the database level security, then go to the server...

Is this in production or a non-prod environment?

If production, you might want to have a discussion with your boss about the issues of giving DB create permissions in a production...

You may never find an issue to this answer. Sometimes Replication just stops.

The first places to check, though, would be the error logs (for any weird warnings or errors) and...

Sean Lange (11/18/2015)

---

Jack Corbett (11/18/2015)

---

Phil Parkin (11/18/2015)

---

Jack Corbett (11/18/2015)

---

Remember, it is not about winning or losing because everyone is a winner if they try their best...

When the witness does not exist and the primary goes down, I believe mirroring will be broken and you have to manually make the mirror DB the primary.

I know when...

May I also point out that NOT IN vs IN is a different matter than NOT LIKE and LIKE?

NOT IN and IN only consider whole value comparisons where NOT LIKE...