Yep,If sp_executesql would accept the table variable as a parameter, you would be out the tunnel. Unfortunately it only accepts parameters that are Unicode or can be explicitly converted to ntext. @Table variables can't..........Bit of a pain but - looks like you will have to find an alternative DallenHave fun
2004-11-24
Sometimes the problem can be due to the incorrect MDAC version. Try downloading the latest MDAC version from Microsoft and installing that in the problem computers.If you want to check the version first, Microsoft has something called "component checker" that checks for the MDAC version. Run that against your 'good' computer and then against your […]
2004-08-16
The fact is that I am looking for a generic way to implement paging. Not just on partners table. On any table with ANY number of rows. That includes tables that are not static and are very large.Therefore, the scenario you are proposing is risky in terms of memory usage. In fact it would require a copy of […]
2004-03-19
Following up on what Douglas said regarding backups, one thing that you might be tempted to do is to use the SQL Client for arcserve to allow you to backup the databases live....don't do it....I have tried and had nothing but problems with the restores...
2004-03-08
Concerning part I consider: http://qa.sqlservercentral.com/products/xp_msmq/ best regards, chris.
2003-12-10
It is just 100 MB but i tried to run it for a new Database which I just created for this purpose only and its not working for that too.
2003-12-09
If I understand you correctly, in the *web products attribute table* you have one row per product containing all the attributes. In your CRM table, you have one row per product and per product attribute. And it is hell to start comparing these :). You could remove all of the cursors by comparing each attribute […]
2003-08-13
Someone asked the service we use...for the benefit of all, we use CD Light County-Zip DB. They provide several formats, from ASCII, to Access to their own proprietary format that includes DLLs for searching by address, not just zip. In terms of installation for the DLLs, you have to do a full install. The install […]
2003-07-29
1 reads
Hi Csaba, you've said, you've installed SQL Server. Can you reinstall the OS or is this a problem? Cheers, Frank
2003-06-20
1 reads
2003-06-10
1 reads
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers