Viewing 15 posts - 1,111 through 1,125 (of 1,179 total)
It is not advisable to use truncate log command on the Tlog replicated database. As in Tlog replication logreader agent is reading data from LOG ONLY!!!.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 18, 2008 at 1:29 am
Try
sp_helplogins
to find the logins previlages.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 18, 2008 at 1:04 am
Refer the following link to understand locks in detail:
http://support.microsoft.com/kb/822101/en-us
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 5, 2008 at 6:21 am
Guest user permission is default for the every user and as the Application Role created for the perticular database is having minimum credential as Guest user.
But here it is...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 5, 2008 at 2:57 am
In any programme 100% accuracy is not possible and there will be some bug. Hence I stongly recommend for Service Pack 3.
Mearly selling product will not help in long tearm;...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 5, 2008 at 2:29 am
Remember one thumb rule; if your query fetches more than 50% than table scan is ideal else use indexes.
Most probably as per database design empid is primary key (to...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 3, 2008 at 2:25 am
Just try following link:
http://www.nyx.net/~bwunder/sql/logSync.htm
Just post your feedback.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 3, 2008 at 1:01 am
Best thing is you can try your query creting cluster Index, Non-cluster index and without using any index.
If we think logically field is having M or F and probably half...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 3, 2008 at 12:52 am
As your database is in full recovery mode; your log file is getting biger and unable to free the space of logfile. For the solution of this questions you need...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 20, 2008 at 4:56 am
Refer the following link:
http://support.microsoft.com/kb/271509
http://support.microsoft.com/kb/832524
http://support.microsoft.com/kb/q169960/
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 19, 2008 at 7:13 am
There are two ways to monitor your logs:
1. While setting up logshipping configure monitor server which will keep all the track of tlog applied or is lacking behind or out...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 19, 2008 at 12:53 am
you can also refer (Scott's quer is part of sp_helpdb)
sp_helpdb
See the status of the database.
I think Scott's query is more close to your requirement.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 19, 2008 at 12:35 am
It is possible.
You have to create package and than use Altiris to deploy the same on the server. If licencing of Altiris is the problem you can run the package...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 19, 2008 at 12:20 am
Subject to your company policy if you are using mixmode security you can assign the 'SA' for the maintenance jobs.
Do not forget to check your company policy; why they have...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 14, 2008 at 6:13 am
DBCC SHRINKFILE
( { file_name | file_id }
{ [ , target_size ]
...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 14, 2008 at 6:05 am
Viewing 15 posts - 1,111 through 1,125 (of 1,179 total)