When you look at the services and see the "Log On As", you can check if this is from Local System or any specific domin login id.

How do you...

For logins,

you can use DTS package to move/copy logins to new server or you can follow this http://support.microsoft.com/default.aspx?kbid=246133

DTS package is easy, open the package and save as new server...

For logins,

you can use DTS package to move/copy logins to new server or you can follow this http://support.microsoft.com/default.aspx?kbid=246133

DTS package is easy, open the package and save as new server...

For logins,

you can use DTS package to move/copy logins to new server or you can follow this http://support.microsoft.com/default.aspx?kbid=246133

DTS package is easy, open the package and save as new server...

From the job, you can just run and send output to a text file like mccork said and then using xp_sendmail or any other SQL Mail that use to send...

Insufficient memeory is sometimes very hard to troubleshooting. You might have a job, trigger or something that uses cursor that you might forget to deallocate or something...

Also you might want...

I'd recommend to use Log Shipping to move database. I fliped to new sql server (over 20 databases (< 300G)) in 1 minitues. 

This site has a lot of information...

That leads to another question. If that s/w forces to do the install directly on SQL Server machine, is it going to work for cluster? As you know, cluster is...

Just curious, why do you want to install .net framework on SQL server? Assuming that you are using SQL2K.

Hi Chad, Guess who I am

Before I go over both methods about pro and con, I have to say, I don't have good...

Most likly, it won't print out as it goes. Don't know why but, it stack up and print out chunk messages as time goes. If anyone knows a way, I'd...

that is what I usually do. Process X amount of data first and find what is the best size to process at once.

Also I sometimes use index defrag every 100...

I agree with Allen.

Even though it was okay one day the potential problem was still there but didn't go over the bottelneck so you didn't see and sql eventually update the...

This is something that I use for getting email format. It is not pure SQL but I found it RegEx is easier to check email format so I just did it that way. Once...

It does sounds like dll version mismatch. I think reinstalling MDAC is worth to shot also looks like you have Service Pack 3 so might want to apply Service Pack...