As Steve mentioned creating clustered index on the new filegroup will move the data(with clustered index) but not the non clustered index.

You need to move non clustered indexes seprate using...

How you doing it? What edition and version of sql 2005 you are using?

Are you following bol instructions..

http://msdn2.microsoft.com/en-us/library/ms188670.aspx

You need to change your service account if you are using the domain account other than I don't think you need to anything...

I think your server is not in cluster......

Sorry!

I misread your procedure name... I thought you are using sp_stop_job...

You are using sp_delete_job which deletes the job from the system.

When you are in EM and selected that job you...

Try the following...

1. Create a new db with the same name and and same .mdf and .ldf filenames as detached db.

2. Stop the sql service

3. Rename the .mdf and .ldf...

what ever the commands in step 1 and step2... it will not rollback..

Three ways you can do...

1. Open the Publication property click on snapshot tap... at the bottom you see option called additional scripts before/After you can add your add script file...

This is just guess, I am not sure it works or not!!

You can create a excel template first with required formatting...then

copy the template to the output excel file location...

Susan,

Shrink command will not truncate log, only free up allocated free space to OS.

In 2005 there is no more dts packages? they are called ssis packages...

Are you on 2000 or 2005?

In 2005 to open the dts package You have to install add-ins...

You can use the backups but it depends on the db size...How much space and time and it requires to restore...and also depend of backup retention on disk as well...

How to uninstall an instance of SQL Server 2005 manually

http://support.microsoft.com/default.aspx/kb/909967

SQL Server 2005 Books Online 

How you are trying to connect? via linked server call?

You should explore table partitioning..

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sql2k5partition.asp

1) having DDL code in the sp needs special permissions?

Yes...Depends on what the user is doing generally dbo permissions should be OK but becareful before granting...

2) is there an other...