Have just installed MSDE 2000 sp2. When I look at the server properties in Enterprise Manager it tells me the product version is 8.00.534 (SP2). When I do SELECT @@version I get told the version is 8.00.534 but the last line reads Build 2195: Service Pack 1. Is this an omission by Microsoft?
2001-12-05
10 reads
This article describes how to monitor Microsoft SMTP usage using SQL Server 2000 and XML.
2001-11-29
3,558 reads
I have just started a new role as an SQL DBA and I'm currently in a huge learing curve. We have built an NT4 server with 7.0 and it's working fine. The Java application took 2 months to build and is now relatively stable and ready to be tested. I have now been told I […]
2001-11-20
2 reads
Does any of you knowledgeable DBAs know how to grant execute permissions on a database level? To be more specific, I would like to give execute permissions to a login account for our application. I'd like to give an account permission on all user created stored procedures in a given database, but I want it […]
2001-11-10
3 reads
Hello, I am using a stored procedure, that receives a parameter from an ASP page, to execute my DTS package. This works fine, but I have not been successful in getting the DTS package to recognize and use the global parameter I am sending it. I am using the syntax "/A MyGlobalName:String value". The global […]
2001-11-07
I am fairly new to SQL Server. I am trying to write a stored procedure to update fields in a table with information in another table. Both tables have a common key field. I have not been able to get this to work. Any help would be graetly appreciated. Percival Bragg
2001-11-02
2 reads
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/sjones/anniversary.asp
2001-11-02
4 reads
The XML features of Microsoft® SQL Server® 2000 and the subsequent XML for SQL Server 2000 Web releases enable a whole new class of XML-aware applications. This article shows you how to improve the performance of this new feature.
2001-11-01
2,241 reads
Microsoft® SQL Server 2000 introduced several new features for querying database tables and receiving the results as an XML document. Web release 1 of SQLXML (XML for SQL Server) added Updategrams and XML Bulk Load functionality, as well as a host of other features to the SQL Server 2000 base.
2001-10-29
6,623 reads
We have copied tables from AS400 into .txt files with FTP.We want now to load these files in SQL tables using BCP. The source and target tables have exactly the same stucture; some columns are in decimal format and cause always errors. What can we do?
2001-10-22
88 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