Viewing 15 posts - 1,096 through 1,110 (of 1,179 total)
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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 28, 2008 at 6:00 am
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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 28, 2008 at 5:57 am
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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 28, 2008 at 5:50 am
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/
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 28, 2008 at 4:27 am
see the following link:
http://support.microsoft.com/kb/321185
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 28, 2008 at 4:11 am
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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 28, 2008 at 2:10 am
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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 28, 2008 at 1:56 am
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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 28, 2008 at 1:45 am
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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 22, 2008 at 12:09 am
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).
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 19, 2008 at 5:45 am
Try this...
sp_grantlogin [@loginame =] 'login'
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 19, 2008 at 1:38 am
When you do drop & recreate SP you need to reset the exe permission.
While Alter SP will keep the previlages as it is.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 19, 2008 at 1:20 am
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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 18, 2008 at 7:05 am
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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 18, 2008 at 5:26 am
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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 18, 2008 at 1:48 am
Viewing 15 posts - 1,096 through 1,110 (of 1,179 total)