SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• sql reconilliation query

  I have a table as follows: CREATE TABLE [dbo].[Trades( [Id] [bigint] IDENTITY(1,1) NOT NULL, [ExecI…

  craigj-671526

  3 replies

  15 years, 1 months ago

  By: Dwayne Dibley

• Difference between SQL Server Login and Database user

  Hi, I am confusing on SQL Server Login and Database user Could you clarify this. Thanks

  Nagaram

  5 replies

  15 years, 1 months ago

  By: Nagaram

• Execute Stored Procedure with Select Statement as Input Parameters

  Hi All, Is it possible to call a stored procedure by providing input parameters through a select st…

  prakashdotc

  10 replies

  15 years, 1 months ago

  By: vinothraj

• Procedure fails when called from a job

  Hello All, I can run a procedure succesffully from SSMS but when I add the procedure to a job step …

  Chrissy321

  9 replies

  15 years, 1 months ago

  By: Evil Kraig F

• Database Mail failures with Gmail

  I recently set up Database Mail in SQL Server 2005 running as a job. We typically send about 2000 e…

  dzoll

  9 replies

  15 years, 1 months ago

  By: Elliott Whitlow

• Insert into perm table where doesn't exist from temp table

  I thought this was simple and I guess not, missing a piece maybe: There is a file that is continous…

  smac

  2 replies

  15 years, 1 months ago

  By: smac

• Installation process of SSIS

  Hi All, I am using SQL Server 2008-Express Edition with Advanced Services, but it is showing that …

  AmritaLH

  3 replies

  15 years, 1 months ago

  By: steveb.

• Is Point in time recovery is possible in Bulk Logged Recovery...?

  This is what I have done (here I have mentioned the time as well) Recovery model: bulk inserted 200…

  seven.srikanth

  2 replies

  15 years, 1 months ago

  By: seven.srikanth

• Case Statement with not

  hi, i want a case statement like this CASE suc.status WHEN IS NOT 'Completed' THEN 1 ELSE 0 END sta…

  smriti.subramanian

  1 replies

  15 years, 1 months ago

  By: Dave Ballantyne

• Help building required SQL for a View

  I need some help compiling a SQL statement for a view. I’ve never tried something like this, not an…

  doug.milostic

  5 replies

  15 years, 1 months ago

  By: ColdCoffee

• How To Override Index Hints without Disabling the Index

  Is it possible in SQL 2005 to over ride the use of a specific index without disabling the index? Af…

  YSLGuru

  8 replies

  15 years, 1 months ago

  By: YSLGuru

• View Timesout For One User (Sometimes), But Not Other User

  Hello, I have a View that works efficiently under one user, but acts slow under another user. If us…

  defyant_2004

  5 replies

  15 years, 1 months ago

  By: Brandie Tarvin

• msdb.dbo.sp_send_dbmail @body parameter

  Is there a way for me to have more than one @body parameter in my msdb.dbo.sp_send_dbmail statement…

  Randy Powell-473969

  2 replies

  15 years, 1 months ago

  By: Brandie Tarvin

• Snapshots going into recovery mode

  Hello Everyone: I am running into repeated occurrences of a snapshot that goes into recovery mode a…

  krishp

  2 replies

  15 years, 1 months ago

  By: Brandie Tarvin

• Problem using Update query in Loop..

  Hi Folks, I need to update the value of "AssignedTo" column in my table (MITagging) to logged in us…

  heyzain

  2 replies

  15 years, 1 months ago

  By: heyzain