SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• How to get row value as column header

  Hi, This is my data. I am running this query i am getting result. Select empname,atndate,starttime …

  naresh0407 93367

  2 replies

  14 years, 10 months ago

  By: naresh0407 93367

• Why does Select fails with Transaction Deadlock Error?

  HI, I am running the following Select on production server, using Sql Server Management Studio. SEL…

  matsinopoulos

  11 replies

  14 years, 10 months ago

  By: Gail Shaw

• BDE x SQLServer (2005/2008) - Compatibility mode

  Hello!, Anybody know if the the SQLServer run without compatibility mode with the BDE? My problem i…

  fernando.ferreira

  2 replies

  14 years, 10 months ago

  By: fernando.ferreira

• Connection string custom attributes

  Hello, I have to add a custom parameter to the connection string (i cannot re-use other attributes …

  nicolae.dima

  1 replies

  14 years, 10 months ago

  By: Lowell

• create table abcde(id int identity, name varchar(20)default 'abcd')

  create table abcde(id int identity, name varchar(20)default 'abcd') how can i insert values like …

  Nagaram

  2 replies

  14 years, 10 months ago

  By: Nagaram

• Query for All the Contacts who purchased ALL the Products given in a variable list

  Hello All I have a query as with following situation Here are the sample db structure 1. tbl_Contac…

  DEEPAK GUPTA-378433

  3 replies

  14 years, 10 months ago

  By: prajey

• How to rename a database snapshot

  Hi All, I would like to know how to rename a database snapshot ? Please help. If you could take a l…

  babuganesh2000

  5 replies

  14 years, 10 months ago

  By: Jeffrey Williams

• Maintanance Plans output txt logs

  Hi The output txt files that are created in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG…

  Bristolred

  2 replies

  14 years, 10 months ago

  By: Jeffrey Williams

• Error converting data type varchar to bigint

  I have a scenario wherein I have to combine five date columns into one . Its SQL Server 2005 UPDATE…

  jagadeeps

  3 replies

  14 years, 10 months ago

  By: GSquared

• Duplicate records deleting between two tables

  Hi i need a query to identify duplicate records between two tables and delete tham from one table, …

  jagadeeps

  1 replies

  14 years, 10 months ago

  By: Ron McCullough

• SQL SERVER latency issue on new laptop - simple select of small table 7 seconds

  I've tried searching and all latency issues are much more complex. I have a new (to me) lap top wi…

  lklein

  9 replies

  14 years, 10 months ago

  By: lklein

• Customized Log shipping configuration in SQL 2005 Enterprice Edition

  Hi SQL Experts, I have scenario where we need to configure log shipping (SQL 2K5 Enterprise Edition…

  Nitin Gupta - SQL DBA

  4 replies

  14 years, 10 months ago

  By: Steve Jones - SSC Editor

• SQL Server 2005 Performance

  Hi, We currently have two SQL Server 2005 Enterprise (version 9.0.4053) servers running on Windows …

  Testsubjec

  4 replies

  14 years, 10 months ago

  By: Testsubjec

• common table expression(cte)--query

  hi everyone, i m working on a query related common table expression.my doubt is i got the results b…

  hemanth T

  1 replies

  14 years, 10 months ago

  By: Adi Cohn-120898

• Remote connections for sql server 2005 to one or two ip address.

  data base engine at a server should only be accessed from one or two ip addresses. it should not be…

  zameen555

  3 replies

  14 years, 10 months ago

  By: zameen555