Viewing 11 posts - 1 through 11 (of 11 total)
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...
June 4, 2010 at 2:03 am
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...
June 4, 2010 at 1:44 am
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...
May 21, 2010 at 3:32 am
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
May 19, 2010 at 7:23 am
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...
March 29, 2010 at 10:26 am
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...
January 8, 2010 at 8:39 am
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...
December 8, 2009 at 4:09 am
Thanks for this please find attached a copy of my execution plan.
Doug
December 4, 2009 at 8:07 am
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...
December 4, 2009 at 7:37 am
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]
@codeset varchar(20) ,
@code varchar(20) ,
@fiscal_year varchar(20)
as
/*
exec s_rpt_SLA_code_enquiry 'code_sla_2009_2010', 'CN301AN', '2009/10'
*/
select st.source_table ,
d.source_table__id ,
t.month ,
t.encoding_criteria_id , --...
December 4, 2009 at 7:26 am
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
September 1, 2009 at 4:45 am
Viewing 11 posts - 1 through 11 (of 11 total)