SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Help merging data from two tables

  I have two tables, like the ones below: declare @tblA table ( ID int, Value int, primary key ( ID )…

  N_Muller

  1 replies

  12 years ago

  By: autoexcrement

• Maintenance Plans

  When scheduling maintenance plan on SQL server for e.g. index rebuild + Integrity check etc. do we …

  Admingod

  4 replies

  12 years ago

  By: Nadrek

• Windows Server 2008 R2 Enterprise - Using windows update SQL Server 2008 R2 sp2 does not appear

  Does anyone know why when using windows update sometimes service packs or other updates are not dis…

  nickm_GR

  5 replies

  12 years ago

  By: Nadrek

• Stored Procedure error need help

  I keep getting the error below when I run the stored procedure at the bottom. I cannot figure out …

  jrusso

  3 replies

  12 years ago

  By: jrusso

• Preventing Duplicate Rows On An Insert

  Hi All, I'm having issues with duplicate rows being inserted into a table and need some thoughts on…

  AZ Pete

  4 replies

  12 years ago

  By: terry999

• Receiving Error 1944 when Rebuilding an index

  I ran an ALTER INDEX REBUILD statement on a SQL Server 2008 instance (10.0.2775) against a PK parti…

  RSMaxwell

  16 replies

  12 years ago

  By: SQLRNNR

• Log shipping versus point in time

  I realize that log shipping is for failover, however what happens if we would like a point in time …

  djj

  4 replies

  12 years ago

  By: djj

• passing parameters to stored procedure through OPENQUERY

  What is the correct syntax to use when passing parameters to a stored procedure through OPENQUERY? …

  Alex R

  16 replies

  12 years ago

  By: sgmunson

• Using INSTEAD OF Triggers On Views

  http://msdn.microsoft.com/en-us/library/def01zh2(v=vs.80).aspx when i am trying to create the trigg…

  rxm119528

  14 replies

  12 years ago

  By: lnoland

• Rolling Data - Previous 3 months, Current, future one month

  I am trying to create a rolling data analysis of sales information for a given period, rolling 3 mo…

  SteveEClarke

  4 replies

  12 years ago

  By: SteveEClarke

• Can't find error message when trigger fires

  Hi there, I'm hoping someone can help us. We have a trigger that fires off a stored procedure usi…

  rwaring 96203

  3 replies

  12 years ago

  By: Jeff Moden

• Disable and Enable Constraints in a Table in SQL Server

  Hi All, I have a Table, on which i am performing Bulk Insert Operations. For This, i am First Disab…

  Mr. Kapsicum

  6 replies

  12 years ago

  By: Jeff Moden

• Using a CASE statement and checking for NULL values?

  Hi Everyone, I am using the CASE statement below (the commented section does not work, and it is th…

  david.dartnell

  5 replies

  12 years ago

  By: david.dartnell

• SQL Server 2008 with IBM Websphere

  I have a project coming up where we are migrating our Lawson ERP system from IBM Unix servers runni…

  prescientdba

  1 replies

  12 years ago

  By: mwhitcom

• Datetime filter now working

  Hello, I have no idea why i can't get this to work. In my where clause, i have a datetime field whi…

  THE_BOZ

  7 replies

  12 years ago

  By: MMartin1