I have tryed to use the OLEDB provider but it is flakey at best as a linked server. but seems to work great in ADO.The most reliable "free" method I have found is to use the client access ODBC driver on the SQL server. then create a linked server using the OLEDB driver for ODBC. And […]
2004-09-16
hey there,I created an extended stored procdure in VC6++ under windows 200k prof and SQL Server Developer Edition. Every thing works fine in the development machine. However, there is a problem when I tried to deploy it to other machines. It does not work on SQL Server enterprise edition with error "Connection opened but invalid […]
2004-09-15
3 reads
Hello everyone: I have what, I think, is a very weird problem: I have a query that works just fine if I run it alone, but when I run it as part of a sored proc, it generates much less rows. The only difference is that I'm including some 'variable parameters' in the query when […]
2004-09-01
3 reads
This Error message is the cause of using SQL Server with High End Disk Subsystem like EMC. Please monitor your disks and organize the databases to be load balanced so that one disk is not being hit.
2004-08-03
Oh yea !!! Autoclose was on. Turned it off and hat did the job. Thanks for that one. Any tips on the perfect setup for SQLServer2000 Options (Settings)
2004-07-19
3 reads
HiI have made a packages that works nice when I execute the package but when I am doing a schedule job then doesnt it work.This is the error code:"The process could not be created for step 1 of job 0xB4B1D2612F8DC04194B919CFBE45923A (reason: The system cannot find the file specified). The step failed." I have tried to change […]
2004-07-07
I am using sql authentication. I have been working with the dba that set up the database for me and he says nothing has been altered with my permissions. He also examined the connection states as I was attempting to expand the folder and determined that my connection was NOT in a wait state. I am […]
2004-07-01
Oops. I found the problem myself - persistence is the key. I omitted the "New" keyword when I declared the DataSet variable.
2004-06-11
I am trying to copy a database using the export/import wizard and keep getting a 'Invalid object name' error. The reason for this is DTS does not appear to create views in dependency order ie view A is dependent on view B and it attempts to create view A before it creates view B. Any […]
2004-05-27
7 reads
2004-05-21
3 reads
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...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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