No, you need a CASE statement

CASE WHEN SomeColumn = YourValue
     THEN SomeValue
     ELSE SomeOtherValue
END

Nope.  You have not specified anything in the command to actually grant execute permissions on. But, it will complete without error. This is the books online entry:

Hmmmm.  I have GRANT EXECUTE TO myuser, so I'm assuming that gives myuser rights to execute any sproc in the database and thus allows rights to use OBJECT_ID and...

Both of these are available to any user, as long as they have a valid login, and that they have ANY permissions to the objects being referenced by OBJECT_ID or...

It's certainly possible, but why wouldn't you add a third node in the DR site, and set it up as async?

There are things to consider when setting up the listener...

There is no recommended size for a backup drive.

In basic tests, performing backups on databases ranging in size from a few GB  to hundreds of GB's in size, there was...

Are you actually storing SSN's in clear text?

How can you be sure that the left most characters are the correct characters?

What a day, one could not make it up! My best friend taken to a hospital (second time in two days) after collapsing going flat on the ground, no...

Oh boy.  We have a reporting group that has jumped into PowerBI in a big way.  Most of the data on the dashboards is refreshed from a semi-data warehouse.  But...

Here's a question.  Why is this a problem?

If the primary key is clustered, it IS the table.

This may be normal.  If you could provide the DDL so we can see...

John is correct.  They are two different things.

DBCC CHECKDB, depending upon the parameters passed into it, only checks for corruption within the database.

RESTORE VERIFYONLY only checks to see if the...

If you can't find it in this collection of great PowerShell scripts, then maybe it can't be done!

https://dbatools.io/

Gee, I was able to take the code example provided by Fredrico, and with a little trial and error because I am not that great with Power Shell, get it...

• This reply was modified 7 years ago by Michael L John.

Do you have a copy of Access? You may need to use Access, pull it from FoxPro into that, and then import the Access database.

Beware of the numbers being changed. ...

It was the same behavior running it in Visual Studio or deployed to the server as a package.

Permissions are correct, it wouldn't have been able to do other things if...