Is this hard requirement targeting a specific tool that your management/organization already is looking...

Wow, I guess I did not really think about the 64-bit version came out...

Considering that Powershell is Microsoft scripting platform of choice for administration going forward. I would not recommend it. Plus, as it has already been said, some products will not work...

Try this:

Get-Service | Where-Object {$_.name -eq "mssqlserver"} | Where-Object {$_.status -eq "Running"} | Stop-Service -force

Forgive me if I am incorrect, but I believe that log shipping can only be done between MS SQL servers. You may be better looking something like scheduled SSIS jobs.

I apologize for the off-topic questions, but your environment is "interesting":

- You seem to have a lot of iron for a dedicated SQL box (definitely a good thing!). Why go...

halifaxdal,

I don't think that Lutz was trying to give you any attitude at all. I think he was simply trying to identify what you have already done in...

A quick serch in MSDN brought this back:

Guide to Migrating from MySQL to SQL Server 2005

I agree with what Lowell says. If your source is from a non-Windows machine, other OSes tend to use different end of line characters other than CRLF, such as just...

Sounds strange. Is it possible that your security team is doing more than just locking the local admin account out? Such as changing the impersonation level in group policy?

Are there any errors reported in the setup logs?

Monday, December 22, 2008 11:40 AM arvindsh

SQL Server setup log locations and more

Have you checked that TCP/IP is enabled on the SQL 2000 instance and that it is using a different port number than the 2008 instance? I thought that by default...

Well, I know that in my environment we only restart mission essential SQL instances either during unplanned outages to fix something completely broken or during approved downtimes for maintenance. In...

I think that depends on your different database/application needs and how much memory is installed on the server. How much is configured for SQL right now? How much memory do...

What does the history of the maintenance plan say?