I dont think there is any direct role to add your developers to see jobs.  But in SQL2005 we have this feature.

Thanks-Mubeen Mohammed

First thing is you need to check the Job Owner.  If it is 'sa' then you need to change the job command.  I mean, browse to Job Properties by right...

May be you can check QA -- Tools -- Options -- Connections

Just check that, if anything is different, Click Reset All Button.  But I am not sure whether it works...

Hi Bill,

I am giving you the detail information and  I tested this before submitting in this site.  Better you also test by creating test/temp database and follow the steps and...

Are you talking about Physical Names or Logical filenames. It will not be a problem having 2 databases with same logical file names.

Colin,

Why can't you restore the MSDB database on new server by using -T trace flag.  If you are not sure, then follow the following steps...

Stop the instance on Old Server,...

This question is for Wayne Y, as you said, script out the logins!

I don't know how can you script particular database users? If he is moving (restoring) only one db to...

Congratulations to the founders of this site and also to those people who posted their articles and messages.

This is one of my daily visiting site (part of family).....

You can use sp_addreplcolumn sp_dropreplcolumn you can check in Books online for more information.

Thanks,

Mubeen

Yes, you need to check current server confiugration setting by using sp_configure and apply any changes to new server and then better you re-build indexes and then update statistics.  Also...

Why cant you restore the MSDB database on SQL 2000 and see whether it works.  For detach and attaching MSDB database, you will need to go with seperate process like adding...

My response is in reference to Yelena Varshal, I am not an expert in DTS Packages but I faced the same problem when I changed sa password.  All of my...

Raj,

I would like to add some more next to Yadu Krishna.  By default log file be created C:\PerfLogs and in binary format.  So if you want to have clear information...

Is this you are looking for the first time for performance counters or all of the sudden it disappeared?

If it is not enabled, you need to enable this...

Reloading the SQL...

I believe the replication has stopped for a while and it appears the red cross mark.  It also happens when the publisher disconnects from subscribers for a while (like timeout...