SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Moving from SQL 2005 to 2008 R2 - What about server roles and membership?

  Currently planning a migration from SQL Server 2005 to 2008 R2. I've covered my bases by using Micr…

  andy.l

  2 replies

  14 years, 5 months ago

  By: andy.l

• RML ostress error

  Hi, I'm attempting to replay a trace using ostress from the RML utilities and am stuck. Trying to r…

  emailgregn

  1 replies

  14 years, 5 months ago

  By: emailgregn

• The curious case of missing stored proc changes.

  While I have achieved a "solution" to this issue, I am keen to understand just what has happened. …

  ProofOfLife

  8 replies

  14 years, 5 months ago

  By: Devendrakumar

• SQL Server 2008 Integrated with Sharepoint 2010

  Does SQL Server 2008(non-R2) work with Sharepoint 2010 or is it only compatible with R2?

  swetak

  1 replies

  14 years, 5 months ago

  By: SpringTownDBA

• Updating Stats

  I'm setting up a nightly job to update stats on largest tables. What are the implications for incr…

  Lexa

  33 replies

  14 years, 5 months ago

  By: Gail Shaw

• Identity value Reset

  Hi All, I have a question regarding resetting the identity column. If i have 5 rows in a table and …

  kevin4u06

  7 replies

  14 years, 5 months ago

  By: Devendrakumar

• SP Runtime error - Transaction count mismatch

  Hi I have this SP where the table is name used is wrong which is intentional CREATE PROC test_dele…

  ek-822869

  7 replies

  14 years, 5 months ago

  By: Devendrakumar

• MAP Toolkit Help Please..

  Hi Guys, Is anyone has worked on MS MAP Toolkit in SQL Enviornment ? I am planning to run this too…

  SQlLogic

  1 replies

  14 years, 5 months ago

  By: Ali Tailor

• 3rd party Data Quality Issues

  Every month a 3rd party sends us a text file that we import into a custom app and finally our datab…

  Barkingdog

  3 replies

  14 years, 5 months ago

  By: Devendrakumar

• Use of WITH(NOLOCK)

  Hello Gurus and Ninjas, I have a question pertaining to the use of WITH(NOLOCK). I had bot really …

  Jared

  19 replies

  14 years, 5 months ago

  By: Jared

• Managment Studio. Different PC's give different result for same query.

  Hi All, I have a problem that seems to be in the configuration of the PC's that we have running Man…

  Scott Levy

  20 replies

  14 years, 5 months ago

  By: Jared

• timeouts on SQLServer with SQLTrace_Lock

  The system has encountered difficulty: SQL Command Failed; SQL = gw_LookupURI ---------------------…

  Pyman

  6 replies

  14 years, 5 months ago

  By: Pyman

• How to retrieve tables , sp's, views , functions related to a particular field?????

  Hi, I need to retrieve all the tables, stored procedure's, views, functions etc which are related t…

  Hakuna Matata

  8 replies

  14 years, 5 months ago

  By: Jared

• Stored procedure question - Compile vs runtime

  I gave the wrong table in the SP it compiled fine and gave me run time error. Again i gave the wron…

  ek-822869

  2 replies

  14 years, 5 months ago

  By: ek-822869

• need query help

  hi, I have a table that i need to query to get distinct procduct # > 2009-01-01. table structure…

  apatel 89420

  2 replies

  14 years, 5 months ago

  By: GSquared