On the mirror database you don't need to backup the transaction log.

You can only back up the transaction log on the principal database.

If the roles switch, the rule is the...

If your question is "Does a backup script have an execution plan?", then I don't believe so. This is just by select "show execution plan" button from the menu and...

declare @sql varchar(2000)

set @sql = 'select firstName' + ' + ' + 'lastName ' + 'from Person.Contact'

exec (@sql)

that will concatenate fields into one column. I used SQL Server 2008 and...

Select convert(varchar(2),(sum(Datediff(HOUR, clkin, clkout))))+ ':'

+ convert(varchar(2),sum(Datediff(MINUTE, clkin, clkout))) as "Total Hours"

You're trying to add a character ':' to integers.

You have to convert (or cast) the integer results to...

declare @sql nvarchar(2000)

set @sql='select col1,' + ' col2,' + ' col3,' + 'col4 from table'

exec (@sql)

try that. don't forget your commas seperating your fields.

Follow up:

I patched my servers to SP1. It appears that the service pack changes the state back to (mirror,sychronized/restoring...) when you apply sp1.

I had this problem before where I couldn't view the cluster and I couldn't create a cluster on one node because it said it was still part of a cluster....

Z@f (5/5/2010)

---

I know these things are inter related but which one do we create first ?

OR

What is the difference between User, Login , Role and Schema

At which level...

I'll do my best to briefly explain.

Normalized will leave you with 3 tables and no duplicates in any one table.

Create Table ##tName

(FirstName varchar(50),AddressID int)

Create Table ##tAddress

(Street varchar(50),City varchar(50), StateID int,...

So, now knowing how a query is processed internally, how can we use this knowledge to improve query performance or perhaps troubleshooting unexpected results?

I'll give it a shot.

In 2005, the software was installed on all nodes of a cluster simultaneously.

In 2008, you install SQL Server one node at a time in a cluster....