SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• what's wrong with this update

  Always give error I want to check the entered data before update update test set REC_HHMMSSHS =( …

  Ali.M.Habib

  2 replies

  15 years, 10 months ago

  By: LutzM

• positioned update problem

  I get the following error when executing the code listed below. Any ideas what I'm doing wrong? Ser…

  Ali.M.Habib

  2 replies

  15 years, 10 months ago

  By: Dave Ballantyne

• Remote SQL Server Registration

  Hello everybody, I am trying to register a remote sql server 2000 in my enterprise manager. But it …

  mohitkumarsingh

  1 replies

  15 years, 10 months ago

  By: darryl_marshall

• Access a MS SQL server database on anather server via a store procedure

  Need to access a MS SQL server located on another server using a store procedure. The calling store…

  garcia1533

  3 replies

  15 years, 10 months ago

  By: RBarryYoung

• How do I declare a varible equal to a value in a table?

  Hi all, hope this is a quick and dirty one but how do I state a declare variable to be equ…

  Mitch2007

  4 replies

  15 years, 10 months ago

  By: rgillings

• Alerts In Sql 2005

  Can Any one tell me how we can enable Alerts in Sql 2005 ? when any changes are done on one of the…

  harishchede

  1 replies

  15 years, 10 months ago

  By: MJ-1115929

• Does anybody know where to find documentation on SQL Server performance monitor variables?

  Hi, When I go into Performance Monitor and add SQL Server objects, I know there are some brief desc…

  rsteckly

  1 replies

  15 years, 10 months ago

  By: Eswin

• Same tables different counts

  Good day all, have a weird oddity here that has left me scratching my head. I ha…

  Mitch2007

  9 replies

  15 years, 10 months ago

  By: Lynn Pettis

• Help with Case Statement

  Hello, I have the following code in my stored procedure: [CTTitle] =(SELECT TOP 1 TITLE FROM mms.d…

  kam7395

  7 replies

  15 years, 10 months ago

  By: kam7395

• Substring statement

  Here is the query I'm using in order to get headcounts of students by groups (first time freshmen, …

  tiffany.franks

  3 replies

  15 years, 10 months ago

  By: Jeff Moden

• Instead of Update Trigger on View

  Hello, I am working on a project that requires that I be able to make changes to a view as though i…

  tyler-1087856

  4 replies

  15 years, 10 months ago

  By: tyler-1087856

• SQL Server 2005 Insert Delete Trigger causing Access 2003 Forms to lose master-detail linkage

  We are creating triggers on tables in sql server 2005. When certain data items in certain tables c…

  iapearsall

  7 replies

  15 years, 10 months ago

  By: iapearsall

• Using alter command in Stored Procedure

  I created the following SP but when I execute it in query analyzer I receive an error saying the E…

  SQLUser-308930

  5 replies

  15 years, 10 months ago

  By: Jeff Moden

• EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process..

  I have a Stored Procedure calling the Send_mailHTML stored procedure I loaded from this site, which…

  kwilliams-1095468

  2 replies

  15 years, 10 months ago

  By: kwilliams-1095468

• Stuck on Query

  So I'm a bit stuck on this problem and wanted to see if any of the gurus out there had any thoughts…

  dan.rosenberger

  2 replies

  15 years, 10 months ago

  By: dan.rosenberger