SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• How to Insert data from one table to Multiple tables

  Assume I have One source table with 10 columns and I have 10 diffrent destination tables. each colu…

  Prudhvi _SQL

  1 replies

  15 years, 12 months ago

  By: WayneS

• Job history running

  I have a job when you right click on it and go to history it says it is currently running. But whe…

  Jason Messersmith

  1 replies

  15 years, 12 months ago

  By: Shark Energy

• How to detect if SSRS is installed with T-SQL

  Hello everyone, I'm trying to write a script that will provide the state of each SQL Server service…

  Rudy Panigas

  13 replies

  15 years, 12 months ago

  By: Rudy Panigas

• Debugging Tool

  Is there such a thing as a debugging tool for triggers and procs for MS SQL Server? I would like to…

  Rog Saber

  1 replies

  15 years, 12 months ago

  By: Cadavre

• TSQL Code syntax problem

  Can someone please rectify the syntax error in below code in second line: SELECT @groupname = 'domn…

  Chandu-212374

  4 replies

  15 years, 12 months ago

  By: Cadavre

• Excel openrowset works on 32 bit but not 64 bit?!?!

  I've been around all the usuall suspects, I got the right file path, the command works on another s…

  Ninja's_RGR'us

  10 replies

  15 years, 12 months ago

  By: Elliott Whitlow

• How to programmatically determine the default SQL Server collation for a Windows locale?

  I work on a SQL Express 2008 R2 based desktop application that is sold to users in many countries. …

  m.ogden

  5 replies

  15 years, 12 months ago

  By: John Mitchell-245523

• Connect To Database Engine does not respond

  I am trying to Connect To Database Engine. I was able to get connected before. But, I am not able…

  monietamarind

  12 replies

  15 years, 12 months ago

  By: monietamarind

• Strange SSMS Behaviour

  I've managed to fix this but I really would like to know what was going on I had a very simple upda…

  Samuel Vella

  4 replies

  15 years, 12 months ago

  By: Samuel Vella

• Is this trigger okay?

  Is the trigger below correctly written? The reason I ask is that when I look in the Audit tables I …

  webskater

  7 replies

  15 years, 12 months ago

  By: Subbu S

• Quickest way to get SQL 2000 database up and running on SQL 2008.

  Hi there, Our main client is busy moving all of their satellite sites to one main site at a new loc…

  Horatio

  6 replies

  15 years, 12 months ago

  By: Horatio

• How to insert data into two tables using signle SQL Query.

  Hi 🙂 , Can any one suggest me , How to insert data into two tables using single SQL Query with out…

  M.Mohamed Faisal

  2 replies

  15 years, 12 months ago

  By: Subbu S

• Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is use

  Hi i am having issue where i try to update multiple(125) rows from values from a temp table in step…

  daryl.mclean

  3 replies

  15 years, 12 months ago

  By: daryl.mclean

• Need help understanding performance issue

  Hello All, I'm looking for some help understanding a performance issue. This is just a general que…

  Tom Bakerman

  10 replies

  15 years, 12 months ago

  By: Tom Bakerman

• Locking and concurrency

  From the link http://searchoracle.techtarget.com/tip/Oracle-vs-SQL-Server-Why-Oracle-wins SQL Serve…

  pshaship

  1 replies

  15 years, 12 months ago

  By: caladba