Horrible Experience With Xp_cmdshell - Your Comments Please

May 21, 2008

I had a nerve-wracking experience with xp_cmdshell today.

In SSMS, I ran a command to "cd" to a directory, then "rename" some files in that directory. I made the ignorant mistake of running the commands separately - NEVER NEVER DO THIS.

What happened was, by the time I ran the "rename" command it defaulted to the "system32" directory and started renaming files there instead... talk about !!$#*@(!-up!

Has any ever done this, or heard about this horrible experience before? I am trying to document cases of this, so that I don't look like the complete idiot that I am.

View 2 Replies

Horrible Table Needs Help

Feb 12, 2008

I'm having a problem normalizing this table that I have. I know I'm breaking the rules by having redundant data in the same table but I'm not sure how I'm going to calculate a penalty and find the total score. Can some lead me in the right direction fix this table for me?

Code Snippet
USE [aidms]
GO
/****** Object: Table [dbo].[PerfOrder] Script Date: 02/11/2008 16:40:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PerfOrder](
[PerfOrderID] [int] IDENTITY(1,1) NOT NULL,
[ShowID] [int] NOT NULL,
[DivisionID] [int] NOT NULL,
[OrganizationID] [int] NOT NULL,
[PerformanceShiftID] [int] NOT NULL,
[Cancelled] [bit] NOT NULL,
[DateRegistered] [datetime] NOT NULL,
[PerformanceTime] [datetime] NOT NULL,
[ReadyToBeJudged] [bit] NOT NULL,
[FirstJudgeID] [int] NULL,
[FirstCaptionID] [int] NULL,
[ScoreA1] [decimal](18, 0) NULL,
[ScoreB1] [decimal](18, 0) NULL,
[SecondJudgeID] [int] NULL,
[SecondCaptionID] [int] NULL,
[ScoreA2] [decimal](18, 0) NULL,
[ScoreB2] [decimal](18, 0) NULL,
[ThirdJudgeID] [int] NULL,
[ThirdCaptionID] [int] NULL,
[ScoreA3] [decimal](18, 0) NULL,
[ScoreB3] [decimal](18, 0) NULL,
[PenaltyScore] [decimal](18, 0) NULL,
[TotalScore] [decimal](18, 0) NULL,
CONSTRAINT [PK_PerfOrder] PRIMARY KEY CLUSTERED
(
[PerfOrderID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: ForeignKey [FK_PerfOrder_Captions] Script Date: 02/11/2008 16:40:55 ******/
ALTER TABLE [dbo].[PerfOrder] WITH CHECK ADD CONSTRAINT [FK_PerfOrder_Captions] FOREIGN KEY([FirstCaptionID])
REFERENCES [dbo].[Captions] ([CaptionID])
GO
ALTER TABLE [dbo].[PerfOrder] CHECK CONSTRAINT [FK_PerfOrder_Captions]
GO
/****** Object: ForeignKey [FK_PerfOrder_Captions1] Script Date: 02/11/2008 16:40:55 ******/
ALTER TABLE [dbo].[PerfOrder] WITH CHECK ADD CONSTRAINT [FK_PerfOrder_Captions1] FOREIGN KEY([SecondCaptionID])
REFERENCES [dbo].[Captions] ([CaptionID])
GO
ALTER TABLE [dbo].[PerfOrder] CHECK CONSTRAINT [FK_PerfOrder_Captions1]
GO
/****** Object: ForeignKey [FK_PerfOrder_Captions2] Script Date: 02/11/2008 16:40:56 ******/
ALTER TABLE [dbo].[PerfOrder] WITH CHECK ADD CONSTRAINT [FK_PerfOrder_Captions2] FOREIGN KEY([ThirdCaptionID])
REFERENCES [dbo].[Captions] ([CaptionID])
GO
ALTER TABLE [dbo].[PerfOrder] CHECK CONSTRAINT [FK_PerfOrder_Captions2]
GO
/****** Object: ForeignKey [FK_PerfOrder_Division] Script Date: 02/11/2008 16:40:56 ******/
ALTER TABLE [dbo].[PerfOrder] WITH CHECK ADD CONSTRAINT [FK_PerfOrder_Division] FOREIGN KEY([DivisionID])
REFERENCES [dbo].[Division] ([DivisionID])
GO
ALTER TABLE [dbo].[PerfOrder] CHECK CONSTRAINT [FK_PerfOrder_Division]
GO
/****** Object: ForeignKey [FK_PerfOrder_Judges] Script Date: 02/11/2008 16:40:57 ******/
ALTER TABLE [dbo].[PerfOrder] WITH CHECK ADD CONSTRAINT [FK_PerfOrder_Judges] FOREIGN KEY([FirstJudgeID])
REFERENCES [dbo].[Judges] ([JudgeID])
GO
ALTER TABLE [dbo].[PerfOrder] CHECK CONSTRAINT [FK_PerfOrder_Judges]
GO
/****** Object: ForeignKey [FK_PerfOrder_Judges1] Script Date: 02/11/2008 16:40:57 ******/
ALTER TABLE [dbo].[PerfOrder] WITH CHECK ADD CONSTRAINT [FK_PerfOrder_Judges1] FOREIGN KEY([SecondJudgeID])
REFERENCES [dbo].[Judges] ([JudgeID])
GO
ALTER TABLE [dbo].[PerfOrder] CHECK CONSTRAINT [FK_PerfOrder_Judges1]
GO
/****** Object: ForeignKey [FK_PerfOrder_Judges2] Script Date: 02/11/2008 16:40:58 ******/
ALTER TABLE [dbo].[PerfOrder] WITH CHECK ADD CONSTRAINT [FK_PerfOrder_Judges2] FOREIGN KEY([ThirdJudgeID])
REFERENCES [dbo].[Judges] ([JudgeID])
GO
ALTER TABLE [dbo].[PerfOrder] CHECK CONSTRAINT [FK_PerfOrder_Judges2]
GO
/****** Object: ForeignKey [FK_PerfOrder_Organization] Script Date: 02/11/2008 16:40:58 ******/
ALTER TABLE [dbo].[PerfOrder] WITH CHECK ADD CONSTRAINT [FK_PerfOrder_Organization] FOREIGN KEY([OrganizationID])
REFERENCES [dbo].[Organization] ([OrganizationID])
GO
ALTER TABLE [dbo].[PerfOrder] CHECK CONSTRAINT [FK_PerfOrder_Organization]
GO
/****** Object: ForeignKey [FK_PerfOrder_PerformanceShift] Script Date: 02/11/2008 16:40:59 ******/
ALTER TABLE [dbo].[PerfOrder] WITH CHECK ADD CONSTRAINT [FK_PerfOrder_PerformanceShift] FOREIGN KEY([PerformanceShiftID])
REFERENCES [dbo].[PerformanceShift] ([PerformanceShiftID])
GO
ALTER TABLE [dbo].[PerfOrder] CHECK CONSTRAINT [FK_PerfOrder_PerformanceShift]
GO
/****** Object: ForeignKey [FK_PerfOrder_Show] Script Date: 02/11/2008 16:40:59 ******/
ALTER TABLE [dbo].[PerfOrder] WITH CHECK ADD CONSTRAINT [FK_PerfOrder_Show] FOREIGN KEY([ShowID])
REFERENCES [dbo].[Show] ([ShowID])
GO
ALTER TABLE [dbo].[PerfOrder] CHECK CONSTRAINT [FK_PerfOrder_Show]
GO

