Viewing 15 posts - 16 through 30 (of 79 total)
ron morgan (7/20/2010)
July 20, 2010 at 6:54 pm
Sherri Barkley (7/15/2010)
July 20, 2010 at 5:50 pm
ashaaban (7/20/2010)
My company has 20 Access databases that are connected to sql server 2008 through ODBC. There are about 20 different databases. The problem that I am having is that...
July 20, 2010 at 5:38 pm
[font="Courier New"]In our environment, we have to keep many development efforts/projects at the same time. Some projects are deployed quickly while others are kept for a while and keeping the...
July 20, 2010 at 12:23 pm
[font="Courier New"]
S.K. (7/19/2010)
July 20, 2010 at 8:43 am
tran008 (7/19/2010)
July 19, 2010 at 5:59 pm
Paul,
yep, thats an oversight and will update my earlier post. You could use sys.sp_cdc_change_job to specify the retention time. Jonathan Kehayias also confirmed this.
[ @retention ] =retention
Number of minutes that...
July 17, 2010 at 3:45 pm
[font="Courier New"]
EDIT:
You could use sys.sp_cdc_change_job sp to change the retention using @retention paramter.
[ @retention ] =retention
Number of minutes that change rows are to be retained in change tables. retention is...
July 17, 2010 at 10:20 am
Simple answer is, you may have to rebuild the clustered index on this table until then space won't be released. I have some sample code and some DBCC PAGE commands...
July 17, 2010 at 2:02 am
angiepimentel 1403 (7/15/2010)
...
July 15, 2010 at 12:25 pm
beppe_30 (6/21/2010)
We would like to use Maintenance Plan to backup our databases but we also want to use...
July 14, 2010 at 11:15 pm
BigSam (6/19/2010)
July 14, 2010 at 11:03 pm
honey47 (7/9/2010)
i m currently running database server 2008 , but due to some reason i want to switch to sql 2005. but i am enable to restore my date...
July 14, 2010 at 10:34 pm
Viewing 15 posts - 16 through 30 (of 79 total)