You need to install msde2000a from the Run prompt using the switch SAPWD=YourPassword (using a strong password).

I not sure you can do backups with just msde2000a loaded.

I was able to duplicate that behavior in the QA by selecting Tools->Options->Connections and putting a check in the option Use Regional settings...

Everything back to normal after clearing...

You might want to check out this thread:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=181747&p=4

It starts on a different subject but ends with a debate about the necessity of the Order By clause.

In spite of what that article states it is not a good practice.

From Books Online:

ORDER BY order_list [ ASC | DESC ]

The ORDER BY clause defines the order...

You might want to look in books online for SET IDENTITY_INSERT.

This looks like it may allow you to "trick" the system by saving the last identity...

I have to agree with kenneth.  I really feel that whatever it is you are trying to do probably needs to be restructured so as to have a seemingly more...

This should work:

Declare @temp table (col_a char)

begin tran

insert into table1 values ('a')

insert into @temp values ('b') (no rollback)

rollback

insert into table2

select col_a from @temp

The table...

No. But I did and gave you credit

This seems to do the trick.

select convert(char(07),getdate(),120)

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

2005-05

Nice to get some feedback.  Just in case you were interested

select @csv = isnull(@csv + ', ', '') + prs_name

will eliminate the need for

SET @Lecturers = RIGHT(@Lecturers,...

Try creating a udf from the sample code below and use the returned list as your Lecturers column:

declare @csv varchar(1000)

select @csv = isnull(@csv + ', ', '') + prs_name

from Your_table

Where...

If you go with my suggestion above,

...And Not Exists (select oldsds_id from employee where oldsds_id = e.oldsds And oldsds_id is not null and date_left>=getdate())

It looks like you can...

Changing the NOT IN to NOT Exists should help.

...AND not sds_id in (select oldsds_id from employee where oldsds_id is not null and date_left>=getdate())

Should be:

...And Not Exists (select oldsds_id from...

Does this work?

SELECT     LDR.LoanNumber

              ,LDR.StatusCode

              ,LDR.StatusCodeDate 

              ,LDH.Item

FROM       viewLoanDatatotalRetail AS LDR

INNER JOIN tblLoanDataLockHist AS LDH ON LDH.LoanNumber = LDR.LoanNumber

WHERE LDH.Item =

    (SELECT MIN(LDH.Item)

     FROM tblLoanDataLockHist LDH

     Join...

In all fairness to Mark he got it right!  He's solution works for the question you originally stated.