SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Altering settings on Surface Area Configuration generates this error: Alter failed. (Microsoft.SqlServer.Smo)

  Hi, Brand new sql2005 64bit installation on windows server 2003 64bit edition, SP2. When I go the S…

  sql-lover

  1 replies

  15 years, 7 months ago

  By: sql_lock

• Dynamic SQL Statement - Problem with Syntax

  Can anyone tell me where my syntax is wrong in this statement: Set@sqlP =' UpdateIARTS..…

  andegre

  3 replies

  15 years, 7 months ago

  By: andegre

• remotely not able to connect sql server

  I tried to enable but Tcp\IP is not getting enabled. Even though i am trying to enabling Tcp\IP in …

  amarnath_sk

  7 replies

  15 years, 7 months ago

  By: amarnath_sk

• End-user Query Builder Tool?

  I realize this is only "loosely" related to SQL Server (and I'll be cross-posting to an Excel forum…

  Chris W

  5 replies

  15 years, 7 months ago

  By: Jamie Ingram-729524

• OUTPUT parameter not returning Why?

  I'm using the following SP CREATE PROCEDURE Category_GetCategoryPos ( @idCategory INT, @links BIT…

  support 6762

  10 replies

  15 years, 7 months ago

  By: support 6762

• Retrieve total rows over paging

  Hi everybody, When I use ROW_NUMBER for making paging I would like to have also the total of rows t…

  Daniele Franceschini

  1 replies

  15 years, 7 months ago

  By: Nabha

• How to configure E-mail alerts for a backup plan

  Hello everyone, Version : SQL Server 2005/2008 I have backup maintenance plan,Now i want configure …

  ram_reddyprasad

  1 replies

  15 years, 7 months ago

  By: jshailendra

• Disk system configuration

  Hi I've recently moved company and have inherited a number of servers running SQL Server 2005 stand…

  NickDBA

  1 replies

  15 years, 7 months ago

  By: CyclingRabbit

• Replication: Count undistributed transactions

  Hi There. Does anybody know how I can create a script that will tell me if there is a large ba…

  GArry-379827

  4 replies

  15 years, 7 months ago

  By: richardn-1128243

• Scripting options for Stored Procedures

  I cannot seem to be able to generate the "IF EXISTS" portion of the DROP statement for Stored Proce…

  carolyn v mckechnie

  6 replies

  15 years, 7 months ago

  By: Chenman

• Lightweight Pooling Mode

  Does SQL Server ever force Lightweight Pooling Mode on? I've seen LPM cause a few problems with SQL…

  Craig -230742

  3 replies

  15 years, 7 months ago

  By: Gail Shaw

• Generating dummy test data - Test Data Generator

  Hello, I am trying to generate test data (small set) for our databases. What is an easy way to do s…

  krithik_e

  1 replies

  15 years, 7 months ago

  By: Luke L

• SSIS problems with cloned machine

  I have an interesting (see: frustrating) problem and was wondering if anyone had any ideas on how t…

  mwalbert

  4 replies

  15 years, 7 months ago

  By: mwalbert

• Error 9002 transaction log for database "abc" is full

  Hello Everyone, I am getting one error Error 9002 transaction log for database "abc" is full.To f…

  ram_reddyprasad

  6 replies

  15 years, 7 months ago

  By: jshailendra

• Hardware upgrade question.

  Not sure where to place this question, so I hope that I have this in the correct forum. I am upg…

  jamie.tobin

  1 replies

  15 years, 7 months ago

  By: David Perez V