SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Condition in Where clause query

  Hello, I have a business requirement to include a condition in the where clause. The condition is: …

  pwalter83

  19 replies

  15 years ago

  By: Gail Shaw

• Stored Proc for Reports

  I have to write stored proc to get the daily transaction for a specified date. Right now what i do …

  jojupi01

  5 replies

  15 years ago

  By: Sean Lange

• cannot get where clause to work for adventureworks query

  I have just downloaded the adventureworks sample db and was trying to run a few queries. my select …

  ksharpe

  6 replies

  15 years ago

  By: ksharpe

• Linked Server with Local System startup account

  I have a SQL Server 2005 SP3 with Windows Authentication only,not mixed mode, and the SQL Service s…

  Holly Kilpatrick

  9 replies

  15 years ago

  By: tfifield

• Query help for 'not in'

  Hi , I have a procedure which takes 6 params id seq param1 param2 param3 param4 I have to do update…

  Pink123

  5 replies

  15 years ago

  By: jcrawf02

• Local connection doesn't work

  Hello everybody, I experienced a problem I don't understand. I've a local server SQL2005 on my lapt…

  Gourou AWK

  4 replies

  15 years ago

  By: Gourou AWK

• SP skelton

  We are making all business logic of the project into SP format.. so all logic is written as a SP.. …

  BeginnerBug

  5 replies

  15 years ago

  By: Grant Fritchey

• how to do login onto main server

  Hi, I am working as a DBA. I need to setup connection in sql server R2 08 with other computers that…

  er.ravikumar1984

  1 replies

  15 years ago

  By: M&M

• Shrink Database Failure

  I've searched the net and I've restored a copy of our production database and I cannot shrink the d…

  Michael Viglas

  1 replies

  15 years ago

  By: Jeff Moden

• Date compare

  I would like to pull records from a table where that the closedate is within the last 30 days(of e…

  kd11

  5 replies

  15 years ago

  By: jcrawf02

• SS 2005 Disconnects odbc and web clients randomly

  Hope someone can guide me to a solution.. Been running the same setup for 18 months. Last week SQL…

  tcloud

  11 replies

  15 years ago

  By: Orlando Colamatteo

• SQL Server Management Studio - Standard Reports

  in the sql 2005 management studio, we can create a report by right clicking the database name (stan…

  dr.kusnadi

  18 replies

  15 years ago

  By: clare.xia

• How to perform BCP

  Hi, here is my table DROP TABLE dbo.ATP_MD_CLASSES GO CREATE TABLE dbo.ATP_MD_CLASSES ( CLASS_ID i…

  Nagaram

  1 replies

  15 years ago

  By: Orlando Colamatteo

• Web Sevice Documentation

  I need to provide some documentation for a .net web service I'm providing. These are largely made u…

  Thomas Brown-469441

  9 replies

  15 years ago

  By: Thomas Brown-469441

• I want to execute a procedure automatically at night 12.00 using service broker

  I have a table in which i am keeping members record in binary tree concept like multi level marketi…

  vritaz09

  8 replies

  15 years ago

  By: Orlando Colamatteo