SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• 70-433 exam

  Hi All, how to prepare 70-433 exam can any one provide material plz plz...

  cooljagadeesh

  2 replies

  13 years, 5 months ago

  By: Ron McCullough

• T-SQL to get all available instances on the server

  hi, can any body help me out on T-SQL to get all available instance names on the server.

  Zeal-DBA

  2 replies

  13 years, 5 months ago

  By: j.miner

• ODBC connection

  Hi, I am trying to connect to my remote SQL Server 2008 database for SAP Business Objects using odb…

  hvhoang3985

  2 replies

  13 years, 5 months ago

  By: j.miner

• Getting "severe error" when referencing a table that doesn't exist

  This is the error (all databases): Msg 0, Level 11, State 0, Line 0 A severe error occurred on the …

  jeffem

  9 replies

  13 years, 5 months ago

  By: sgmunson

• Question about RPC for linked servers.

  OK, so I am trying to figure out what the purpose of the RPC option for sp_serveroption is for. I u…

  tim.cloud

  1 replies

  13 years, 5 months ago

  By: Mani Dev

• Request

  I hope I am not being too cheeky posting this here, but I would appreciate some page views on my ar…

  Sean Pearce

  7 replies

  13 years, 5 months ago

  By: schleep

• difficult query

  My data is the log of changes to 3 specific records for an AppID. The AppCatID describes the 3 diff…

  jonesg 74626

  11 replies

  13 years, 5 months ago

  By: Sean Lange

• Convert SQL Server DateTime2 to AS400 DB2 Date

  I need to convert a SQL Server DateTime2 Column to an AS400 Date. The format of the AS400 Date is C…

  Welsh Corgi

  3 replies

  13 years, 5 months ago

  By: Welsh Corgi

• SQL Server 2008 Management Data Warehouse

  Folks, I am trying to build a SQL Server jobs historical warehouse. This is to run reports to see …

  boris_shvartsman

  6 replies

  13 years, 5 months ago

  By: boris_shvartsman

• SSRS - Lines aren't connecting in graph and dataset doesn't contain NULL values?

  I created a chart in reporting services. My dataset uses a running total with a DATEADD function to…

  DataAnalyst011

  2 replies

  13 years, 5 months ago

  By: DataAnalyst011

• Don't know sa pwd - Trying to add a sysadmin

  I have a SQL2008 Express server where the only sysadmin is sa and no-one knows the sa password. I …

  Randy Doub

  4 replies

  13 years, 5 months ago

  By: emile.milne

• HOW TO WRITE A SELECT QUERY FOR THIS TABLE AND WHEN THE SOTRE PROC @PARAMETER IS NULL?

  HERE IAM HAVING A SAMPLE TABLE declare @T table ( Name char(1), HEIGHT deCIMAL(18,2) ) insert…

  Sivaganesh Tamilvendhan

  2 replies

  13 years, 5 months ago

  By: Sivaganesh Tamilvendhan

• Alter Database blocked by spid -2

  I'm trying to restore an HP Quality Center database with full text catalog and the restore works in…

  ggoble

  8 replies

  13 years, 5 months ago

  By: TedS

• Retrieving only character result set from varchar column

  Hi guys, I have an employee table, in this table there is a column called employeeId(Varchar(5000))…

  farooq.hbs

  4 replies

  13 years, 5 months ago

  By: Jeff Moden

• Maintenance Plan: View History takes long to open

  Hello all, this is something that really annoys me: when I want to check my Maintenance Plan for ba…

  Arthur Kirchner

  4 replies

  13 years, 5 months ago

  By: Jeff Moden