There are a couple of other actions that sp_change_users_login can use besides report... these just happen to fix the orphaned user. Check out BOL for the procedure.

While reading through this thread, it dawned on me that this is something that I failed to check on with my new job. 🙁

Is there a way to tell...

Nag, (cute tag...)

change this to:

'+ QuoteName(@dbname, char(39)) +' as Databasename,

That should resolve your issue.

The only time a new row will be placed in any kind of order is if you have a clustered index on the table. Then it will place the new...

Pretty much. I can't think of any other way; perhaps someone else will pipe in with an alternate suggestion.

only4mithunc (7/1/2009)

Is there any way to make the column name dynamic in SQL 2005 ? The situation is in a select statement there is one case statement , based...

Thank you for posting your solution.

To answer your first question (how to avoid putting name in the group by), you can use an aggregrate function on the name in the...

mtassin (7/1/2009)

say something like this..

select * from addressinfo

where

contains(address1,'"*red*"')

I'd expect it to find words that begin with red such as redding, redbird, redmond, etc... as well as just the...

Just in...

Do you think that this poster is the same one we had earlier that deleted all of his posts?

raghu,

May I ask why you felt it necessary to delete your initial post? The problem you were having may be useful to someone else; without your problem description they would...

JALB (7/1/2009)

Dave,

Here's a solution that eliminates the dynamic sql.

-- declare and set the looping variables

DECLARE @Count INT, @Month INT

SET @Count = 1

SET @Month = 5

-- build a table to hold the...

Dave, you are actually pretty close.

Instead of using EXEC(), use sp_executesql. This will allow you to pass in the appropriate parameter also - see BOL for how to do this.

In...

This...