wats the error u getting??

Second to JOhn..

While scripting out make sure to change the script compatability to 2008..That will make ur job much easier

Which edition u r using??

take a log backup again and then issue the shrinkfile

Thanks alot Gail..

Is it possible to restore the same database with a backup of all filegroup and then later with a backup of only one file group taken before the...

No errors...The option cant be used in SSMS its greyed out

Which authentication u used between two servers??

In server showing green u will be having the permission to start and stop the services but not in other server.

Normally changing the machine name running the procedure to drop and create the server will work ..

U changed the physical machine or server name??

CirquedeSQLeil (8/16/2010)

---

Is it required that the procedure be done via loop?

Could you bulk load the data into some staging tables in SQL server instead and then perform your operations entirely...

jeff.mason (7/19/2010)

---

And I would also try to run that procedure to get the execution plan as well, as it will show you where it's working the hardest. If dev...

YES..

Please find the code below

ALTER PROCEDURE [dbo].[usp_RUN_PRODUCTION_LINE]

-- Add...

As Steve mentioned you need to change the machine name

or

Create an alias with ur desired name but using this still wont change the exact name of server.

or u can use

SELECT * FROM SYSFILES

Hope This might help

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