SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Copying one SQL Table from one Data base to another

  I have one MySQL based system(Version 14.1 Distribution 5.6.10) which is having one Database namely…

  anjang2k

  1 replies

  7 years, 12 months ago

  By: Sean Lange

• Last Execute Procedure

  Hi Experts, I have lot of unwanted procedures in my Database,I want to remove unwanted procedures f…

  patelmohamad

  1 replies

  7 years, 12 months ago

  By: Grant Fritchey

• Conditional order by

  Hi,I have a situation where I am selecting one column but requires a conditional order by on select…

  yogesh.l.patil 36576

  3 replies

  7 years, 12 months ago

  By: george_at_sql

• Same Instance, Different DB's, 1 Linked server

  Hello there, I got a question related to the SQL Server Linked Servers.I got the next scenario:1 In…

  Alejandro Santana

  1 replies

  7 years, 12 months ago

  By: Sue_H

• ?? on While loop go thru each record X number of times

  Hi Trying to setup a while loop to go thru each record on a temp table for 3 different rooms  …

  jbalbo

  3 replies

  8 years ago

  By: ScottPletcher

• Upgrade from SQL 2005 SP1 to SQL 2008 R2 SP3

  Hi, I have a situation where an old Classic ASP application (did I say old?:P) is running on win200…

  quackhandle1975

  3 replies

  8 years ago

  By: sgmunson

• Where GROUPING SETS is used.

  I am working as a Database Tester for quite some time. But I never comes across GROUPING SETS …

  saravanatn

  6 replies

  8 years ago

  By: saravanatn

• Msg 2715, Level 16, State 7, Line 2 Column, parameter, or variable #4: Cannot find data type varchar(50)

  I have a table that I wanted to drop and recreate by changing some of the data type from INT to VAR…

  deebabat

  32 replies

  8 years ago

  By: Gail Shaw

• SQL Server Profiler (action replay)

  Hi - Captured the trace from source server and ran them in destination. Question, how to compare th…

  SQL_Hunt

  7 replies

  8 years ago

  By: sgmunson

• Splitting a string after the first space after the 10th character?

  How can I split a string first space after the 10th character? For example: The sentence is 'Apple …

  shan-422658

  13 replies

  8 years ago

  By: sgmunson

• Order changed on result set

  Hi, I have a weird situation that as from yesterday one of our queries started changing the order i…

  jeandrep

  2 replies

  8 years ago

  By: Sean Lange

• SQL Authenticated User needs to change their own password

  We have an Access application that leverages ODBC DSN to link to SQL Server 2008 database. SQL Aut…

  Terry Mercer

  5 replies

  8 years ago

  By: HappyGeek

• SSAS Attribute cannot be found

  The attribute key cannot be found when processing: Table: 'dbo_FACT_PROD_QTY', Column: 'CONTRACT_RA…

  dduffie

  1 replies

  8 years ago

  By: sgmunson

• break cluster and get sql server available

  Hi Guys,.I have a very old sql server instance. Running Sql server 2008 on  Windows server 200…

  SQL_Hunt

  3 replies

  8 years ago

  By: ScottPletcher

• Activity monitor > %processor time

  Hi Team, In my sql server 2008R2, Activity monitor > Overview. %Processor time is not showing. d…

  Minnu

  5 replies

  8 years ago

  By: rajborntodare