SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Deny Backup

  Is there a way to deny a login from backing up any database on a sql instance, or will I need to de…

  RedDoorSQL

  5 replies

  13 years, 5 months ago

  By: Ant-Green

• Using Update Statement and vars to remember value from previous records

  Is the following possible. declare @prevStatus char(1) update table1

  bertinlosier

  2 replies

  13 years, 5 months ago

  By: bertinlosier

• two almost identical triggers working fine except one line in each

  I have two triggers that fire upon an insert that fires both simultaneously with no problems except…

  DaveBriCam

  8 replies

  13 years, 5 months ago

  By: Sean Lange

• Time out in insert statement

  Hi every body I have a large table (270 G) and i only have insert and select statement over this ta…

  mah_j

  9 replies

  13 years, 5 months ago

  By: Jeff Moden

• SQL Server 2008 R2 Setup How to chaneg system drive from C to D

  Hi, I have changed the following the "Shared Install DIrectory and Instance Directory" to D:\Progr…

  siewboon_see

  2 replies

  13 years, 5 months ago

  By: Lowell

• CHARINDEX and SUBSTRING

  Hi, Below given is my requirement. declare @SPos int,@EPos int set @SPos = CHARINDEX('[','{ Action…

  kalyav21

  6 replies

  13 years, 5 months ago

  By: Eugene Elutin

• What ports SQL Server uses for LogShipping:

  Hi, We have configured log shipping in SQL Server 2008 R2. Primary Server A has a named instance on…

  Mani-584606

  4 replies

  13 years, 5 months ago

  By: Perry Whittle

• History of executed query

  Hi Experts, I want to see if there is a way to find the spid,block by witch session,what is the blo…

  mah_j

  1 replies

  13 years, 5 months ago

  By: bleroy

• Help! Replication high latency problem

  In live environment, I have published 5 databases from MAIN-DB to REP-DB using PULL transactional r…

  alanlee

  4 replies

  13 years, 5 months ago

  By: alanlee

• Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

  Hi all, Am getting the above error in my procedure. this is my procedure ALTER procedure [dbo].[usp…

  sandeep.vemulas

  7 replies

  13 years, 5 months ago

  By: Richard Warr

• Some questions about using partition table with multiple disk drives

  let's assume that I have scenario as following: - Table tbl1 for customer 1, table tbl2 for custome…

  lovinginmyheart

  4 replies

  13 years, 5 months ago

  By: Gail Shaw

• How to Restore .mdf file into sqlserver 2008 without .ldf file

  I have only .mdf file How to Restore .mdf file into sqlserver 2008 without .ldf file

  sreenu_rvkl

  15 replies

  13 years, 5 months ago

  By: matt.bowler

• Index on View with distinct values

  I have made a view in SQL that retrieves the distinct values of ID numbers and Names from an archiv…

  Amy.G

  1 replies

  13 years, 5 months ago

  By: TheMaskedDBA

• SQL Search Query

  hello, right now on my search page the sql query i am using is similar to: select * from table wher…

  duro654321

  4 replies

  13 years, 5 months ago

  By: Steven Willis

• Importing a Unix file to SQL

  I have a situation where I need to be able import a unix file into SQL. I can get the unix file to …

  David Lester

  10 replies

  13 years, 5 months ago

  By: David Lester