If I understand what I'm reading correctly, PuTTY purposely doesn't allow passing the password in via cmd prompt. When I connect from the cmd prompt, it prompts me for my...

I apologize if my question wasn't clear. I thought I made it obvious that I don't know what I'm doing when it comes to FTP. There's no need to tell...

Can someone explain specifically how to create the proxy account so that the fingerprint is stored? I'm going to be running this from SQL Server Agent scheduled jobs, but the...

I am trying to include some code in a stored proc that will look to see if a user defined function exists in the database and if not that will...

I figured it out on my own! In fact, I used the article Matt posted and another article, too, and found two ways. Here's what I used.

--option 1

create function [dbo].[TNU_fnGetClassroomDOW]

(

@event_ID...

I read the article referenced above and I'm attempting to apply the concatenation code to my own situation, but I'm failing miserably. What I'm trying to do is return a...

Thanks, Sergiy!

I'm having the exact same problem the original poster had. The collation conflict appears when I'm attempting to view the "Securables" section for a particular Login under the Security folder...

Thank you all so much! The CROSS APPLY logic worked great. I had 272 donors who fit the bill! Also, I've bookmarked that article to read as soon as I...

You're right. Thank you for pointing that out. I'm trying your cross apply logic now. (I have never used a cross apply in a real environment. I do remember it...

Ok, I'm an idiot. I was trying to make the example simple but my problem was actually that I wasn't using the right fields in my group by clause. (I...

Thanks for your response. I've been trying a similar set of code, but the problem is that I don't know the date and it's going to be a different date...

phani kumar gotety (6/9/2008)

---

If you transfer the logins using the SP_HELP_REVLOGIN stored procedure, you would not get orphaned users as it recreates the logins with the original SID

Link to the...

I'm getting a similar message when trying to run an update statement where part of my WHERE clause is a query against a linked server. I've done this database many...