SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Primary Key Violation Frustration

  I'm getting really really frustrated. I have a table with a single column Primary Key. I have a map…

  Brandie Tarvin

  15 replies

  14 years, 10 months ago

  By: Orlando Colamatteo

• can we use more than one join for 2 tables

  Hi Experts, can we use more than one join for 2 tables. Thanks Venki

  ursfriend77

  11 replies

  14 years, 10 months ago

  By: Mad Myche

• change the path of attatchment file

  Hi I need help how to change the attatchment for drve to anther drive UPDATE dbo.dlnk SET attachme…

  wkilani

  3 replies

  14 years, 10 months ago

  By: Mike01

• Why is it that opening .sql files in a project requires signing in each time?

  My boss is taking the summer off for some internship he's working on, so I've got to cover for him.…

  Rod at work

  7 replies

  14 years, 10 months ago

  By: Rod at work

• Making data available across servers

  Hi, I'm wondering what options there are to make data available between servers/instances. Two obvi…

  David Cameron (not the PM)

  4 replies

  14 years, 10 months ago

  By: Jeffrey Williams

• Seeing logshipping degradation - any idea why?

  Hello! I am logshipping from my production SQL 2005 server to a DR server offsite. There are 7 dat…

  Matt Klein-228552

  5 replies

  14 years, 10 months ago

  By: TheSQLGuru

• IGNOREing Records based on Addition SUM Criteria

  Hi, I'm using a query as: ------------------ WITH ExData AS ( SELECT TId,Ttype,TAmt, SUM(CAS…

  SG_Explorer

  4 replies

  14 years, 10 months ago

  By: SG_Explorer

• Next half an hour time

  Hi, here is the sample table create table #temp ( startdate datetime ,enddate datetime ) insert int…

  Nagaram

  5 replies

  14 years, 10 months ago

  By: jcrawf02

• Defined SQL Server functions seem to hang

  Hi, I have a problem and I don't know what else to look. We have these sql functions (scalar and ta…

  zaizaisql

  3 replies

  14 years, 10 months ago

  By: zaizaisql

• problem with SQL Agent 2005

  I have two instances of SQL Server 2005 SP3 'Test' and 'Prod' on same server. i scheduled SSIS pack…

  rajeevmehr

  5 replies

  14 years, 10 months ago

  By: Welsh Corgi

• Help please. SQL 2005 express sp1, sqlservr.exe high CPU usage

  :w00t: The App is named isalon, when doing report/analysis for one month, it takes very long, 15/20…

  aaapppleee

  19 replies

  14 years, 10 months ago

  By: Welsh Corgi

• Max on ndf but not on mdf

  What happens when the ndf has a max size, but the mdf has unlimited? Will it start populating the m…

  lulu_lutz

  2 replies

  14 years, 10 months ago

  By: lulu_lutz

• SQL 2005 query to summarise total RESPONSES for each SEGMENT.

  Please see below image for more info... Your help is much appreciated...

  GomuGomuNo

  1 replies

  14 years, 10 months ago

  By: Sean Lange

• SQL Query wanted

  Hi All, I have a reference table that table have two columns ie "value" and "text". The records ar…

  anbaz1976

  1 replies

  14 years, 10 months ago

  By: Sean Lange

• how to convert in sql query

  Hi All, I have a table , it stores the month value as 1;2;3;4 but i want to store instead of the …

  anbaz1976

  3 replies

  14 years, 10 months ago

  By: jcrawf02