SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• How to Identify when a specific sql server build was installed on production

  I have an issue identifying the version of software that was installed on my production server. Whe…

  Pyman

  3 replies

  13 years, 5 months ago

  By: Pyman

• DB Mail question. Jobs won't send email but a test email works fine.

  I have setup DB Mail in our other production SQL Servers and it all works fine. Yesterday I built …

  Anonymous

  3 replies

  13 years, 5 months ago

  By: Gazareth

• help me for sql server 2012

  Hi I want to know enhancements in Sql Server 2012..I have read it from few sites..but i din't un…

  SWATH

  1 replies

  13 years, 5 months ago

  By: Ramdas

• SQL Trigger for multiple columns - Insert / update

  hi Team, I want to create a trigger, that that should fire when ever particular columns are updated…

  Minnu

  4 replies

  13 years, 5 months ago

  By: TheSQLGuru

• Adding Non-Cloustered Index differs no. of rows returned in resultset

  Hi, I was trying to tune a particular SQL query which use to take more than 10 seconds to return da…

  Suresh Arumugam

  3 replies

  13 years, 5 months ago

  By: Cadavre

• get the dates(start of the week) between 2 specified dates

  Hi All, I have two dates in sql Start -11/05/2012 (start of the week) End -11/26/2012(strat of the …

  var05

  8 replies

  13 years, 5 months ago

  By: var05

• Difference between dynamic query execution and static query execution

  Hi, i have requirement to read data array and the same is implemented as below Method1: declare …

  subramani.rudrappa 78855

  5 replies

  13 years, 5 months ago

  By: BrainDonor

• Iterating thru a Tables columns

  I have a dataset that i need to iterate thru in a row wise manner where each row has columns that w…

  richard.noordam

  16 replies

  13 years, 5 months ago

  By: WILLIAM MITCHELL

• Views -between operator in where clause

  How to specify a where clause in a view with between operator??? I have a view which shows empname …

  var05

  3 replies

  13 years, 5 months ago

  By: var05

• script all indexes on a table

  Hi, I need to script only indexes on one sql2008 database table only. how to do this in management …

  HBK_4700

  2 replies

  13 years, 5 months ago

  By: sanket kokane

• SQL Server 2008 R2 Merge Replication IDENTITY field issues

  We've recently migrated from a SQL 2005 configuration over to 2008 R2 and are now experiencing an e…

  benm 37301

  6 replies

  13 years, 5 months ago

  By: Vijay-154675

• how to explain the correlated subquery

  Hi All, I want to know how to explain the correlated subquey like "SELECT * FROM CUSTOMER A WHERE 1…

  viveksvkola

  2 replies

  13 years, 5 months ago

  By: Mickey Stuewe

• Failover Problem

  Dear, I have configured mirroring with high safety without automatic failover mode. For testing pur…

  shohelr2003

  5 replies

  13 years, 5 months ago

  By: shohelr2003

• SQL Jobs are not running on schedule

  SQL Agent is running, along with all SQL services. I've stopped and restarted them. My job schedul…

  hughesj23

  7 replies

  13 years, 5 months ago

  By: arnipetursson

• Web enabled SQL Server Management Studio?

  Does anyoen know if there is a web enabled version of SQL Server Management Studio?

  david.williams 50026

  11 replies

  13 years, 5 months ago

  By: samalex