One way it's determined, of course, is by the ownership in the Model DB. In this case it was set to the service account. When I set it back to...

I know how to check the mail queue to see if it's gone to the mail server, I just want to check execution of the send command while processing a...

Using local admin wasn't really a 'strategy', it was more of a Forlorn Hope just to get the job done while I found a sway to do it correctly. 🙂

Reports...

OK, I've come up with at least one way to do it.

I've added two columns to the import table, [DupeCandidateImport].

[SequenceSeed] [int] IDENTITY(0,1) NOT NULL,

[AppSequenceNumber] [int] NULL

Before I import data I'll...

I'm working in a vendor-supplied application that has many kinds of sequence numbers. The generic type 'SequenceNumber' is used in many different tables to provide a 'tiebreaker'.

The target table is:

/******...

I'm pretty happy with the responses! I look forward to learning from both of them.

OK, that's going to take some looking at :-D. I can feel self-improvement coming on.

Many thanks.

Yes, I could manage that. I think I'm missing an INSERT syntax that would do the insert from the temp table! There may be a gaping hole in my understanding...

Given a query that returns an IPCode (PK), a ProfileTypeCode and a PhoneNumber, and with all other required values constant. ReturnSetInd is passed as 'N', so no need to make...

jSo you've had no problems connecting to 2008 servers? I've got 3 2012 servers and 2 2012. Two of the 2008 servers are fine, just trying to connect to the...

There is a setting in 2008 to select windows or tabs as the default. My working style is heavily dependent on windows, so that's a biggy for me. I've found...

I appreciate that. If they'd just give me back windows instead of forcing me to use tabs it would help a ton! I understand that that's a VS thing, but...

Hold the phone! I'm on a dual monitor setup with SSMS running on the left monitor. For whatever reason, the right-click context menu appears all the way over on the...

Something's wrong. That's exactly what I've been tryng, but I don't get the right-click context menu in the Object Explorer Details window as I do in the main Object Explorer...

I'm feeling a bit dense here :-). F7 to get the Object Details was a breakthrough. I was able to select all the jobs (or Control-Click to get a subset).

I'm...