At my previous employer we used a script task to set the connection dynamically in our SSIS packages after using a SQL task to query a configuration table. We...

I have a blog, started it as way to help the community. I find that I don't blog as much as I would like, and hope to change that,...

Heck, Add me in celebration of my going to my FIRST Bronco game on August 29th!

And what did you find in the maintenance plan?

If this message is showng up daily in the logs, it means the database is being backed up successfully. Not sure...

Unfortunately we can't see what you see, so can't help you.

Can you provide us with the error message you are receiving? It may also help if you could provide...

Just registered for SQLSat52. Sorry, couldn't pay for lunch, will have to fend for myself.

So who all is going to be there?

CirquedeSQLeil (8/13/2010)

---

Nothing like coming in to work to find out that the server team deployed patches to production boxes, caused an outage, didn't communicate that fact, and did not follow...

Not "real" football, American Football.

Guess where I'll be on August 29th? At my...

After reading all the posts I'm back to what I had said earlier, add a login for the Service Account that SQL Server is running under then grant CONNECT permissions...

As I told you in another thread asking the same question, at a previous employer I had the grant CONNECT permissions to the service account running SQL Server to the...

Ninja's_RGR'us (8/12/2010)

---

Lynn Pettis (8/12/2010)

---

CELKO (8/12/2010)

---

tymberwyld (11/10/2008)

---

Along with a lot of other horrible decisions, I am now not allowed to use Negative numbers in any database design. Instead, I need...

CELKO (8/12/2010)

---

tymberwyld (11/10/2008)

---

Along with a lot of other horrible decisions, I am now not allowed to use Negative numbers in any database design. Instead, I need to add another...

Jack Corbett (8/12/2010)

---

jcrawf02 (8/12/2010)

---

Jack Corbett (8/12/2010)

---

My kids start school today. I can't believe how early school starts in FL. We are starting earlier than most other schools, but...

Jack Corbett (8/12/2010)

---

My kids start school today. I can't believe how early school starts in FL. We are starting earlier than most other schools, but still, it is...

When I was setting DB Mirroring at my previous employer, I ran into the same problem. I had to grant CONNECT permissions to the service account running SQL Server...