npikes

---

I use DDL triggers on my databases here and they work great.

From what you posted, it sounds like there's something in your trigger that your application does not have permissions...

How about just bringing it all across as character into a temp table and then do your conversions in SQL Server. You can then use the IsDate Function to...

What is being used to do the upload? Where is the source data coming from? Can you post the code or example of the code?

The only way you can find out if the value of a column is used in a child table is to query the child table(s) for the value.

In your example...

I don't know of any way to tell this unless you have a DDL trigger that saves the data.

npikes is probably correct that the application user does not have rights to do something you are doing in your DDL trigger, while when you do it in SSMS you...

jcrawf02 (6/29/2009)

---

GSquared (6/29/2009)

---

Another advantage, off-topic, to a Names table, is that you can have a NameEquivalences table that records, by whatever means, the fact that "Johnathon" is the same as...

This is probably the best article on Dynamic Search in SQL Server out there.

How do you know it is not working, are you getting an error or are no rows going out the "blue" dataflow?

You need to make sure you match case and...

I would definitely say you are on the right track. Query1 will not need a bookmark lookup to the get the parentUrl because parentUrl is an included column. ...

Couldn't you do something in Excel to save the file as pipe-delimited and then import the rows into the database?

mazzz (6/29/2009)

---

Jack, a propos of nothing at all: I smile every time I see your name. Back in my university days I used to share a house with a Jac...

In addition to Flo's suggestion, which will work, there are several third-party comparison utilities on the market including RedGate SQLDataCompare and ApexSQL SQLDIff that have evaluation versions so you can...

You should be able to develop the SSIS package in 32-bit mode and run it using the 32-bit DTEXEC utility.

There is no schema level backup in SQL Server. IF you separate the schemas onto their own filegroups or files then you could backup the schemas.