Thanks Mark - this sounds like a real timesaver.

Adam

Again, off the top of my head, how about "localhost" - I have used this in SSIS scripts, it might work here - if I have understood! Of course, you...

Hi sbygrave,

I can only suggest (untried and untested) that SQL Server replication from a central point to the departmental servers could possibly do the trick.

After all, it is extremely lightweight...

Hi MissKittyT,

I am using the Enterprise version of SQL Server - as you can see from Arunvijay's post,the solution does not seem to work out of the box with Standard...

Hi Arunvj,

I must admit that I have only used this in the Enterprise edition of SQL Server, and have not tested in standard edition. I will have to research this!

Thanks!

ADam

Good stuff!

Have you ever had the (mis)fortune to use MSbuild too?

Adam

Hi Olaf,

You can indeed use a stored procedure to retrieve style information, and then use this in the report.

It is a question of choice, you choose what you are...

Hi there perlowin,

Question 1:

CREATE ASSEMBLY SQLCLRTest

FROM 'C:\MyDBApp\SQLCLRTest.dll'

WITH PERMISSION_SET = UNSAFE

- or if using Visual Studio, it is in one of the project config tabs (I don't have access to my...

Hi Olaf,

I am pretty sure tha the answer is yes, using a config file, but I have not done this yet.

Adam

Hi there,

Again, one I have never met - and I developed & tested first on a Vista box. You could start by setting UNSAFE as a VS config just to...

Hi Misskittyt,

I think that this is possible, but I have not tested it. If you try this out do let me/the sqlserver.com community know, as it is an interesting way...

Hi All,

I am bafffled on this one - I cannot make it not work at all - but will keep trying!

Adam

Hi Susan,

This could mean that the Dll is not deployed correctly - you will have to make sure that you are copying it to the right directories!

Good luck,

Adam

Good one Barry, this alternative avoids multiple calls to the database. I use something like this when returning metadata to dynamically generated tooltips for instance - and it saves passing...

Good tip - thankk you!