Viewing 15 posts - 16 through 30 (of 1,654 total)
The core.source_info_internal gets the days_until_expiration value is set by the collection sets. 730 days is the default for the disk_usage collection and usually this isn't causing too much growth.
In...
September 30, 2013 at 5:47 am
Like the others said before it can be quite a challenge but it start with the SSMA for Oracle
September 28, 2013 at 1:46 am
:w00t: That doesn't look good.
Your backup file is definetly not ok. Could it be that the backup was taken on a different version of SQL Server than your own...
September 27, 2013 at 5:48 am
How to troubleshoot the "Cannot generate SSPI context" error message
September 27, 2013 at 5:27 am
First of all why do you want to rename MSDTC?
Next question would be how is MSDTC configured on your cluster? Which OS are you using?
With Win2003 you need to create...
September 27, 2013 at 5:22 am
You can use the cdc.lsn_time_mapping table to convert LSN to transaction time. If you then transfer only cdc records which changed during a fixed period, like the last day, this...
September 26, 2013 at 8:48 am
I assume I'd just pop the SQL Server 2012 disc in one of the nodes and install a new SQL Server Cluster instance and then go around to the...
September 26, 2013 at 8:37 am
I did a similar thing some time ago and while I don't have all the scripts available right now, just let me explain my approach.
First I created a table to...
September 25, 2013 at 2:06 am
Deleting records on a where condition is a the simplest example, but some select queries exhibit this behaviour too, for part of their runtime.
What kind of behaviour are you...
September 24, 2013 at 3:41 am
Simply create a new SSIS 2012 project and right click on packages and add your existing packages one at a time.
That should do the job.
September 20, 2013 at 3:51 am
You can do this by creating a data-driven subscription.
Under delivery options you can use a value from your reports resultset to create a dynamic filename.
But be aware dat-driven subscriptions...
September 20, 2013 at 3:43 am
Oh, yes one more comment:
DON'T use DBCC SHRINKFILE in a maintenance plan. It's a very bad practice.
September 18, 2013 at 6:38 am
The script you inherited from SQL 2000 is from a SQL Server maintenance plan. From SQL 2005 onward SQL maintenance plans use SSIS packages instead of xp_sqlMaint.
So instead of...
September 18, 2013 at 6:33 am
You really don't give us a lot of information, but I assume you're looking for sp_updatejob
http://msdn.microsoft.com/en-us/library/ms188745(v=sql.105).aspx
September 18, 2013 at 6:26 am
Viewing 15 posts - 16 through 30 (of 1,654 total)