This is an internal extended system stored procedure that gets called to prepare and execute an ODBC batch in one round trip to the server. There is a detailed thread about this in Google Groups - search for "ODBC and SQL 2000" (including the leading and trailing double-quotes) in Google Groups, and look for the posts from October […]
2004-03-15
1 reads
Quote:Also looming is the announced end of mainstream support of SQL Server 2000, which will end on December 31st 2005. If SQL Server 2005 doesn’t release until the second quarter of 2005, this may only give a customer 6 months to upgrade their database environment before facing a support problem. Typically Microsoft has extended this […]
2004-03-15
If you have a non-central site down and intend to perform disaster recovery and are doing snapshot replication, maybe the following will work.Set us a subscriber pull option to the publication, only to be ran when the subscriber site requests (in this case when disaster occurs).The publication should still be available from the distributor and […]
2004-03-15
hi, did you install SQL Server Service Pack 3. well, there is a problem with sqlserver service and the netlogon service of windows. also after installing SP3 there is a hot fix that you must install "SQL2000-KB810185-8.00.0859-ENU.exe" look it up at microsoft site.
2004-03-15
Well, since the Crystal Reports requirement was not made by me (Client requested) I have little or no choice to alter the development tool at this time. However the meeting went well with the client I created about 4 screens (reports) and just saved them and showed the access points and functionality as requested. However […]
2004-03-11
Not to be picky, but what are you trying to do? It isn't very clear (at least to me).
2004-03-11
This answer if for the second questionupdate test set Date_col = #DateVal# where pk in (select top 5 pk from test order by Date_col desc)PK = Primary key column in the test tableDate_col = Date column in the test table
2004-03-11
For making backups, we use Arcserve as backup software.. How can we stop the databases, then make a backup of the databases with Arcserve, and then start the databases. Is there a script, that stops and starts the database or SQL-server ?
2004-03-11
3 reads
save following to DelHeaderLine.wsfUsage sample:DelHeaderLine source destinationIt copy the source file to destination without the first line.<job id="DelHeaderLine"> <runtime> <description>Delete text file header line</description> <named name="SFile" helpstring="Source file" type="string" required="true" /> <named name="DFile" helpstring="Destination file" type="string" required="true" /> <example>Delheaderline.wsf /SFile:151.txt /DFile:aa.txt</example> […]
2004-03-08
2004-03-08
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