Actually...

You can not restore a SQL Server 2008 backup to a SQL Server 2005 system regardless of the compatibility mode of the database.

If you need to move a database from...

sarvesh singh (7/22/2009)

---

When i do rt click properties on SQL server it says language spanish.

When i run a query :

select * from shifthistory where vfrom='2009-07-23 00:00:00'. i get an error.

...

Not sure what you mean by an external device, but one possible cause could be permissions. A second could be a network error or problem with the network configuration.

Just a guess based on my knowledge of backups and restores only, haven't worked in a logshipping environment yet, but no I don't think you can do that.

Can you provide us with the DDL for the table(s), some sample data (as insert statements), and expected results based on the sample data. From looking at your picture,...

GilaMonster (7/21/2009)

---

Lowell (7/21/2009)

---

maybe one of the articles required registration on another site, so you duplicated the same email for registration for that article? check your cookies or firefoxes saved passwords...see...

Backups are not logged in the transaction log.

JohnSQLServerCentral (7/21/2009)

---

My software development company has under 50 employees. In addition to SQL DBA, I 'also serve as the Domain Administrator. I've been at this for 20...

The problem with @sql's version is that the AND in the WHERE clause should be an OR. Change it and check out the results.

I think its fun. Something different to make one think.

Looking closer at your code, this is in a trigger isn't it.

Why would you want to change from a set-based solution to a cursor-based (row by row) solution?

Your current method is more efficient.

Yes. and you are probably running on a X86 version of the OS as well.

What kind of standby are we talking about?