Hi Rob

Rob Fisk (11/18/2009)

---

Woah, lots of great stuff coming in here. I can hardly keep up. I keep refreshing to make sure what i am about to say has not...

Hi C# Screw

Thanks for your testing! I'm curious about some additional test results.

Greets

Flo

Hi all

@jeff: Thanks for your feedback! But I have to admit, that I've been surprised about my first test results. Apparently I've made one failure I already did...

Just had to tie my shoes 😉

Hmmm I think I preferred SSCommitted to SSCrazy,...

brigzy, what do you want to here? I wrote sorry, since I misread the script of you...

@paul-2

Congrats for >2k posts! 🙂

Hi

brigzy (11/17/2009)

---

You really should address Thiago who wrote the test data generation SQL. Thiago's script does generate a complete table quite nicely, this we used for testing the techniques....

Hi Ant

Disclaimer: My last VBA is about ten years ago 😛

If you use ADO you should use OLEDB instead of ODBC. Give this connection string a try:

Provider=SQLOLEDB.1;Data Source=YourServer;Initial Catalog=YourDatabase;Integrated Security=SSPI;

To...

Ah.. thanks for explanation. 🙂

Greets to Denmark!

Flo

Hi

First, why do you use ODBC? If you work with VB.NET use SqlClient. If you work with VB6 you should use ADODB.

Second, did you try to install the latest drivers?

Greets

Flo

Please execute this in your query window:

SELECT @@SERVERNAME, DB_NAME();

SELECT * FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = 'customers';

Does this show the right server/database and does your schema appear in the output?

Greets

Flo

Hi yosiasz

Thanks for sharing! But I'm a little confused :-P. Thought you are looking for a SQLCLR procedure to handle this. Your source code looks like a console application with...

First, thanks for the feedback. Glad that we could help. 🙂

Second, didn't know that SQLCLR assemblies can be developed with Express Edition. Thanks for sharing this information!

Greets

Flo

Hi Jose

This error is caused by your previously executed "allow updates". Have a look to BOL:

Setting Server Configuration Options

Try to reset this configuration with:

sp_configure 'allow updates', 0;

Greets

Flo

Hi

First first. "Allow Updates" is obsolete and does not work any more (thanks god!). Do not use this option.

Your error says all. "show advanced option" is not set until you...