Then, after a quick "conversation" with Gail, and not knowing what errors occurred to put the databases in suspect mode, he recommends putting them in Emergency mode then extract the...

lmu92 (2/16/2010)

---

Lynn Pettis (2/16/2010)

---

Easy, the cause is the following lines:

SET @Jun30Date = CAST('06/30/' + cast(year(@Report_From) as varchar(4)) as datetime)

...

RBarryYoung (2/16/2010)

---

Just knowing that I am helping someone is what makes it all worthwhile.

(if that doesn't make sense, then note closely the dates & times in the thread above, and...

Okay, Gail is in rare form here. Or should I say, I'm glad I'm not the one who is on her bad side today.

How about a different rant. Don't you get tired of answers that really don't help?

Such as this one and this one.

Servers are not principal, databases are. Database Mirroring is at the DATABASE level,...

NEI, Not Enough Information.

Have you checked the SQL Server logs for errors? If so, what errors were reported?

As many times as we have run into questions asked in the wrong forum, I did ask the OP which he is working with, SQL Server 7/2000 or SQL Server...

Easy, the cause is the following lines:

SET @Jun30Date = CAST('06/30/' + cast(year(@Report_From) as varchar(4)) as datetime)

...

varma1412-1092791 (2/15/2010)

---

Hi,

It would be great if someone can help me out.

I have a table which has a column with list of Instances in it. By calling this table I have...

Elliott W (2/16/2010)

---

I completely understand, because of the title I never looked at the group it was in.. But I stand by my recommend and the link posted.. ...

SuzDBA (2/16/2010)

---

For this post let's assume I have 2 servers: Server A and Server B

Server A will have 3 Databases: DB1, DB2, DB3

Server B will have 3 Databases:...

Lynn Pettis (2/16/2010)

---

Elliott W (2/16/2010)

---

I just needed to vent a little bit..

I see that it was in the 7, 2000 group but the title is:

Dynamic Connection TO DIFFERENT...

We have our SSIS packages setup to use dynamic connections. Works great and is easy to do in SSIS. In fact, I think it is easier is SSIS...

Elliott W (2/16/2010)

---

I just needed to vent a little bit..

I see that it was in the 7, 2000 group but the title is:

Dynamic Connection TO DIFFERENT INSTANCES in...