The migration is not very complex. But it depends on your code and your packages and dependencies. Like the TRUNCATE_ONLY option of...

Where is the query?

USE [master]

GO

ALTER DATABASE [DB_NAME] SET SINGLE_USER WITH ROLLBACK IMMEDIATE

GO

ALTER DATABASE [DB_NAME] SET SINGLE_USER

GO

ALTER DATABASE [DB_NAME] SET MULTI_USER

Great article!

Waiting for part2.

I am not sure about why the instance is not coming up in the network configuration option

But, have you enabled both TCP/IP and named pipes for the named instance?

The user under which your SQL server Agent is running might not have permissions on the shared folder. Just check the service credentials

Can you try following.

SQL server 2005 Surface Area Configuration -> change the instance name by using the "change computer" link -> Surface Area Configuration for Services and Connections - >...

Thanks Steve!

No, this is a dev box.

As we are short of hardware, we just wanted to run some test on same server [:)].

Thanks!

That is strange:ermm:

You can try keeping the script in a stored procedure and call the procedure from the job.

I don't think that version will have an impact...

The query seems fine to me. Can you try parsing the script by copy pasting it in SSMS? and see if there...

I don't see any syntactical problem with the script.

Can you script out the job by right click on the job and selecting "Script job as" and post the script?

HI,

Can you post the script of the job?

Thanks Adi!

Time is the problem...its always is:-)

Thanks Gail for the feedback!

The current system is really messed up; apart from the above example there are lot many others.

They also have loops and cursors all over the...