Okay. Before I lead you down the wrong road, Service Broker stopping with that message can also happen due to a number of other causes, from MSDTC going wonky...

LutzM (12/2/2010)

---

In that case, either an IIF statement or REGEX should help. (Google regex or IIF in ssis for details.)

You'd basically use a script component after your data import to...

samartel (12/2/2010)

---

Thanks but not exactly. I need it to happen upon import, before it tries to import the file i need to verify that the format is right. ...

SQLNW (12/2/2010)

---

Thank you Wayne, I am thinking why do we use temp table in the first place? As soon as you see a problem how you decide you need to...

Whoa, who's turning it off?

Implications: You've got an existing database(s) using service broker. These are feeding queues. Either the data on this server is going to become out...

Logging - That orange tree really needs to come down....

You need to do something like this:

SELECT T.Col1, T.Col2, V.Col1, V.Col2, H.Col1, H.Col2

FROM Thundercats.dbo.Characters AS T

JOIN Voltron.dbo.Characters AS V

ON T.Name = V.Name

JOIN HeMan.dbo.Characters AS H

ON V.Name = H.Name

That will remove...

johnzabroski (12/2/2010)

---

Craig,

The next comment (by RLF) in that thread clearly states a Windows Group cannot own a job, which matches the documentation in [1] and [2] referenced above. Then...

Nadrek (12/2/2010)

---

Honestly, I think the #1 takeaway from this thread is:

Name functions with accuracy and specificity!

This is similar to Age calculation functions: Age(birthdate, asofdate) is a bad name for calculating...

johnzabroski (12/2/2010)

---

We do not want every user who manages Agent jobs to have the fixed SQL Server agent role, sysadmin. Giving every user access to SQLAgentUserRole, SQLAgentReaderRole, and SQLAgentOperatorRole...

Okay, the primary issue here is the error that states the instance can't find the target log shipping server, or at the least, doesn't have permissions anymore on the target...

abhijeet.send2me (12/2/2010)

---

Thanks for the reply.

I have the understanding about the logical files. I just wanted to find out if there is a way to increase them or not. or may...

Is this the recipient, or the source, for a logshipped database?

2010-12-01 14:30:30.44*** Error: Failed to connect...

A couple of things to note.

First, what's a Virtual Log file? It's a logical separation of the file internal to it. Read more here:

http://msdn.microsoft.com/en-us/library/aa933049(SQL.80).aspx

And a quick discussion of...

CirquedeSQLeil (12/1/2010)

---

Craig Farrell (12/1/2010)

---

Hey, if anyone's got a disconnected sandbox they can test someone's code in, this person could use some help:

http://www.sqlservercentral.com/Forums/Topic1028937-149-1.aspx?Update=1

I don't have access to anything I can reinstall...