Search Results | SQL Server Performance Forums

SQL SERVER COLLATION issue

Post by: amahalingam, May 24, 2012 in forum: ALL SQL SERVER QUESTIONS

It is not recommended to change the collation of the database that is in USE. You should have been prudent while creating the database. Given the...

Path of the backups in SQL server 2008, how do I see the path from the SQL server 2008 software

Post by: amahalingam, May 24, 2012 in forum: ALL SQL SERVER QUESTIONS

script below will show you the backups that were taken in the last 24hours and their path. SELECT database_name, backup_start_date,...

Microsoft OLE DB Provider for SQL Server (80004005): Unspecified error

Thread by: amahalingam, Feb 28, 2008, 1 replies, in forum: General Developer Questions

Hi There, I experience a failure in execution of DTS package failing in a DTSExecuteSQLTask, which is used to populate rows in a table. Please find...

Components in SQL Server 2005 Express Edition

Thread by: amahalingam, Feb 22, 2008, 2 replies, in forum: SQL Server 2005 General Developer Questions

Hi there, does Sql Server 2005 Express edition has a separate Server and Client component. To install Sql Server Express edtion on a comp do i need...

Cube Processing Terminating abruptly

Post by: amahalingam, Feb 4, 2008 in forum: SQL Server 2005 Analysis Services

No jobs were running simultaneoulsy. The error message displayed in the query is taken from event viewer.

SQL Server 2005 Analysis Services Operations guide

Post by: amahalingam, Jan 31, 2008 in forum: SQL Server 2005 Analysis Services

thanks a ton satya. Hope to learn a lot from you

Cube Processing Terminating abruptly

Thread by: amahalingam, Jan 31, 2008, 3 replies, in forum: SQL Server 2005 Analysis Services

Hi there, we are using AS2005 server for cube processing. The AS2005 Server has a job that exceutes daily for around 50 mins. In the last two weeks...

Prerequisites/When to run CHECKDB

Thread by: amahalingam, Jan 30, 2008, 1 replies, in forum: General DBA Questions

Hi there, Morning. Being known the significance of running a checkdb as a database maintenance activity, I wish to know when should a checkdb command...