It provides an infrastructure to create and manage various SQL Server stored procedure based reports into HTML output. You can add reports, categorize them in a treeview, edit, delete and manage the report parameters - all through the web interface. Members can now download this as Freeware at SQLServerCentral.com.
2002-05-16
127 reads
Is the Identity property part of a transaction? I always thought so, but decided to test it and see what happens.
2002-05-16
4,574 reads
2002-05-15
2,962 reads
This article shows you how to use the CASE function to design single query solutions that have changing results depending on the values you assign to variables. These techniques are extremely useful as alternatives to dynamic SQL.
2002-05-14
10,835 reads
Version control for stored procedures isn't always popular and certainly isn't easy. Or can it be? Andy discusses a technique he used on a recent project that you might find interesting.
2002-05-10
13,465 reads
SQLServerCentral.com has crossed 40,000 users! Thanks for all of you telling your friends about our site and making us a strong SQL Server community. To thank you, you can request to receive a free DTS object model poster that we worked on in conjuction with Lumigent. To sign up to get your hard copy, go to http://www.lumigent.com/go/sqlcentral05
2002-05-10
3,336 reads
2002-05-08
3,254 reads
Multi server administration allows you to create jobs and maintenance plans once. You can then monitor and change them from one SQL Server. View job histories and statuses for 2, 4, 10, or more SQL Servers from one master SQL Server. See how you can simplify your administration duties with multi server administration.
2002-05-06
13,477 reads
RAC's domain name has changed to rac4sql.net. Read their sad fight with their hosting provider here.
2002-05-06
51 reads
This book from Microsoft Press has a lot of good information that will help you do capacity planning and performance tuning. Is it worth buying though? Andy just finishing reading it and writing the review, see what he thinks!
2002-05-03
8,346 reads
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
The file FDLAUNCHERRORLOG gets created in the default <instance>\MSSQL\Log folder. So far, I've found...
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers