Hi,

May be you can try the following:

--> Start SQL service with trace flag -T3608 (which prevents SQL server from automatically starting and reovering any database except Master database).

--> Rebuild MSDB...

Hi,

Using Select into option, the indexes and constraints are ignored. Generate the script of the table by selecting options to include constraints, indexes (right click on tables--> all tasks--> Generate...

Hi,

Right click on Maintenance plan and select Maintenance Plan History. You may get more details there....

Hi,

If it is 2005, if you go to the section "Logging" while creating maintenance plan, there is an option "Generate text file report". You can specify a path where this...

Hi,

Check this reference guide:

http://www.microsoft.com/downloads/details.aspx?familyid=3D5E96D9-0074-46C4-BD4F-C3EB2ABF4B66&displaylang=en#QuickInfoContainer

Hi,

Leading from one task to another, there are arrows (workflow). Blue indicates "On Completion"; Green indicate "On Success" and Red indicates "On Failure". If we doubleclick to open the workflow,...

Hi,

Which method are you following to load files to DB. If you are using DTS, you may try "On Completion" workflow instead of "On Success".

There is no impact.

we have rebuilt MSDB from regular service pack files (English) on German Built SQL instance and there are no issues found.

Hi,

The logshipping failures can be administered by the alerts set up while configuring Logshipping.

There are few tables which can be queried for details like, whats the last transaction log file...

Hi,

Check if this is of some help:

DECLARE @test_str varchar(255)

DECLARE @dbname varchar(50)

SET @test_str = 'use ' + '['+@dbname+']' +

...

Hi,

I think here you can use DTS (Copy SQL server objects task). There is an option either to drop the objects before, or to append data etc.,...

Hi,

If RAW file means any csv file, you can use DTS/SSIS by taling the table as source object and the text file as destination.

Hi,

Are the tables in destination database empty? It seems the table APADR already contains some data and the export wizard is trying to insert the same data and this might...

Hi,

May be you can try this:

sp_MSforeachdb sp_helpuser --for database wise user info

sp_MSforeachdb sp_helprole --for database wise roles info

Hi,

When you open the package, there is an option to schedule it. Below the options to choose a name, description; the schedule can also be configured which creates a job...