You can change the job name in the below query and execute it to get the job history.

EXEC msdb.dbo.sp_help_jobhistory @job_name='Your Jobname'

You can provide the user db_datawriter role to have the write privilege on user tables, for sp execution im not sure whether this works.

Exec dbname.dbo.sp_addrolemember @rolename ='db_datawriter',

@membername ='Username'

You can also...

[font="Verdana"]Maricus,

This is a know problem with SQL Server 2000. Refer the below KB article for workaround.

http://support.microsoft.com/kb/312995[/font]

[font="Verdana"]You can use this sp_change_users_login procedure itself to map the user with the login. [/font]

[font="Verdana"]

GilaMonster (7/20/2008)

You can read the system tables if you connect with the DAC. Updating them is still...

[font="Verdana"]Check out the below KB article to create an alias for the destination server.

http://msdn.microsoft.com/en-us/library/ms190445.aspx[/font]

[font="Verdana"]Stored procedures are stored in user databases and hence once you attached the db you will get all the sp's.

For DTS, SQL Server stores these packages in MSDB database and...

[font="Verdana"]Checkout the link below and try the steps for standard edition too.

Upgrading SQL2005 Evaluation to Enterprise Edition Without Uninstalling[/font]

[font="Verdana"]If you could provide some sample data's & exact table schema, it will be helpful.[/font]

Check out the link below

http://msdn.microsoft.com/en-us/library/ms190176.aspx

[font="Verdana"]In SQL Server 2005 you won't be able to update system tables directly. (You can update the tables if you connect to server as DAC)

Since you are not interested in...

[font="Verdana"]Try creating an alias in the source server to point destination server with correct port and then try creating the linked server.[/font]

[font="Verdana"]When you try to take the backup of 50GB db on network share the time taken will be high and if a network glitch happens then the backup will get...

[font="Verdana"]Does the secondary server's SQL Service account have necessary privilege on the share?

What is the error message it is throwing in the job history?

In which mode do you configured log...

[font="Verdana"]Why can you try the below procedures in msdb Database.

sp_help_job (Transact-SQL)

sp_help_jobactivity (Transact-SQL)

sp_help_jobhistory (Transact-SQL)[/font]