SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Linked Server Question (time out issue)

  Hi I've got a couple of Link Servers set up that post data to tables on two other machines. This i…

  cliff.leavitt

  1 replies

  16 years ago

  By: jmessersmith-1145599

• Connection pooling, why so many connections?

  On a very heavily used server I'm seeing an awful lot of .NET connections (>1000) . I assumed (alw…

  FNS

  6 replies

  16 years ago

  By: jmessersmith-1145599

• Connection error - see message in description

  Hi, I'm writing a web service to be consumed by a Silverlight proj. I'm getting the error above eve…

  paucann

  2 replies

  16 years ago

  By: Silverfox

• combine two tables

  I have two tables: Table1 has the list of default choices for the user to select: The listing of th…

  goodvnguy

  2 replies

  16 years ago

  By: goodvnguy

• add string(static) + integer(auto-increment) to a field

  I need to assign a seed number to a field which is something like this format: ABCD1234. Here, ABCD…

  bladerunner148

  1 replies

  16 years ago

  By: Paul White

• combine two tables

  I have two tables: Table1 has the list of default choices for the user to select: The listing of th…

  goodvnguy

  1 replies

  16 years ago

  By: Nabha

• Executing unix commands in SSIS

  I need to stop services and then re-start services as part of a process and was wondering what is t…

  timothy_kramer

  4 replies

  16 years ago

  By: Elliott Whitlow

• Combining returned List of rows in a Where Clause using AND operator

  hi all, please help. Im trying to write a SProc that receives optional parameter to retrieve data f…

  mayor

  7 replies

  16 years ago

  By: Nabha

• Identity key and normal forms in sql

  My Concepts are not really clear about following two things if someone can give description with su…

  mandarj123

  2 replies

  16 years ago

  By: Silverfox

• I need solution for subquery returned more than 1 value

  Hi to all , I have this trigger , when I want to delete a record from the table im getting the belo…

  m_goulay

  1 replies

  16 years ago

  By: ps.

• Shrink DB ?

  Hello, Thanks for your info, I got confuse today!.. my app runs very very slow .. my app vendor ask…

  winan888

  9 replies

  16 years ago

  By: Steve Jones - SSC Editor

• Trigger Code

  Please provide me sample codes for using trigger. And please provide me trigger interview questions…

  sridhar.yalamanchi

  3 replies

  16 years ago

  By: Marcin Gol

• Stored Procedure Runs Slow

  Hi Everyone, i have big problem with stored procedure since 3 weeks. Everything was perfect and now…

  t_marciniszyn

  2 replies

  16 years ago

  By: GSquared

• Field should read vertically instead of horizontal.

  I am trying to create folder labels for our Business Intake department. They currently use Busines…

  Erin.

  1 replies

  16 years ago

  By: Erin.

• generate column list

  There must be a simple way to do this... I want to convert a series of statements of the form "sele…

  Shane Petroff

  5 replies

  16 years ago

  By: Shane Petroff