Do not change compatibility level unless and untill you thoroughly test it in your test environment.

Keeping the 2000 compatibility won't hurt anything. But if you will change it to 2005...

Cannot shrink file '2' in database 'Siebel' to 12800 pages as it only contains 10888 pages. i.e. you are trying to shrink 10888 pages to 12800 pages which is not...

Check all your Database services are up and running and Database is accessable.

Try to access the database remotely with the same login application is using.

If it's successful; things to be...

Hope following will help to resolve your issue.

http://www.devprise.com/2007/12/10/sqltrace_buffer_flush-performance-metrics-on-sql-server-2005/

http://www.themssforum.com/SQLServer/SQLTRACEBUFFERFLUSH/

http://sqlblog.com/blogs/linchi_shea/archive/2007/01/16/performance-impact-of-enabling-page-checksum-and-default-trace.aspx

see the following link:

http://support.microsoft.com/kb/321185

Suji,

Try to use max OS Support memory. Refer the following site:

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

Try to alote 3 gb to sql server and rest for the other application on the server and see.

Also check...

If you would like to resolve your issue with Replication here is the solution:

Use Transactional replication to replicate data from

A.T1 to C.TA

B.T1 to C.TB

Create View T1 combining C.TA & C.TB.

For...

It depend on the objects and the indexes on the file too. SQL Server can't split table on the filegroup.

Let SQL Server handle the case. Or else as per...

When we are using Enterprise Manager than by default it's using named pipes. Tcp ip is generally used to connect the application to database as it's Technologically advanced and more...

Check the execution plan for the query. Findout if it's using proper index or not.

Also you can use DTA (Database Engine Tunning Advisor).

Try this...

sp_grantlogin [@loginame =] 'login'

When you do drop & recreate SP you need to reset the exe permission.

While Alter SP will keep the previlages as it is.

First of all check for any open transactions by executing command

DBCC OPENTRAN

Second, while syncronizing database do DML in small chunk i.e. commit transaction frequently.

Third, set Tlog to perform every...

Hello Vincent,

This is pretty interesting and tricky.

After breaking my head for 1 hrs. and practally doing your exercise finally I got the solution for this.

Just execute the following command for...

The probable reason for this might be the update of the table msdb.dbo.sysdbmaintplans do not happne when you restore the database.

When first you have created the maintenance plan it's...