SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• 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

  16 years, 7 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

  16 years, 7 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

  16 years, 7 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

  16 years, 7 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

  16 years, 7 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

  16 years, 7 months ago

  By: AlreadyPicked

• Diff. Betwwen Sql Server 2005 & 2008.

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

  mandarcoolkarni31

  2 replies

  16 years, 7 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

  16 years, 7 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

  16 years, 7 months ago

  By: Adam Bean

• SSRS

  Hi! I'm new to Crystal Reports and SSRS. I am developing an application in VB.Net 2008 with a datab…

  d_m_postolache

  1 replies

  16 years, 7 months ago

  By: Gift Peddie

• SQL Instances

  Hi I have a query: 1. I have 3 instances 1 default and 2 named instances on my machine. I goto the …

  Azzu

  2 replies

  16 years, 7 months ago

  By: Azzu

• Migrating DB to SQL authentication

  Hi, I'm an experienced developer, but new to SQL Database administration. Recently I designed a web…

  Dave H.

  2 replies

  16 years, 7 months ago

  By: muthukkumaran Kaliyamoorthy

• How to switch data online

  Hi SQL experts: My project requires switching data online. We use a regular job to prepare new data…

  xuejianpan

  2 replies

  16 years, 7 months ago

  By: John Rowan

• Identity column limitation

  What is the limit of an identity column defined in sql server?If there is any limit, how can we res…

  sqldba4u

  17 replies

  16 years, 7 months ago

  By: Dugi

• Restricting a backup from restore

  I have a database backup.I want nobody can restore it even if he copies the backup to any location/…

  sqldba4u

  4 replies

  16 years, 7 months ago

  By: The_SQL_DBA