No problem.

Regards,

Lian 😎

We give datareader access on the read-only reporting db to some staff who need to run ad-hoc queries. None of our business logic is in the database (Views, stored proces,...

OK, can you do the following please?

Run (remove the WITH TIES):

ALTER VIEW NumberView AS

SELECT TOP 3

numberValue,

numberTimesUsed

FROM number

ORDER BY numberTimesUsed DESC

Send the results of the following:

select * from number

Same here.

Trevor, Karthik's script above uses a temp table - Which cannot be used in view's definitions.

Can you also send the results of the following:

sp_helptext numberview

Sorry, only saw the third column afterwards. Also, my sort order needed some changing.

Try this & let me know:

ALTER /*CREATE*/ VIEW NumberView AS

SELECT TOP 3 WITH TIES

numberValue,

numberTimesUsed

FROM number

ORDER BY...

Will this work?

CREATE VIEW NumberView AS

SELECT TOP 3 WITH TIES

count(numbervalue) AS Amt,

numbervalue

FROM number

GROUP BY numbervalue

ORDER BY count(numbervalue)

Thanks for the info.

I'm sure it will come in handy very soon!

Nice article Andy.

If I may ask, what do you have against the datareader role? Apart from denying users access to sensitive data, do you have any other reasons/examples of why...

Thanks for the response. (Holiday??)

Do you have any tips (apart from the documented procedures/articles available) in working with replication? I.e. something you wish you knew before you started working with...

It's used in setting up table & index partitioning.

A nice article on this topic:

http://technet.microsoft.com/en-us/library/ms345146.aspx

The training kits Gail mentioned are published by Microsoft & are probably the next bext thing than sitting in the lectures

What's the size of the database? How many users connect to it during peak hours? And...

Hi there,

Can you make sure that all the required packages are available for use?

I.e. if you imported the 'main' package (The one in your job step) but that package references...

As with a normal SQL Agent job, just specify the package in one the job's steps.