SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Compare tables of different servers

  Hi, I have two databases under two different servers. Server1: DB1 Table1 Server2: DB2 Table2 I nee…

  vigneshkumart50

  1 replies

  11 years, 2 months ago

  By: Grant Fritchey

• SSIS training - in depth

  I have been working with Integration Services for several years, and my boss wants me to get to Nin…

  Jason Marshall

  9 replies

  11 years, 2 months ago

  By: Koen Verbeeck

• Report Option Missing from Right-Click Menu in SSMS

  Hi, I have a user wom needs to view the standard reports made available through the right-click -&g…

  ReamerXXVI

  4 replies

  11 years, 2 months ago

  By: Koen Verbeeck

• SSIS licensing

  Hi, We want to use SSIS for ETL purpose If I install only SSIS on a server, then do we need to pay …

  gary1

  1 replies

  11 years, 2 months ago

  By: Koen Verbeeck

• Book example doesn't work, how come?

  Hi all, this is my first time here so I have some very basic questions. I'm not a DBA but I inheri…

  r.morgan

  10 replies

  11 years, 2 months ago

  By: Gail Shaw

• How to get Calling DB name within a stored procedure

  Hi All, I have a log database where I have all the stored procedure for logging to log tables. Ther…

  er.mayankshukla

  1 replies

  11 years, 2 months ago

  By: Eirikur Eiriksson

• Move to 1 row

  I have data something like this: ID Date Route routeDate TripType A1 20141001 UK-US 20…

  girl_bj

  3 replies

  11 years, 2 months ago

  By: Ville-Pekka Vahteala

• NORMSDIST Excel function for SQL Server 2008

  Hello, I'm trying to program the NORMSDIST Excel function in SQL Server 2008, can you help me? Tha…

  ruben.rubenromero

  1 replies

  11 years, 2 months ago

  By: Luis Cazares

• installing multiple editions on same computer

  hi all. Have a question regarding the ability/conflicts of installing different editions onto a win…

  rosefrost68

  3 replies

  11 years, 2 months ago

  By: rosefrost68

• Datatype to be changed from Varchar to Nvarchar

  Hi, I have few set of columns for whose datatype has to be changed from Varchar to Nvarchar , all t…

  bspavan86

  4 replies

  11 years, 2 months ago

  By: ScottPletcher

• How to resolve deadlock issues.

  Wondering if someone can help out. I have been encountering deadlocks every half an hour. How can I…

  LearningDBA

  18 replies

  11 years, 2 months ago

  By: ScottPletcher

• Function returns different values

  Hello I am calling function through Linked server and it returns different values when i select as …

  yogi123

  9 replies

  11 years, 2 months ago

  By: g.britton

• JDBC driver and setting unicode or non-unicode

  I have a 3rd party java app that uses JDBC to pass API cursor calls to my DB. What I'm noticing is …

  devrice

  4 replies

  11 years, 2 months ago

  By: markecassidy

• Changing Datetime to Int and set it to beginning of month

  Hi Guys and Girls, I have the following: SELECT CAST(CONVERT(VARCHAR(8), GETDATE(), 112) AS INT) SE…

  frdrckmitchell7

  5 replies

  11 years, 2 months ago

  By: ScottPletcher

• Why CTE should begin with semicolon or Go

  I had this doubt that why CTE should begin with semicolon or Go. My thinking is , that this is for …

  er.mayankshukla

  6 replies

  11 years, 2 months ago

  By: er.mayankshukla