SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• how to change the name of stored procedure?

  how to change the name of stored procedure? Thanks In Advance...

  surya_7482

  7 replies

  14 years, 7 months ago

  By: MyDoggieJessie

• Update Problem

  I have a column that is currently empty (NULL). I have to update all rows (thousands) based on a ca…

  Murphy'sLaw

  6 replies

  14 years, 7 months ago

  By: ColdCoffee

• TRIM vs. REPLACE vs. ?

  Having some trouble figuring this one out. I've got two tables: Contacts & ContactsNew. Contac…

  jllawrence

  3 replies

  14 years, 7 months ago

  By: ColdCoffee

• Changing a name of SQL SERVER instance

  Hi there! Situation: Old server named "TRANSIT" has been cloned in VMWare to a new server named "TR…

  jack.gargasz

  2 replies

  14 years, 7 months ago

  By: jack.gargasz

• Index seek possible or not

  I have some queries that use wild characters in the WHERE clause select name, address, city, number…

  savethytrees

  1 replies

  14 years, 7 months ago

  By: Gail Shaw

• DB Mail question. Wont send

  I have a SQL2008R2 SP1 CU4 cluster on Win2008R2. I have setup DBMail. I do a test email from Mgt …

  Anonymous

  13 replies

  14 years, 7 months ago

  By: Elliott Whitlow

• Profiler: should the audit login and audit logout always match in a profiler

  Hi all, I ran a trace this morning to see how many users are hitting a specific database, Based on …

  Pyman

  5 replies

  14 years, 7 months ago

  By: Elliott Whitlow

• Error on Extended properties when creating Objects that are not in the dbo schema

  I have a developer that gets the following error when trying to create a table that is not in the d…

  Welsh Corgi

  4 replies

  14 years, 7 months ago

  By: Welsh Corgi

• HERE I JUST WANT TO WRITE SELECT QUERY FOR A DATE BASE ON CURRENT DATE

  ExamsId DateOfExam PaperId PAPERNAME 1 2012-02-16 02:3…

  Sivaganesh Tamilvendhan

  10 replies

  14 years, 7 months ago

  By: piotrka

• Query options if variable not set

  Hello i have a query that i need help with. The query has a filter "where month= @month and custome…

  jocast

  2 replies

  14 years, 7 months ago

  By: Gail Shaw

• Trying to figure out why this is a full table scan

  Great Plains Query: ----------------------------- SELECT * FROM SOP30300 WHERE SOPNUMBE IN ( SELECT…

  aurato

  21 replies

  14 years, 7 months ago

  By: Jared

• Reportserver database causing blocking

  Hi, I'm seeing blocking by the procedure WriteLockSession in ReportServerTempDB I have verified t…

  gary1

  2 replies

  14 years, 7 months ago

  By: sengeet86

• SQL 2008 Leap year issue?

  I have an insert stored procedure that uses convert function to convert varchar() to datetime. The …

  clare.xia

  1 replies

  14 years, 7 months ago

  By: sengeet86

• Differential backup job is hanging for ever

  Hi, We have full/differential/log backups scheduled as below: Full 7pm Diff 1pm log every 15 mins …

  gary1

  8 replies

  14 years, 7 months ago

  By: gary1

• NEED HELP!!! UPDATING, DELETING, ETC.

  Choose a Job Description and increase by 10% all employees’ salaries that have the selected Job Des…

  spro1210

  14 replies

  14 years, 7 months ago

  By: Possinator