View 2 Replies View Related

A Horrible (well, I Think So) Recursive Join...

Apr 2, 2008

Hi,

I have been trying to solve this issue for around 8 hours, now. Can someoone help me?

I have two tables:

Employee (
EMPLOYEE_ID INT PRIMARY KEY,
NAME VARCHAR(25)
)

E.G.:

1 Mark
2 Tracey
3 Jim

STRUCTURE (
SUPERVISOR_ID INT,
SUBORDINATE_ID INT
)

E.G.:

1 3
2 3

I need to get a query that gives me the following query:

SUPERVISOR_ID, SUPERVISOR_NAME, SUBORDINATE_ID, SUBORDINATE_NAME

I think that the SQL is going to go recursive and I think that this can be done reasonably easily (sadly, I have struck out so far), but how?

Thanks in advance,

QuietLeni

View 7 Replies View Related

How Can I Display No Comments If There Is Not Any Comments ??

Oct 1, 2007

Hi all,

I have state, day_date, error, and text column. If there is data then it is showing all the columns. But if there is no comments I would like to show no comments in the text field. Currently I have this store procedure.

CREATE PROCEDURE dbo.up_daily_quad_text

@DAY_DATE datetime

AS

BEGIN

SELECT

dbo.adins_database.ZONE_NAME + ', ' + dbo.adins_database.ZONE_STATE AS [STATE AND LOCATION],

