SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• JOIN Tables

  Hi, I have 2 tables TableA and TableB TableA MedicalCodeID EmisCode ReadCode 1 …

  riyadh_01

  5 replies

  11 years ago

  By: Eirikur Eiriksson

• Table Join issue

  I have a table which has holidays listed. tblHoliday 01/01/2015 04/25/2015 I have another table w…

  sarath.tata

  5 replies

  11 years ago

  By: Luis Cazares

• Delete Before Insert Trigger Statement

  Need assistance with my trigger (my first – still learning so please be gentle). What statement do …

  compgee

  2 replies

  11 years ago

  By: Lowell

• can you delete the contents of the updatecache folder

  this directory is over 2gb \Program Files\Microsoft SQL Server\100\Setup Bootstrap\Update Cache can…

  djordan 4543

  1 replies

  11 years ago

  By: Hartmann

• Select Statement

  Hi, I have a table called CPRDLkupMedical, with a sample of the data as shown below; MedicalCode…

  riyadh_01

  1 replies

  11 years ago

  By: Sean Lange

• Test backup restores (full + log) - restore databases automatically

  Hello I am working towards automating the process of testing our backups. For the meantime, I do it…

  fiyo

  8 replies

  11 years ago

  By: Grant Fritchey

• clone hierarchy to another table

  Hi, I have a table "t_prod_cat" which contains hierarchical data which is used in production to pre…

  boeledi

  2 replies

  11 years ago

  By: Grant Fritchey

• Importing a text file into SQL Server

  Hi, Someone was telling me that they had a text file that was both comma and piped delimited and th…

  itmasterw 60042

  2 replies

  11 years ago

  By: Jeff Moden

• Job failed - The job owner does not have server access

  Hello, We have SQL Server 2008 running on Windows Server 2008 R2. We have a maintenance plan that …

  fiyo

  5 replies

  11 years ago

  By: fiyo

• COMMIT fixes problem - or will it create one?

  my client has a stored procedure triggered by shipping action - basically adding an indicator to a …

  Seggerman-675349

  5 replies

  11 years ago

  By: Seggerman-675349

• Using DES3

  How do I tell SQL Server what key to use for DES3 decryption? I want to encrypt in Oracle and after…

  Michael Gerholdt

  1 replies

  11 years ago

  By: Eirikur Eiriksson

• Return UniqueIdentifier of newly inserted row

  I have the following insert statement: INSERT INTO [User].User_Profile …

  .Netter

  3 replies

  11 years ago

  By: Eirikur Eiriksson

• sql script deployment strategy?

  Hello, I work in an environment with 3 app devs. We need to keep our local dbs in synch with chang…

  sqlguy-736318

  1 replies

  11 years ago

  By: Eirikur Eiriksson

• SQL Server Agent Job

  How to configure alert when SQL Server Agent Job gets disabled. I want to get notified when Agent J…

  Admingod

  2 replies

  11 years ago

  By: Admingod

• Stored prosedur Set Value Column

  Hi member , My problem Stored prosedur Comments RATES1 Set Value @KUR how do I..? CREAT…

  TeknikServis27

  2 replies

  11 years ago

  By: ScottPletcher