Surely a UNIQUE constraint on the column is the way to go here?

John

There's plenty of information out there. Use your favourite search engine to search for "sargable predicates".

John

Steve, I don't think that's even permitted, certainly not in...

Phil Brammer (3/1/2012)

---

I suspect there are client aliases set up, or the port has not been changed. SSMS will always try to connect to 1433 for default instances unless...

Actually, I need to know exactly what the package does, please. Does it have Execute SQL tasks? Script tasks? Data flows? What does each one do?

John

I can't really think of any cons, provided you're not moving to an inferior disk (smaller, slower or shared with another app). You'll want to use this opportunity to...

Mmmm... that's not too helpful. Try running the proc from the SSMS so that the messages don't get truncated.

You'll find the proc in the EDMDefault database. Expand the...

Yes, you read me right. Sysadmin is sysadmin, and has irrevocable god-like powers on the instance.

John

Krishna

This could be something to do with the package running under a different user when you run it through SQL Server agent, or running from a different computer from when...

Since none of us are looking over your shoulder, please will you post the stored procedure definition and the error message?

Thanks

John

Yes, of course it will - it will mean the databases will be on a different drive from where they started.

Excuse the flippant reply... can you be more specific about...

Not sure I've understood correctly here, but if I have then you're a sysadmin on the instance - I assume you are since you need that, or something close it,...

Devanand

No it won't - provided that the operations performed by your stored procedures are only on the database and not on any drives in the operating system.

John

Phil Brammer (3/1/2012)

---

The SQL Browser service is only for named instances. If you change the default port of the default instance, you will always have to specify the new...

okbangas (3/1/2012)

---

I tend to disagree. Yes slammer hit 1433, but in my humble opinion you do not change port numbers due to security issues. If you do read about slammer,...