I do DBA at work and programming at work and at home as a hobby as a small sideline for other peoples projects.

The point to having Database and Programming as...

For me it has to be time limited with full features. I have found that it's not always a bad idea to give a fully featured product a longer period.

As...

Is this a regular copy or a one off?

There's a number of solution.

If it's a one off you could use the BIDS

Create an SSIS package that copies it directly...

at the top of your query

declare @rc as int

then as the bottom of the select statement set @rc=@@rowcount

If you have done this right

Hi Greg

Thanks for that the formatting is not the messy part as when I see it on Manager ets it's all tastefully indented etc.

Will have a look laters at yours...

For what it's worth,

Is the connection you're using passing the credentials you're expecting. I.E. You may have the the user set up on the system but not the actual databases...

I would hope that most peoples for a better word for it "Default position is" "Yes" on this point.

I mean I would say "Yes". However we do get trained sociologically...

Thanks for this please find attached a copy of my execution plan.

Doug

Also I always check the costs of any script on our development server and make sure it's properly indexed and the subtree costs are to a minimum before transferring to...

USE [dw_reports]

GO

/****** Object: StoredProcedure [dbo].[s_rpt_SLA_code_enquiry] Script Date: 12/04/2009 14:25:30 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER proc [dbo].[s_rpt_SLA_code_enquiry]

@codesetvarchar(20) ,

@codevarchar(20) ,

@fiscal_yearvarchar(20)

as

/*

exec s_rpt_SLA_code_enquiry 'code_sla_2009_2010', 'CN301AN', '2009/10'

*/

selectst.source_table ,

d.source_table__id ,

t.month ,

t.encoding_criteria_id ,--...

Create logon on the SQL server then a Role on the DB that only allows access to SPROCS then link that back to the logon.

Hope this helps