Thanks Jeffrey.

Found this on Andrew Fryers blog thought others might find it useful:

http://blogs.technet.com/andrew/archive/2008/07/14/licensing-sql-server-client-tools.aspx

Regards,

Phil.

Thanks for the input. How does visual studio (delivered with SQL) fit in regards deployment to multiple users?

Thanks,

Phil.

Thanks for posting.

Kind Regards,

Phil.

Point taken, legs duly slapped 🙂

Phil.

Thanks for taking time to reply.

A friend has just come up with the answer as follows:

INNER JOIN (SELECT AccountingYear * 100 + AccountingPeriod AS YRPR,AccountingYear,AccountingPeriod,PeriodClosed,ROW_NUMBER() OVER(PARTITION BY AccountingYear * 100...

OK, I have made some progress (testing on 32 bit XP laptop).

Firstly I added a linked server:

DECLARE @rc int

DECLARE @server nvarchar(128)

DECLARE @srvproduct nvarchar(128)

DECLARE @provider nvarchar(128)

DECLARE @datasrc nvarchar(4000)

DECLARE @location nvarchar(4000)

DECLARE @provstr...

Thanks for the links.

Kind Regards,

Phil.

In testing I received error "Microsoft.ACE.OLEDB.12.0" has not been registered.

I have done some research and apparently there is not a ACE provider for 64bit?

I am running Windows 7 Ultimate 64bit...

Thanks for that, very much appreciated.

Kind Regards,

Phil.

Hi, yes T-SQL to to Excel and I was hoping to automate.

Kind Regards,

Phil.

Thanks for the link.

I am looking to go the other way. Run a SQL query that outputs to excel. For each GL Code create a seperate worksheet in the excel...

DISTINCT

There must have been a reason at the time....I will check and remove if not required.

Thanks,

Phil.

Thanks Dave, I will take a look.

Kind Regards,

Phil.

Thought I would post my solution.

It transpires I had not permitted the account used in the Endpoint role membership on system databases Master & msdb.

msdb:Roles

SQLAgentOperatorRole

SQLAgentReaderRole

SQLAgentUserRole

Thanks,

Phil.