peterzeke (6/11/2009)

---

Try using an exclamation point (bang= !) at the beginning of your input mask. The ! should force data entry to begin at the left of the field.

here's...

Dean Cochrane (6/11/2009)

---

It would be interesting to do some testing to see at what point the cost of the recomplications outweighs the overhead of #temp tables.

I'm taking Kalen Delaney's course...

Cool trick though. good to know.

Hmm, got me. I am going to see if someone else can help out here...

OK, two things, first, I need to see the call in your EXCEL sheet to this function, because the values are all parametrized here.

Second, if you do not want to...

haroonrashed786 (6/11/2009)

---

...when iam updating or inserting row ,i need to get the ID Collumn of table.it is working fine with SPs,when include triggers iam getting wrong .insted of getting...

Well, I can't see anything wrong...

I suggest setting up profiler on the subscriber and then re-build it again and capture what commands are actually being executed.

Ascii only supports the ASCII character set. Unicode supports virtually every character set in the world.

Jeff Moden (6/10/2009)

---

Any idea if SQL Server...

Excellent Article, Wayne! A much needed treatment of the commonly misunderstood subject. It's already in my briefcase... 🙂

What you should be able to see however is that the Unicode .sql file is about twice the size of the Ascii one.

DanielP (6/10/2009)

---

I had created 3 Config files for one package and had the one on top as the one I wanted to use when deployed. But the Solution was...

Whats the problem? why not just set up transactional replication?

We'll need to see the code from the stored procedure and the VBA.

Documentation.

I know, :sick:, but you'l never have a better opportunity.