Short answer is that I don't believe SQL provides this functionality, just like it didn't in SQL Mail..

Unfortunately the only *I* know how to take care of this requires some...

Ok, in SSIS the closest thing to global variables is variables defined at the package level, you can tell by looking at the variable list, and if the column Scope...

I completely understand the point but I would go...

rsteckly (11/17/2009)

---

I have a number of questions.

1. Are you using the Excel Source?

Yes, although I've tried converting the data to csv format and importing it using the flat file connector....

totaltech (11/19/2009)

---

Please, find the answers of your questions as below:

1. Do you want to capture pre and post values of an updated record? Ans : Pre

2. What information about the...

Ed,

I like your response. good advice.

CEWII

Rambler (11/19/2009)

---

Thanks Elliott, I'll try out your suggestion.

It's a big deal, because the database names can contain VAT ID numbers of companies or their names and since multiple clients "coexist"...

lokkers (11/19/2009)

---

Or the developers could implement a service-hosted data access layer, meaning that all connections to SQL Server come through one account. 1 user == 1 CAL, irrespective of...

What a scary concept, giving visibility into how many distinct users are actually connecting.. My god, you might license near the correct number and not over pay..

I...

I didn't see anything about the pre-work needed..

Have you run the SQL Server Upgrade Assistant against the server to see what it points out?

Are you aware of any code that...

I have to agree with happycat59. There is not ANY circumstance where I would restore an msdb from an previous version, that is just asking for major issues.

CEWII

Jack is exactly right that is the best way.

You can also use DDL triggers to catch and stop it, but you really need to control access.

CEWII

1. At first glance it looks like hinky SMO created code, without seeing exactly how it was executed against the database I can't be sure.

2. I saw sp_settriggerorder and I...

Realistically you can't create it directly, you have to go at it a little more round-about way.

Within your sproc you could add a statement like:

EXEC ('CREATE TRIGGER trTriggerName ON dbo.SomeTable...

David Portas (11/18/2009)

---

Leaving aside the well-known disadvantages of procedural code, a trigger is not a substitute for a constraint because it does not enforce the rule. It allows the data...