SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Help with a query? Parent - Child hierarchy problem

  Hi, I'm hoping someone will be kind enough to give me a hand on a little problem I have. Basically …

  lewisdow123

  7 replies

  14 years ago

  By: MVDBA (Mike Vessey)

• Marge replication

  Hi, I am configured successfully Marge Replication in my PRO ENI. I have a small query.. If i i…

  saidapurs

  1 replies

  14 years ago

  By: Paul White

• Installing SP1 on SQL Server 2008 R2 Cluster

  Hi all MS KB article http://support.microsoft.com/kb/958734 says before installing SP1 on Passive n…

  SqlSavy

  5 replies

  14 years ago

  By: george sibbald

• sys.dm_db_index_physical_stats hangs in one of my databases

  Hi I'm looking at one of my databases and trying to get fragmentation info i run the query select …

  MVDBA (Mike Vessey)

  12 replies

  14 years ago

  By: Gail Shaw

• Decimal Points

  Hi Forumer's I have these query. I would like the result of AVG between the 2 dates to have 2 decim…

  Kaniguan_SQL

  1 replies

  14 years ago

  By: Paul White

• How to recover msdb when it suspect

  How to recover msdb when it suspect

  manju.ccc

  1 replies

  14 years ago

  By: Gail Shaw

• SQL Server 2008 Install Error during New SQL Server Stand-Alone Installation...

  Hello, I am encountering undisplayed errors for a SQL Server 2008 install during the "New SQL Serve…

  MadForPlaid

  8 replies

  14 years ago

  By: Jayanth_Kurup

• Enable Database mail..SMTP and SNMP

  I am a beginner in SQL Server..my question is for enabling database mail.. i came to know to that S…

  SQListic

  5 replies

  14 years ago

  By: SQL Surfer '66

• whether is it possible to write select query for this tables by following these condition ?

  here i am having 2 table create table Table1 ( ID int identity(1,1),name1 varchar(100) ) insert…

  Sivaganesh Tamilvendhan

  3 replies

  14 years ago

  By: Paul White

• basic of trigger

  hi all good morning, i want trigger to insert data to table2 once data insert in table1. i have …

  selvakumar.sms

  1 replies

  14 years ago

  By: Sivaganesh Tamilvendhan

• Not exactly code review or source code control

  Hi At our shop, code review entails that certain features are always present in a query going into …

  drew.georgopulos

  16 replies

  14 years ago

  By: drew.georgopulos

• if @@microsoftversion>0x07320000

  In all the replication stored procedures, we find following three commands: if @@rowcount = 0 i…

  luckysql.kinda

  5 replies

  14 years ago

  By: Paul White

• Unable to Login using SQLCMD

  I have trouble with command line login to sql server with sqlcmd using trusted login, but i am able…

  SQListic

  1 replies

  14 years ago

  By: Lynn Pettis

• Replace master and model database

  I have run into an issue where i am getting error: Error: 17310 Severity: 20 State: 1. Which caus…

  bopeavy

  4 replies

  14 years ago

  By: ScottPletcher

• omitting table-valued parameters

  I'm creating a stored procedure that will be passed several table-valued parameters. Will I be able…

  HMishkoff

  3 replies

  14 years ago

  By: HMishkoff