I've maintained for years that databases are platform-portable in the same way that continental plates are "portable". They do move, and it's usually listed as a disaster by everyone...

Brandie Tarvin (5/30/2012)

---

Are you talking about a Execute...

Doctor Who 2 (5/31/2012)

---

...

No, GSQuared, I haven't tried LinkedIn. I am on it, but tend to spend my time there either interacting with others on questions, answering them, etc....

IceDread (5/31/2012)

---

...

Human nature actually varies a lot depending on culture. That's not to say I don't agree.

Usa has had a different history, very very short history compared to other countries...

sturner (5/30/2012)

---

mtucker-732014 (5/29/2012)

---

I think that of all the things a company can do to attract and keep good employees there is one universal truth - if you dont pay good...

If sa has been removed from the sysadmin role, you need to get with whomever is in charge of security for your database server and work out what login to...

Can't you add an SQL Script task to check for rows to export before you run the file-create step? Worth doing?

Doctor Who 2 (5/29/2012)

---

Interesting editorial, Steve. I'm a little surprised that there isn't more buzz on this topic. I'd like to bring up a little different spin on...

Login sa gets a permission-denied error? Is that correct?

If so, check if sa is still a sysadmin. If it is, then SQL Server is running under permissions at...

Those IsNulls in the Where clause and Join predicates are also going to also kill performance, unless I'm mistaken. Regardless of indexing.

I would definitely move towards a more structured...

Are you familiar with Inline Subqueries?

That will do what you want, in a single set-based query, without a cursor.

I'd need to see the structure of the actual table before I...

I went through a very rough time when I was first learning how to work with SQL Server. Laregely, as you surmised, because you have to know what to...

If your XML will come from SQL Server tables, you can generate typed XSD by querying sys.columns for the SQL Server datatypes and translating to XML data types. Will...

What login are you using to execute it?

You can either use .NET to do that, by creating an Excel object and calling the Save As method, or you can use a data flow from the Excel file...