Yes, yes I was. But I love Chocolate Mousse!

GSquared (3/16/2012)

---

Lynn Pettis (3/16/2012)

---

I think I'll go join the Guard Hippo at my Tent in the Desert. I really must be getting grumpy in my old age (no offense...

anthony.green (3/16/2012)

---

think we need to change the word now, as all this talk about fish and tartar sauce is making me want fish and chips for my evening meal, which...

Tarter Sauce

Jeff Moden (3/16/2012)

---

capn.hector (3/16/2012)

---

Jeff,

Depending on the application would using the created on date for the first modified date be better than some future date?

so in the above query it would...

hermit

I think I'll go join the Guard Hippo at my Tent in the Desert. I really must be getting grumpy in my old age (no offense to those older...

Is the join between the two result sets on CODE and NAME?

In general, I would not append backups together. If a file with multiple backups (full, differential, t-log) were to become corrupt, you lose all the backups in that file....

Start with Books Online, look at either the INFORMATION_SCHEMA views or the system views: sys.tables, sys.indexes, sys.index_columns.

After that, if you have questions come back and ask.

Sean Lange (3/16/2012)

---

Lynn Pettis (3/16/2012)

---

Sean Lange (3/16/2012)

---

I would recommend skipping the local installation and just the online version. There are frequent updates to the online version, your local installed version...

This is...

Sean Lange (3/16/2012)

---

I would recommend skipping the local installation and just the online version. There are frequent updates to the online version, your local installed version will not have those...

Maybe. If I were teaching a class on T-SQL/MS SQL Server I would give any solution...

Modify your connection string to include both the principal and mirror servers. You can start here for for help:

http://msdn.microsoft.com/en-us/library/ms366348.aspx