SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Excel file Reading

  Hi guys., I am facing some problem from Excel source file reading because i need to rea…

  ranganathanmca

  1 replies

  15 years ago

  By: Orlando Colamatteo

• Update sql database table with UPDate Instruction using variable column name

  Hi Everyone I have 2 tables which are Table_1 and Table_2. Table_1 has the following structure …

  amuzelog

  4 replies

  15 years ago

  By: Jim Murphy

• is there any way to connect sql server 2000 enterprise manager using an ID

  I tried to connect using run as and enter my id and password but i am unable to connect to enterpri…

  krantkk

  2 replies

  15 years ago

  By: srivivek84

• Change table name

  I have a table in an DB called admin (dbo.admin) I want to change the name to administration (dbo.a…

  Edvard Korsbæk

  4 replies

  15 years ago

  By: Edvard Korsbæk

• trouble with joins

  I have a query that has dynamically created parts. It's not that complicated but I don't understan…

  vjlanter

  1 replies

  15 years ago

  By: GSquared

• Push Messages / Socket Programming

  I have a client application which runs on a several hundred machines in lab environments across sev…

  jones.justinw

  3 replies

  15 years ago

  By: jones.justinw

• Automated SQL Installer - encrypt password in template ini file

  Anyone got any ideas how we could encrypt the sa password in the template ini file when automating …

  Laura-205946

  3 replies

  15 years ago

  By: j32175

• bcp and queryout problem

  hi all, im getting SQLState = 28000, NativeError = 18456 error wen i execute the query mentioned be…

  sseetha

  1 replies

  15 years ago

  By: RamG

• Add SQL Management Studio to Cluster Node

  We have a two-node SQL 2005 Cluster. I've recently learned that one of the nodes does not have SQL…

  dan-572483

  1 replies

  15 years ago

  By: Lowell

• How to write a query for same Date2 but different Price?

  NameDate Date2 Price A28/01/2011 28/01/2011 10.5039 A27/01/2011 27/0…

  wertyui

  1 replies

  15 years ago

  By: GSquared

• Filtering a query

  Hi all; I have a report that lists the total sum of fees done in a specific date range. SELECT …

  iklektic

  6 replies

  15 years ago

  By: iklektic

• Trigger Help??

  Hi, I have been asked to create a trigger that removes/changes a flag on a table based on an insert…

  spin

  8 replies

  15 years ago

  By: spin

• Split coulumn value

  Hi from a result like this NumCodeStart DateEnd Date 204-201ABCDF2004-04-04NULL 204-203ABCDF…

  infodemers

  7 replies

  15 years ago

  By: WayneS

• SQL Server job problem

  Hi, I am having a problem with a task I have. I am trying to run a SSIS package as an SQL job. When…

  hector__21

  8 replies

  15 years ago

  By: dave-dj

• How to tune/speed up a procedure

  I have a stored procedure where I am converting old mainframe data that is in a staging table, and …

  andegre

  112 replies

  15 years ago

  By: Jeff Moden