This script extracts various details from SQL Server 7.0/2000 based on sysfiles and sysdatabases. It returns the server name, version of SQL Server, database name, device name, device location, and approximate size in MB of the device.
Other News
Inside Microsoft SQL Server 2000
To help you design Microsoft database servers that must achieve the best possible performance, Inside Microsoft SQL Server 2000 has the details you need. For one thing, author Kalen Delaney (who used Ron Soukup’s fantastic first edition as a starting point) explains how SQL Server 2000 works at a le
A proliferation of database types
By Phil Howard – Even if you didn’t think that the business intelligence market was a mature market, I am sure that most of you think that the database market is completely done and dusted. Well, not in my experience. There are more different types of commercial database available today, than there
Collected Tablespace Tips
DBAs spend a lot of time monitoring tablespace usage. Ask three DBAs to provide the best script for tablespace analysis, and you will get three different scripts. Below are nine that have been submitted over the past two years.
JAXB Revisited
by Daniel F. Savarese – Developer feedback has evolved Java Architecture for XML Binding (JAXB) into a version that better meets your needs. Take a fresh look at JAXB, and see how you can expect to write far less SAX and DOM code.
Creative Comments: On the Uses and Abuses of Markup
by Kendall Grant Clark – Whether you think of the Semantic Web as a new and exciting promise or as a fantastic and impractical threat, it will not be a separate web but, rather, overlay the existing one. The Semantic Web isn’t a replacement, it’s a supplement. Both the existing web (the “Human Web”)
MediaRich Tip #103: MediaRich and XML
The purpose of this tutorial is to illustrate how to use the MediaRich XmlDocument object. Our documentation does a good job of defining the MediaRich specific portion of our implementation and the DOM specification covers the rest. What we still need to do is bring the whole thing together.
Bulk Copy Program Utility
Q. How can I create a plain-text flat file from SQL Server as input to another application?<br><br>A. One of the purposes of Extensible Markup Language (XML) is to solve challenges like this, but until all applications become XML-enabled, consider using our faithful standby, the bulk copy program (b
Data Validation for Transactional Replication
In this article, Alexander Chigrik describes general concepts concerning validating data for Transactional replication using SQL Server. He then provides a step-by-step guideillustrating the data validation process.
Granting Permissions on Database Objects
Q. Why do I have to give permissions on the underlying database objects when I’m using dynamic SQL statements? A. These permissions are required for security reasons. Consider the following simple stored procedure: