Then go ahead play with it you can do lot of things with excel 2003 or later.

Amanda what you have understood is correct. You have to remove log shipping to reconfigure it again. Removing logshipping will delete all the entries in the log shipping related tables...

Is your sql services running under doamin account if not you will not be able to access the network resources. If its domain account check both the NTFS and share...

You can use the indentity function in select query but that has been restricted saying that you need to include the into clause too.

No necessarily not but if you like to do miracle with sql 2005 knowing .Net would be a really great boon for you.

This script is for SQL Server 2000.

Use msdb

Create Table #job_listing(

row_num int identity(1,1),

Job_Name varchar(100),

Job_ID varchar(64),

Schedule_Name varchar(100),

Schedule_ID varchar(10),

Enabled varchar(3),

Command varchar(1000),

Description varchar(500)

)

Insert #job_listing (

Job_Name,

Job_ID,

Schedule_Name,

Schedule_ID,

Enabled,

Command,

Description

)

select

a.name,

a.job_id,

b.name,

b.schedule_id,

Case a.enabled when 1 then 'Yes' when 0 then 'No'...

Are you running this DTS as a job then place a log file in the job and track on which step the DTS fails so that you can rectify them...

you have to place the values within quotes i hope you have omitted the quotes inthe quotename command.

Just do a select on the criteria that you are going to update which should fetch the number of rows to be affected.

OS error 5 corresponds to permissions problem in the file and folder. Check for that also check if inhereitence of permission is propagated to the folders below the root folder.

Does your sql server express work only with the system databases. From my preception it will not be working check and let me know.

Windows is more secured and running SQL 2005 on windows 2003 you will have security enhanced more than windows 2000. But there are applications like PeopleSoft taht will run only...

I am having SP2 and tried the same issue persists. After detaching and attaching again the permissions are given only for the user attaching the database and the local administrators...

that xp reads about the registry key details for sql server. May be the password change would have checked if the server has windows authentication or mixed mode in registry...

Any service packs installed after that or still in RTM.