Viewing 15 posts - 61 through 75 (of 84 total)
Thank you Leach....
but both softwares having a common issue..
i.e., "no support for creating user-defined filegroups.. they create only Primary and Log Files.."
I found...
December 13, 2006 at 9:56 pm
The connection loss between the publisher and the subscriber causes this problem frequently...
there is an option in the Publication Properties dialog box
Subscriptions Never Expire
better check this...
December 12, 2006 at 10:17 pm
Thank you Dinesh
The tool is better working with Schemas ,but If try to include data too in the package its taking lot of...
December 12, 2006 at 10:10 pm
You have the schedule option in
Update DataOptimization Information Step
which performs the ReIndexing at specified schedule time
With This you can set the schedule when to ReIndexing which causes Transaction Log...
December 11, 2006 at 9:17 pm
you can move the tables from one filegroup to other using Enterprise Manager
->RightClick on Table
->goto design table
->right click on any feild
->goto properties
-> change Table FileGropup
->close
you can even get the...
December 11, 2006 at 8:48 pm
try to execute the procedure from user login who created the table.. simply
exec sp_changeobjectowner '<TableName>,'dbo'
or else try to change the owner using EnterPrisemanager
RightClick on Table ->goto design table->right click on any...
December 11, 2006 at 8:42 pm
yes.. once we restore the database we cannot restore any logs unless we use WITH STANDBY option in RESTORE statement
or
we specify the "Leave database readonly and able to restre...
December 6, 2006 at 12:16 am
yes... because of it is being a Production database we haven't have any profiler running...
December 5, 2006 at 7:18 am
I am about the physical size only...
do not know why there was an increase or decrease in the physical size....
December 5, 2006 at 6:42 am
haiii.. I have similar issue like when I tried to start my SQL Server Agent it is getting stopped with the below error message in event log
"
SQLServerAgent could not be started...
December 5, 2006 at 12:52 am
Thank you Uddin..
I have one more issue plzzzzzz.....
one day our transaction Log size(physical size) grown to 2GB and a day after when I see...
December 5, 2006 at 12:46 am
The below resources might be useful..
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/rdbmspft.mspx
http://www.databasejournal.com/features/mssql/article.php/1439801
December 4, 2006 at 5:03 am
Viewing 15 posts - 61 through 75 (of 84 total)