dbo.COMMENT_CATEGORY.NAME,

dbo.COMMENT.TEXT

FROM

dbo.adins_database,

dbo.COMMENT_CATEGORY,

dbo.COMMENT,

dbo.DIM_DATE

WHERE

( dbo.adins_database.adins_id=dbo.COMMENT.adinsdb_id OR (dbo.COMMENT.adinsdb_id is Null) )

AND ( dbo.COMMENT.comment_dt=dbo.DIM_DATE.DAY_DATE )

AND ( dbo.COMMENT_CATEGORY.category_id=dbo.COMMENT.category_id )

AND

dbo.DIM_DATE.DAY_DATE = @DAY_DATE

END

GO

GRANT EXECUTE ON dbo.up_daily_quad_text TO AdIns_SSRS

GO

How can I modify do that.

Thanks

Rozar2007

View 7 Replies View Related

Horrible Report Rendering Performance

Feb 11, 2008

Hello! We are having a strange problem with Reporting Services 2005. Our RS server is located in a DMZ with the supporting RS database housed in our internal network. We have a batch of reports that perform well when rendering to browsers in our internal network. However, when accessing these same reports externally, the reports take a very long time to render. The difference between internal vs. external is huge; we are looking at maybe a minute tops to render the report from an internal browser vs. 10-15 minutes from an external client browser. The website and reports are setup for anonymous access, so it shouldnt be an authentication problem.

The RS execution log doesnt indicate much difference between the two. The data retrieval does take a little longer (only a second or two), according to the log, for an external request. But still, the times recorded in the Execution Log dont match at all what we are experiencing for external requests.

The various logs, both for reporting services and IIS arent picking up any anomalies either and Im at my wits end as to what else I can use to try and troubleshoot this problem. Has anyone seen this behavior before, or have any ideas what might shed some light on this?

View 2 Replies View Related

Horrible Performance Connecting To A Remote Sql Server...how Can I Fix It?

Apr 11, 2007

Hello, I have a sql server installed on a server in my server room.

The problem I have is that when I try to connect to the server, it takes a loooooooooong time to open the connection. Even when connecting through the Sql Server Management Studio it takes about 30 seconds just to open the connection.

Can anybody help me with some pointers on how to troubleshoot this issue? It only happens with this specific server

It might be a configuration issue, but where can I find information on how to configure it correctly?

View 2 Replies View Related

Pls Share Your Experience With SAN's

Jan 26, 2001

Is anyone using sql server 70 or 2000 and a EMC or LSI Metastore SAN? If so, I would like to know how things are going for you. We are currently evaluating both of these products and will be making a decision as to which we will purchase in February. Please advise if you have anything positive or negative to offer.
Thanks.
Gail Wade
gwade@it.rjf.com