You have no choice but to remove user database file manually after sql server uninstall.

Does your company also has active directory?  You could query active directory, add the new login for all of your existing login and then write a script to switch them...

You can't tune what you don't know.  Also ask them what is slow, how do you know it is slow, and where is it slow at?  After you found out...

First of all I would tell them that they are not allow to bcp 8 million row into a database at a time.

However they could try to work their code...

DSP, Sushila,

Well that is what we call a balance in life.  I no longer have a taste or willingness to work 10 hr a day 6 days a week (dot...

sushila,

Well those are the other reason that I didn't want to think about...  It is not at your choice to change job.

I am a contractor too but working full time...

I agree with Steve.  I usually asked what is the range or ask the recruiter to find out before even thinking about going to interview. 

Let's face it, the reason most people...

You do have the option to have SQL Server Generate SQL Script, There are a couple of option like, script to drop object, script to add object as well as...

What is the error?

As you should know by now, there is no back out plan.

I hope you backup your system database before you load sp3a.

If you got your system database...

The other way without scripting your job is to stop sql agent and restore msdb database.  Your job will comes with it as well as DTS packages.

Anyway, the way to...

Reboot your PC.  Also make sure to send the attach file that is within the limit of file attachment for your exchange server.

mom

You could do a couple of way.  Backup your database and give it to DBA/sa so they could restore it at your client site.  The reason why is because you...

In some of my server i have 200+ databases on them.

mom

I have never seen auto detach for any database feature.  However I have seen some user set their database to auto close thus sometimes it takes longer time to connect...

Have you though about backup the database to a group of file?  That's how I was able to overcome moving 60 GB backup file accross the network.  Let's say you...