Let’s just say that I am jaded by years of seeing this, but my expectation would actually be to get something far worse than what you described:

A database that is...

Is is possible that the server you are having trouble with does not have the Lithuanian collations available?

You said yourself that Windows authentication cannot be used with the login you are trying to use, so I am not sure what you are asking.

Microsoft says that they do support an direct upgrade from 2005 Evaluation Edition to 2005 Enterprise Edition, but recommend uninstalling if you plan to go to Standard, Workgroup,or Developer Edition.

http://www.microsoft.com/sqlserver/2005/en/us/trial-software.aspx

"The...

SQL Server 2000 does not have any built-in ability to do decryption or encryption.

There are some third-pary add on products that might be able to do what you want, or...

Another perspective to remember is that there are other people who may read a thread looking for answers.

I think for the benefit of these people, an answer that they should...

This script gets the file information for every database on a server, and inserts it into temp table that is queried multiple ways to give various levels of analysis of...

This will work for any datetime range.

select

StartDate,

EndDate,

...

One of the causes of corruption is a hardware problem with the disk, and that can cause a problem with any database, even one in read-only mode.

As long as you...

What would you want to see if more than one item for a customer sold for the same max price?

This seems to do the job:

select

JD,

DT = dateadd(dd,(JD%1000)-1,dateadd(yy,JD/1000,0))

from

...

Ronzo (8/27/2009)

---

So, as a follow up, what about a more complex situation:

Clustered default instance of SQL Server with different virtual IP address and network name then the virtual name and...

If you want to recover to a particular point in time (12:00 pm), you will need to add the STOPAT time to your transaction log restores to make sure you...

select FirstDayOfMonth = dateadd(mm,datediff(mm,0,getdate()),0)

Results:

FirstDayOfMonth

-----------------------

2009-08-01 00:00:00.000

You cannot combine files during the restore.