SQL 2008 R2?

You may be looking for this:

FIX: You cannot create, add, or edit steps for an SQL Server Agent job in SQL Server Management Studio 2008 R2

Well, EXECUTE permissions does not imply ALTER permissions.

Moreover, to drop the database you must be the database owner have CONTROL permissions.

SQLServer security model is fairly granular and it's usually quite...

Hi Mike,

Nope. Jobs are run under the account of the job owner. Steps are run as the job owner if it's...

What's the datatype of @From and @To?

It could be an (implicit) conversion issue.

Thanks Lowell, glad you like it....

You could use CHARINDEX(sought_char, expression, start_index):

WITH TestStrings (s) AS (

SELECT 'aaa-'

UNION ALL

SELECT 'bb-'

UNION ALL

SELECT 'ccccc-'

)

SELECT *

FROM TestStrings

WHERE CHARINDEX('-',s,3) IN (3,4)

This code returns 'aaa-' (fourth character) and 'bb-' (third character).

Phineas Gage (5/24/2011)

---

It's something that I've read...

Change LEFT to SUBSTRING.

LEFT(expression, 3) returns the first 3 characters of the expression, not the third character.

Use SUBSTRING(expression, 3, 1) for the third character.

Hope this helps

Gianluca

Not always needed, not always a good idea:

http://blogs.technet.com/b/askperf/archive/2008/03/25/lock-pages-in-memory-do-you-really-need-it.aspx

crazy4sql (5/24/2011)

---

Logically if I have to filter the database name and then do the activity one by one in each database then cursor is the only option I can see...

Hmmm, I didn't know this. Do you have a reference?

I'm not sure I...

Here's an example:

CREATE TABLE dbo.TEST (

id int identity(1,1) PRIMARY KEY CLUSTERED,

uniqueColumn int NULL

)

INSERT INTO dbo.TEST (uniqueColumn)

SELECT 1

UNION ALL

SELECT 2

UNION ALL

SELECT 3

UNION ALL

SELECT 4

UNION ALL

SELECT 5

UNION ALL...

Then you can use an indexed view.

The only ways to achieve what you're after are:

1. Filtered index

2. Indexed view

I understand that you don't want a filtered index: can you explain why?

Maybe an indexed view can do,...