You don't say if your readdressing was because of a domain change or not. If you changed domains, you should check the accounts that the SQL Server services start as,...

Your customer has a big problem. He doesn't have a valid backup of the database. There are only two ways to backup a SQL Server database....

1. Open files (SQL Server...

Concerning the three different executables.

You need to install the database components at a minimum.

Do you run Analysis Services? If not, then you don't need that.

Do you have MSDE on any...

First, I use http://www.sqlsecurity.com to check the latest available versions. On the menu bar select FAQs/DOCs and then choose the SQL Server Version Database.

If it says YES in the...

Always try to help others out when you find an answer. Either post the answer or post the link to the answer.

Thanks

-SQLBill

How often are you going to need to do this conversion? If it's not often, do the conversions suggested. If you are going to do it often, there's the possibility...

Diego,

Please do not double post.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=134873

-SQLBill

Diego,

Please do not double post.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=134874

-SQLBill

Found the facts for you.

http://www.microsoft.com/sql/evaluation/overview/default.asp

Scroll down to the Overview for Personal Edition and look at Purchasing and Licensing. You will see this:

Not available separately.

Personal Edition is included with:...

I've never heard of that. Personal Edition comes as an extra with the purchased versions. You can download MSDE (Desktop Edition).

-SQLBill

Can you post the SP?

How are you running the SP? Via a job?

Are there any error messages in SQL Server Error Log or the Windows Event Viewer Logs?

-SQLBill

This is a string: '2004/08/01'

This is a datetime value: @param1 datetime

They are NOT the same thing, even if you enter 2004/08/01 for the parameter.

The difference is that datetime value...

Basically it sounds like a timing issue.

You are running two programs that use the same database. But the first one drops the database and rebuilds it. It looks like the...

Create a job. (Enterprise Manager, expand down to Management. Expand SQL Server Agent. Right click on Jobs. Select New Job).

I backup all my databases at "one time" (it's actually one...

Martin,

The original poster said the database was set to SIMPLE mode. In this mode you can't backup the transaction log - so you can't use it for a restore. The...