sysadmin rights were revoked so i was getting that error.

That answers my question. Thanks for your help guys.

Have you got this issue solved? how? I am having the same issue.

can you please show me how can I implement this with respect to your option ONE? Thanks for your time and effort.

This didn't help me.

The thing is actually i have got 5 drop down menu. Sometime user wants to select only 3 of them and leave the other 2....

Hi,

I have copied and pasted original question because that's what i want to achieve. and the query which i have posted is just a sample query using adventureworks sample...

HI Guys,

I have got a question for SSRS. I am creating a report and i am adding a drop down menu with a multi value parameter. I want this multivalue...

Hi theSuda,

Thanks for your reply. With your help and suggestion i was able to add the NULL as a value into the drop down menu but when i was running...

Hi, Thanks for your reply.

As it looks like you are talking me in the right direction. The thing is i am not getting you where and how can i...

If I am not wrong then you are saying to add a null value into the table? right ?

Is there any way by which i don't have to add...

Hi Guys,

Below combination worked for me. Just run the Script below for the individual database and copy the output and run into the new query window to restore users.

SELECT...

Hi Wayne,

I ran the script,

SELECT 'IF NOT EXISTS (SELECT 1 FROM sys.database_principals WHERE name = ' + QuoteName(dp.name, char(39)) +

') CREATE USER...

HI Wayne,

Actually i am here talking about scripting out users from the database not from the server.

what i do each time i do a restore from production to...

Hi,

I am getting the following error when i run the above script.

Msg 451, Level 16, State 1, Line 1

Cannot resolve collation conflict for column 1 in SELECT statement.

Please advise. Thanks.

First thing, for the best practice never install more than one instance of sql server unless there is a requirement. It's difficult to do memory management on a server having...