SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Gaps in SQL Server Identity Columns

  I have an ID column that is an IDENTITY value. But I have now realized that there are gaps in my i…

  Casper101

  7 replies

  15 years ago

  By: Hugo Kornelis

• Having trouble re-installing SQL 2005 on a cluster

  I'm testing upgrading a SQL 2005 cluster to SQL 2008. After one successful upgrade, I've removed SQ…

  WayneS

  7 replies

  15 years ago

  By: WayneS

• linked server in trigger

  i have trigger in a table, when i insert data to the table, trigger execute insert query to the dif…

  Hendrianno Irawansky

  4 replies

  15 years ago

  By: Hendrianno Irawansky

• The strange case of missing memory

  SQL Server seems to have "lost" memory between two operations: I was experimenting with making cros…

  Elliott Berkihiser

  10 replies

  15 years ago

  By: Hardy21

• SQL Agent CmdExec - how to throw error without seeing JIT debugger option

  I have a .NET console app that I'm executing from SQL Agent. I am handling some exceptions, but in…

  samt222

  1 replies

  15 years ago

  By: Adiga

• calling a SP from crystal

  hi all i have a sp that works fine in sql and crystal designer - but if i try to run it in crystal …

  dopydb

  7 replies

  15 years ago

  By: dopydb

• Is it possible to combine the values from more than 1 record into 1 resultset?

  I'm working on a report, build on a stored procedure, that is supposed to only return 1 resultset. …

  Rod at work

  7 replies

  15 years ago

  By: WayneS

• SQL and OS when RAID 1 needs to be expanded.....

  We have a critical server on a DELL PE 2950 running Windows Server 2003 Enterprise 64-bit SP-2. We …

  nelsonj-902869

  3 replies

  15 years ago

  By: SQLRNNR

• File System vs BLOB

  Hi all, This is a question I've been researching and would like your input on: Is it feasible to re…

  chrisph

  13 replies

  15 years ago

  By: Steve Jones - SSC Editor

• add a new field

  select t1.*,t2.Product_Name from ( select mobid, max(case when seq=1 then merchant else null end) a…

  wilsons.marlen

  4 replies

  15 years ago

  By: Gail Shaw

• Grouping records issue

  Hi Guys, Been trying to rack my brains on how to do something in SQL that involved counts. We have…

  jalldridge 99781

  3 replies

  15 years ago

  By: jalldridge 99781

• tsql retrieve records on date

  Hi, I wanna retrieve records for today. But not working? Any idea? select freedate from holidays wh…

  zhtway

  15 replies

  15 years ago

  By: zhtway

• Which Method is best to copy data when the condition meets

  Hi, I have table1 and table2 and wants to MOVE the selected (on condition) rows from table1 to tabl…

  zhtway

  14 replies

  15 years ago

  By: zhtway

• Stored procedure not getting updated

  i am writing several stored procedures for seding database mails . I execute all those mail stored …

  balajisrm

  2 replies

  15 years ago

  By: Mike01

• Pivot Query

  Trying to figure out my first pivot query. I have a table that has two rows per site. I need to co…

  gbargsley

  6 replies

  15 years ago

  By: wayne.mcdaniel