SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Running 32 bits CLR DLL on a SQL Server 64 bits

  Is it possible? Or should I recompile the DLL in 64 bits and recreate the assembly in sql? Because …

  Megistal

  1 replies

  15 years, 10 months ago

  By: Gift Peddie

• Incorrect syntax error T-SQL SP SS2K5

  Hi y'all, Can't find anything related to this, so here goes... I get the Incorrect syntax near the …

  Randy Anthony

  8 replies

  15 years, 10 months ago

  By: The Grateful DBA

• Stored procedure or a trigger to strip html tags in the DB

  Can anyone please guide me on how to create a stored procedure or a trigger that would be run every…

  SQLTestUser

  1 replies

  15 years, 10 months ago

  By: John Rowan

• SQL Server 2008/5 Database-Writing-Concept when Recovery-Mode Full

  Hi there, I was discussing with a collegue the different concepts of database-systems to write upda…

  christian_t

  1 replies

  15 years, 10 months ago

  By: Gail Shaw

• Delete DML and tempDB

  Hello, I'm currently facing an issue with tempDB when using a simple delete DML statement: DELETE …

  Megistal

  8 replies

  15 years, 10 months ago

  By: Megistal

• Migrate SSIS Packages

  Hey Can anybody tell me how to migrate SSIS packages from SQL Server 2005 to SQL Server 2008 Thanks

  Bluesky-539179

  1 replies

  15 years, 10 months ago

  By: The_SQL_DBA

• Quick way to add several tablix columns?

  Re-posted this under Reporting Services. /* Anyone know how to add several columns to a Reporting S…

  MNsql

  1 replies

  15 years, 10 months ago

  By: MNsql

• Problem with MS DTC on SQL2008 win server 2k8 with linked server from sql2000 win server 2k

  Hi, We have migrated our db from sql2000 win server 2k to sql2008 win server 2k8. We have linked se…

  dzache

  2 replies

  15 years, 10 months ago

  By: Gail Shaw

• Error in Query

  IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[ACC_VW0054]')) BEGIN ALTE…

  rahul.jain

  1 replies

  15 years, 10 months ago

  By: dmoldovan

• clustered index confussion

  hi all, please help on below it is possible to create clustered index on col which does not have de…

  Shivrudra

  1 replies

  15 years, 10 months ago

  By: SQLRNNR

• Access SQL 2008 Linked Server without specifying default Database Name

  Hello, I am a newbie using Linked Server and I try to access the default database of a linked serve…

  mathieu.lapointe

  6 replies

  15 years, 10 months ago

  By: mathieu.lapointe

• Missing some text in output of sp_updatestats in job step

  I'm running this code in a job step of the SQL Server Agent: -- Cursor on all databases (except tem…

  AlreadyPicked

  7 replies

  15 years, 10 months ago

  By: AlreadyPicked

• Diff. Betwwen Sql Server 2005 & 2008.

  Plz. tell me Diff. Between Sql Server 2005 & 2008.

  mandarcoolkarni31

  2 replies

  15 years, 10 months ago

  By: The_SQL_DBA

• -MaxBCPThreads setting (what rule of thumb ?)

  I'm currently setting up various servers which will consist of the following : Publisher (8 CPU 32G…

  ryan.offord

  1 replies

  15 years, 10 months ago

  By: ryan.offord

• SQL Server does not exist when running DTS packages

  Hey all, I'm able to successfully run DTS packages locally and remotely on this specific 2008 envir…

  Adam Bean

  1 replies

  15 years, 10 months ago

  By: Adam Bean