Just to add to your intake of knowledge for the day shark, you may find these resources useful, if you don't have them already:

http://support.microsoft.com/kb/929491

http://blogs.msdn.com/jimmymay/archive/2008/12/04/disk-partition-alignment-sector-alignment-for-sql-server-part-4-essentials-cheat-sheet.aspx

Shark Energy (3/9/2010)

---

Trying to get my head around a couple, as I can imagine they are both risky.

We have Server A. It is a RAID 1+0. It contains 4 disks...

Dean Jones-454305 (3/9/2010)

---

Depending on certain factors and also how your infrastructure is setup. You have options.

You can use backup/restore to refresh the data.

You can use SQL replication.

You can use SQL...

I agree with Lynn, I think you have used your own domain account as the account running the SQL Service.

As Lynn said chaning the password in Configuration Manager and...

And another vote for Redgate's SQL compare.

Regarding question 3, you can create and start Server Side trace, have a look in BOL about creating them but you can use profiler to generate a script that can...

A friend and former colleague of mine wrote a review of Quest and Idera's products, it is a few years old now and you find his review here

http://www.gre-sqlserver-solutions.com/MonitoringTools.html

Personally, I...

You could create an alias?

Is it a named instance or the default instance.

If its a named instance, and its the instance name you want to change then i think you...

Something like the following would give the user SCTest SELECT permissions on a schema called 'UserSch' to the user SCTest. The second statement grants the user create view permissions.

GRANT SELECT...

Just to add to what George, said sp_help_revlogin is not included in SQL Server by default. This link may help you:

http://support.microsoft.com/kb/246133

murthykalyani has hit the nail on the head, this is what I was trying to across in my previous post.

Think this maybe a double post

Has this job ever succeeded?

That not an ideal setup for a production database server.

How would you cope if the one disk that houses your data, or OS fails, there are many articles out there...

Then you need some more, if you are trying to move a database to a different domain, on a different server then the server needs to have a enough space...