SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• testing stored procedure

  I would like to know how to debug stored procedures from sql server management studio 2005. I basic…

  wendy elizabeth

  3 replies

  15 years ago

  By: WayneS

• Query assistance

  I am working on a report that will have a date parameter and I want to see any records where a pers…

  Sherri Barkley

  2 replies

  15 years ago

  By: Sherri Barkley

• WITH CLAUSE

  How to use multiple update with WITH SQL statement. I’m getting error message invalid object. ? WIT…

  kshatriya24

  4 replies

  15 years ago

  By: LutzM

• Unable to create instances in SQL Server 2005 Standard Edition

  Hi, I have XP SP2 with SQL Server 2005 Standard Edition installed in my Laptop but cannot setup a n…

  Gobind

  3 replies

  15 years ago

  By: Adiga

• need help to copy database from SQL server 2000

  I am trying to import data from sql server 2000 to my new database on 2005. First I created new dat…

  mak101

  2 replies

  15 years ago

  By: pankushmehta

• Problem with installing SP3 on SQL server 2005 Failover Cluster

  Hi. I'm having a weird problem with my failover cluster when trying to upgrade to SP3. First the hi…

  tommy 65853

  5 replies

  15 years ago

  By: tommy 65853

• Sql server timeout expired error

  I manage a web application. This app calls a stored procedure. The stored procedure works most of …

  rfalagan

  3 replies

  15 years ago

  By: Gail Shaw

• SharePoint, ASP.NET or SSRS

  I'm new to development and I need to build a front-end App that will will basically allow a user to…

  kd11

  1 replies

  15 years ago

  By: Sean Lange

• Create table with named versus un-named PRIMARY KEY

  Ok... need some clarification here: What is the difference (if any) between ------- Statement 1: U…

  DB_Newbie2007

  5 replies

  15 years ago

  By: Michael Valentine Jones

• How large should I make the physical disk resource for an MSDTC cluster?

  We are changing the MSDTC configuration on a server, electing to use a dedicated drive. MSDTC crea…

  DBADave

  3 replies

  15 years ago

  By: DBADave

• Linked server query from another application

  I have a specific database that I need to run a simple select statement against. The problem is tha…

  Hyabusact

  2 replies

  15 years ago

  By: Hyabusact

• user sa cannot connect to server

  Hi all, I am using sql server 2005 and trying to login with sql server authentication( user sa acco…

  keven_law99

  2 replies

  15 years ago

  By: keven_law99

• How to know what are the most used store procedures and functions in a Data Base

  Hi, Hi, I'm using SQL Server 2005, I was wondering if there is a command which result is a list of …

  teresita.castro

  4 replies

  15 years ago

  By: teresita.castro

• Deleting Duplicate Record in Production

  Hi, In our Production database, sometimes back the data getting duplicated because of not deletein…

  sqlusers

  2 replies

  15 years ago

  By: Ron McCullough

• Data From Excel To Table In Ms Sql

  Hi Frnds, Can u guide me, how to insert the data's from excel sheet to a table in ms sql 2005 ? For…

  Subbu S

  2 replies

  15 years ago

  By: GSquared