This script creates a stored procedure that, when executed, queries the system tables of any SQL2000 database to return a complete, ordered datadictionary. *Warning**This script only works on tables which have the description property filled out as my main purpose was to query the extended property description feature new to SQL2000. If you have not […]
2001-08-27
3,146 reads
2001-08-26
1,433 reads
2001-08-22
418 reads
Displays database properties. Was this the best way of doing it? Probably not, but it works.
2001-08-22
560 reads
Displays Maintance plan history if any. I used distinct to filter out and return only what is relevent to what I need. You may not wish this for your purposes. Feel free to make changes
2001-08-22
402 reads
2001-08-22
748 reads
Returns a list of table names from the current database Which do not have primary keys assigned.
2001-08-22
446 reads
2001-08-22
596 reads
2001-08-22
756 reads
Get OLE Providers info I have found this useful in tracking down application driver/connection issues. I only had to use it 2 times. But it did help
2001-08-22
472 reads
Creating a Fabric workspace takes about 30 seconds. Restructuring workspaces after people have built...
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
WhatsApp CS 628218520153 Jl. HOS. Cokroaminoto No.83, RT.3/RW.5, Menteng, Kec. Menteng, Kota Jakarta Pusat,...
WhatsApp CS 628218520153 Jl. K.H. Wahid Hasyim No.82, RT.15/RW.3, Kb. Sirih, Kec. Menteng, Kota...
Comments posted to this topic are about the item SQL Server Automated Backup &...
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers