SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• How to update data with count expression

  Hi I am writing this tsql but I don't know how to add COUNT value in the table. Any idea please? Wh…

  zhtway

  1 replies

  15 years ago

  By: zhtway

• VIA Protocol Issue

  Some Idiot enabled the VIA protocol on my servers and I can not disable them. VIA Protocol continua…

  gareth.thompson

  1 replies

  15 years ago

  By: gareth.thompson

• TSQL copy data in weekdays

  Hi, I am very new and never write a TSQL code before. I started learning from yesterday. I have tho…

  zhtway

  9 replies

  15 years ago

  By: Jeff Moden

• cmd.Connection.Open(); Error 40 named pipes

  Hi Folks! I have an inherited application based off an Access db that is now a SQL 2005. And now it…

  richardso.k.e

  1 replies

  15 years ago

  By: Adiga

• Indexes and Partitioned Table

  Hi again, Question regarding a partitioned table and indexes.... we have a large table that has bee…

  amy26

  3 replies

  15 years ago

  By: amy26

• New Drive added to SQL Server 2005 not showing up

  We have added another SAN based Drive to our Clustered (Active/Passive) SQL 2005 server for the pur…

  mcelhaneyb

  10 replies

  15 years ago

  By: Perry Whittle

• SQL 32 bit to 64 bit linked server performance issue

  Hi, I have created a linked server using ODBC driver to add 64-bit SQL server instance to my machin…

  mukahmed20

  3 replies

  15 years ago

  By: abarona

• Error accessing remote server in a scheduled job

  We recently moved a database using a tool provided by NetApp that detaches the database, moves the …

  cphite

  2 replies

  15 years ago

  By: cphite

• Escaping forward slash in the query

  Hi, I have a query like this. select sum(net_underwriting_gain/loss) from <table_name> where …

  snehalata_d

  2 replies

  15 years ago

  By: snehalata_d

• SQL 2005 passwords

  Is there any way in SQL 2005 or SQL 2000, using SQL Server user authentication, that I can track wh…

  David Putman

  7 replies

  15 years ago

  By: Perry Whittle

• SQL 2005 Data Encryption and Clustering

  (first off, I'm not a SQL DBA , I'm a developer but I'm filling in while waiting for a full time re…

  duane.rezac

  1 replies

  15 years ago

  By: Perry Whittle

• RSExecution Log for SQL Server 2005 download

  Can someone tell me where to download the RSExecution Log for SQL Server 2005?

  arussell_10

  1 replies

  15 years ago

  By: arussell_10

• Decision before Installing SP

  Hi all I have to install SP3 on SQL Server 2005 Cluster environment. But I don't know which SP3 I h…

  snivas

  2 replies

  15 years ago

  By: snivas

• Openrowset on an excel 2007 file

  I use the following code to import data from an excel source: SELECT * FROM OPENROWSET('Microsoft.…

  hp-609534

  5 replies

  15 years, 1 month ago

  By: amrita2

• SSIS 2005 Queueing Sequence Containers?

  I need to build a process that can queue sequence containers (SCs) going into a sequence container …

  techglider

  1 replies

  15 years, 1 month ago

  By: techglider