I have a table called Current_Roster with a column called Territory_ID. We use logic in our territory ID's so that each sales rep "rolls up" into their district (example, H21H01...

Here's a simple scalar udf that gets the last day of month(LDOM). While the code is not "obvious" I don't consider the obtuse syntax a readability issue because it's well...

We're running 2005 with only a few 2000 boxes left. We haven't touched 2008 at all yet-- but I figured it was possible MSFT could have done a major revamp...

> But the weird thing is that this works if it is a Windows login, but not for a SQL login.

Off the top of my head I'd say THIS...

>someone decided that 12/31/9999 was going to be the end date

Oh, just GREAT.

That means when Y10K rolls around, we're gonna hafta listen to the Mac camp brag about their OS...

You don't indicate what version you're running, but if SQL2005 you could (quick n dirty) do this.. it returns a superset of the columns you used but you can always...

You may want to check out Ultra Edit. Save 2 usp's to text files and do File/Compare Files. It shows the files side by side with the extra/missing rows highlighted.

It...

Ah... the edit on the previous message didn't float this thread in the list of topics, so... has anyone else been able to output to UTF-8?

Has anyone out there tried this, either with success or failure?

Adding this 1/27:

One more whimper to try to get some additional responses.

Right... I'm already doing that, 3rd line from the end in the OP. Unless that's not the right CP...

*Wow*

I just found this article and cannot wait to run some tests and eventually try it out in prod. I've only read the first page of comments, so no doubt...

Heh... the only flaw in your thinking, was thinking there was a flaw in your thinking...

>I'm curious why you did not want to specify these (key_source & identity_value) parameters?

It...

Success.

I think what happened was the authentication was preserved between steps and it messed me up. If you restore the Service Master key backup from server1 to server2-- then restore...

Hrmm... this is like peeling an onion... the more layers I get through, the more I cry. I must've done something terribly wrong. I followed your template (except I did...

Thanks again for all your input...

Re "Moving Encrypted Data to Another Server - Disaster Recovery"... oops. Right there, big as life.

I've read a few of the articles by Laurentiu...