SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Application uses a value of the wrong type for the current operation.

  Hi Guys, I'm Randy and a newbie here so pardon if i have miss some other requirement to post my que…

  rmata_76

  5 replies

  14 years, 10 months ago

  By: rmata_76

• Recursion Query to get Children and children of children using With

  Hi All, Here is my problem . I have one mapping table Code.... Parent_code...Position H1 N…

  tusharsn

  7 replies

  14 years, 10 months ago

  By: tusharsn

• Failover Cluster too restricted

  Hello Everybody I have a problem with Failover Cluster 2008 and SQL Server 2008 R2... I have 2 serv…

  mvillar

  3 replies

  14 years, 10 months ago

  By: Elliott Whitlow

• Using a value from a previous row to decrement a value in the current row

  I was asked by a colleague how this might be done, and I repeated an example based on code I've use…

  back_of_the_fleet

  2 replies

  14 years, 10 months ago

  By: back_of_the_fleet

• Help with dynamic sql in sp

  I'll clarify: the gist of what I need is this: I'm building the sql string from text, variables, a…

  amy.walsh

  9 replies

  14 years, 10 months ago

  By: Orlando Colamatteo

• SQL 2008 SP2

  ok guys. pre service pack i run (dev env) select @@ version = Microsoft SQL Server 2008 (RTM) - 10…

  BLOB EATER

  1 replies

  14 years, 10 months ago

  By: Lynn Pettis

• Passed My Exam

  I'm not sure anyone really cares, but I earned my MCTS: SQL Server 2008, Database Development cert…

  Mike Scalise

  22 replies

  14 years, 10 months ago

  By: toddasd

• Datacenter Edition?

  I need more details about the datacenter edition. What does it offer that Enterprise doesn't have?…

  Luke79

  4 replies

  14 years, 10 months ago

  By: Steve Jones - SSC Editor

• Looking for a good source control system...

  Hey all, My team and I are looking for a source control system that best fits our need. Our need c…

  copett86

  7 replies

  14 years, 10 months ago

  By: Orlando Colamatteo

• Delete After Trigger

  I'm apparently having a "stupid" day as I'm trying to archive a deleted record from a table into an…

  WendellB

  15 replies

  14 years, 10 months ago

  By: toddasd

• SSRS 2008 R2 on Windows 7 Ultimate - Getting following error

  Hi everyone - Hope someone can help me out with this one. I've been having the darnest time trying …

  tan110

  2 replies

  14 years, 10 months ago

  By: tan110

• upload files & default column value

  i am uploading files into a table. i have a column of datetime with a default value of GETDATE(). t…

  peleg

  2 replies

  14 years, 10 months ago

  By: Orlando Colamatteo

• Brain racking for fun (Can you track/capture a select from a specific Login)

  The title says it all! I want to know is there a DMV or anything in sql that logs what is happening…

  bopeavy

  8 replies

  14 years, 10 months ago

  By: Lowell

• run sql script on SQL 2000 in 2 sec and sql server 2008 take 1-2 min same script

  GO /****** Object: StoredProcedure [dbo].[sp_Analysis] Script Date: 10/26/2010 15:19:02 ******/…

  kaushalkumawat

  3 replies

  14 years, 10 months ago

  By: steveb.

• char(13) is not putting in a CR

  HI All We have a task which sends and email and now the email has got to much to read on one line. …

  Ant-Green

  6 replies

  14 years, 10 months ago

  By: taybre