SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Transaction Log Question Related to Log Shipping and DR (What's in a T-Log?)

  Hi All, You would think that it would be easy to find this information but I guess my googling skil…

  joshdbguy

  7 replies

  12 years ago

  By: Gail Shaw

• Please advise on unique index creation

  We are still on sql server 2005. We are trying to create a unique index on our patient table. The u…

  Coriolan

  4 replies

  12 years ago

  By: Coriolan

• Trying to drop table if it exists otherwise exit procedure

  Hi All I have a procedure that tests if the table exists if so then drop it What I am looking to do…

  Oracle765

  2 replies

  12 years ago

  By: below86

• DB failover that involves transactional and merge replication for sql 2008

  Hi all. I need to failover from live production server A to server B. However this server A is the …

  ChinChin_needshelp

  1 replies

  12 years ago

  By: Grant Fritchey

• Importing data from a Oracle view

  Hi All, I hope someone can help me or at least has had a similar experience that I can learn from.…

  Ness

  8 replies

  12 years ago

  By: SQLBuddy123

• passing comma delimited string as parameter to stored proc

  Have a need to pass a comma delimited string as a parameter to a stored procedure. That string cont…

  ramadesai108

  20 replies

  12 years ago

  By: Sean Lange

• Question: Find out SPID executed statement that ran a day ago

  Ok sorry for the confusing title. So I'm managing several servers, one is having serious performanc…

  Resender

  4 replies

  12 years ago

  By: Resender

• Update if Exist Else Insert if not exists

  Good day to all the gurus in this forum, I'm really new in sql programming and have some difficulty…

  rjbautista20

  1 replies

  12 years ago

  By: SQLCJ

• TEMPDB Errors After OS Patch - Could not allocate a new page for database 'TEMPDB'

  Hi All, After our network team patched our the OS on our database server two weeks ago we started g…

  Ken Overton

  12 replies

  12 years ago

  By: SQLBuddy123

• Issue with sp_prepare

  I am working with a 2008 R2 database with a BOBJ frontend. I am trying to figure out how make the q…

  Sam S Kolli

  5 replies

  12 years ago

  By: Sam S Kolli

• Log size growing very fast

  Hi!, Need Help, I have SQL 2008 R2, Database XYZ in simple recovery mode, the database log is growi…

  bubby

  21 replies

  12 years ago

  By: bubby

• dbcc dbrecover error during CheckLogBlockReadComplete.

  Hi Everyone, Over the weekend one of our SQL Server stopped and now one of the archive databases is…

  TerrenceTheCat

  11 replies

  12 years ago

  By: george sibbald

• Multiple sheet export to XLSX issue

  Hi All, I have been all over the web trying to figure this out, but no luck. Please assist if you…

  mikeg317X

  6 replies

  12 years ago

  By: mikeg317X

• Missing SysMessages

  Hi, I've a 2008R2 SQL server, and I would like to change the language in a session (to localize mes…

  Spamot Ide

  2 replies

  12 years ago

  By: Spamot Ide

• How to update a Table using Loop?

  Hi All, I'm trying to update the following table (SQL Server 2008 R2): MerchantNoTerminalNoCount…

  eligiable

  11 replies

  12 years ago

  By: eligiable