Hi Tobe_ha,

that works great but I am ending up with the follwing

ProductLicense_Idn LicenseNumber

1 SYD12N - 1

2 toronto - 2

3 toronto - 3

4 AER45SF - 5

5 AER45SF - 5

6 AER45SF...

hmmm thats very intersting EdVassie

kind of defeats the purpose of removing BUILTIN\Admin from SSRS! I will have to test that in SQL 2005

For me personally I tried all these fixes mentioned and nothing worked arggh

In the end I sought professional advice (from a person who works on the Web services team)

A simple...

excellent, thanks for your speedy response

Mny thanks for all the responses everyone. This shows why its such a useful forum 🙂

I will investigate some of these comments and post up my results

graphical Plan attached. You need to rename .txt extension to .sqlplan

Thanks

I have pasted the query plan in. I have attach a text file. Would there be an improvement if perhaps I populated temporary tables with the funtion results and also...

Here are some of the functions

CREATE FUNCTION [dbo].[fn_Category]

(@JobID int, @Category varchar(500))

RETURNS bit

BEGIN

DECLARE @Rows int, @Found bit

SELECT @Rows = 0, @Found = 0

IF @Category IS NULL

SELECT @Found = 1

ELSE

BEGIN

SELECT...

This is a great article. I never clearly understood why I was getting the informational message in my SQL Error logs

"The SQL Network Interface library could not register the Service...

At the home level you can click properties and delete the BUILTIN Admins from the list. Also click on the Site Setting (top left) and the "Site Wide Settings" and...

An important point to note, if one publications fails with dodgy data then this affects the other Publications if using Shared Distributor! Is this alone a valid case for independent...

We never have more than two subscribers.

But we do have at least three Trans Publications per DB. And yes it can get confusing sometimes as you see the same Distribution...

hi ,

so you are saying go with the Shared distribution Agent?

I have just tested this and you do have to change the subscription manully to 'Queued' otherwise any updates to the subscribers dail with "Server not exists". You would expect...

Hi Steve, thank for the quick response. These are push subscriptions.

From what you have said, does this mean that updates to the subscribers will be queued by default if...