Viewing 15 posts - 751 through 765 (of 1,079 total)
I would not suggest doing it, I may be wrong but I don't see any way of simply copying a maintenance plan...even if you could you look at challenges around...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 22, 2010 at 5:03 am
Schadenfreude-Mei (6/22/2010)
I think this one qualifys:Seriosly, how do these people get to a point where they are even alowed to look at a live server :crazy:
Adam, I don't quite get...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 22, 2010 at 4:50 am
Have to agree with Paul.
ETL for a whole db doesnt really make sense.
Backup and restore would be a good idea.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 22, 2010 at 4:40 am
Check out Brent Ozar's blog...
http://www.brentozar.com/sql/sql-interview-questions/
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 22, 2010 at 3:54 am
Have you tried importing the DTSX packages from one SSIS instance to another?
Ensure you add encryption on them should there be stored passwords etc in them.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 22, 2010 at 3:01 am
Hi Hugo, yes, looking at the last where statement, it was easy to determine the answer.
But, look at the wrong answer rate - 19 so far.
This question was purely to...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 22, 2010 at 2:48 am
Yes, it's called a backup.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 21, 2010 at 11:35 pm
Vijay, how about trying a script posting us your effort, and then we'll see where we can assist.
There was a long thread about people just asking for scripts, instead of...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 21, 2010 at 11:35 pm
start of with creating a table with an ID column, and a column with your server/db names.
use the row ID's to get the server names in each loop, with a...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 20, 2010 at 11:16 pm
Even though your jobs reflect the new name, did you change the run as account as well?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 17, 2010 at 11:55 pm
Fully agree.
Bad formatting is almost as ugly as bad coding. When handing over your code/work you should
feel confident that any developer can look at it and be able...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 17, 2010 at 11:49 pm
Read up at
http://msdn.microsoft.com/en-us/library/ms144275.aspx
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 17, 2010 at 1:06 am
http://www.sqlservercentral.com/Forums/FindPost937448.aspx
please don't post duplicates.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 15, 2010 at 7:14 am
They can sue you, and the company who paid/hired you to steal the information, and prevent the "thieves" from using the information.
They will also ensure you never work at any...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 15, 2010 at 7:04 am
This might not necessarily be the easiest or most correct, but my own thoughts...
script out the "Drop and create" whole database structure, but before creating, change the data type!
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 15, 2010 at 6:58 am
Viewing 15 posts - 751 through 765 (of 1,079 total)