Thanks, yes I did the backup - restore option.

I see after restore the database on the 2008 server, at the database property-options, compatibility level is SQL server 2000(80)

My question is...

Thank you, it is helpful!

Thank you all, I do see the person today, I asked her she wrote it manually.

I thought it is a pain to do that esp.with some parameters.

good to know the...

Thanks, in the query, you use:

SELECT .elAttendanceAreaID, o.msAttendanceAreaID, o.hsAttendanceAreaID

INTERSECT

SELECT .elAttendanceAreaID, n.msAttendanceAreaID, n.hsAttendanceAreaID

Does the first .elAttendanceAreaID, you dropped O, and second...

Thanks, I got to windows computer management, I see a group called SQLServerSQLAgentUser$..

What I see is only one member:

NT SERVICE\SQLSERVERAGENT (S-1-5-80....)

There is no my domain account there.

SQLKnowItAll (2/15/2012)

---

Let's try this explanation... When you use SQL Server Configuration Manager to change the logon for a service, it does not "add" that domain user to SQL Server. It...

SQLKnowItAll (2/15/2012)

---

They are groups. Notice when you look at the icons in SSMS they are not a single person, they are 2. So, a domain account that gets...

EdVassie (2/15/2012)

---

The NT SERVICE\SQLSERVERAGENT and NT SERVICE\MSSQLSERVER entries are what are known as Service SIDs. Google can tell you more about what these are.

To me, it looks like your...

Gianluca Sartori (2/14/2012)

---

Under which account is SQL Server Agent running? Is it [NT SERVICE\SQLSERVERAGENT] or a domain user?

Please run this to discover the service account name.

SELECT servicename, service_account

FROM sys.dm_server_services

WHERE...

Thanks, most of our server are sql 2008, only one is R2,

I tried on R2, it works. but not on sql server 2008, good to know.

Thanks all

So if I do from ssms, I can restore the database first without changing the origial file name, then after the database restored, then I can go to database property,...

Thanks, that makes sense, will do that way.

Thanks, so it can only be done using script, ssms cannot do it, is that right?

Thanks

Thanks, but I got Invalid object name 'sys.dm_server_service'.

CELKO (2/12/2012)

---

Dev (2/12/2012)

---

This is what I said...

I know...