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,164 reads
2001-08-26
1,445 reads
2001-08-22
434 reads
Displays database properties. Was this the best way of doing it? Probably not, but it works.
2001-08-22
572 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
416 reads
2001-08-22
763 reads
Returns a list of table names from the current database Which do not have primary keys assigned.
2001-08-22
458 reads
2001-08-22
615 reads
2001-08-22
790 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
505 reads
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
By Arun Sirpal
AgentDBA began as a command line. That suits one DBA on one server, but...
By Steve Jones
I have a few Azure subscriptions, which are fairly small and not used that...
Wa:083849450961 Jl. Brigjen Sudiarto No.294, Palebon, Kec. Pedurungan, Kota Semarang, Jawa Tengah 50273
Wa:083849450961 Jl. Raya Bandungrejo No.102, Bandung, Bandungrejo, Kec. Mranggen, Kabupaten Demak, Jawa Tengah 59567
Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, RT.1/RW.5, Menteng, Kec. Menteng, Kota Jakarta...
With regard to SQL Server 2025's Vector support, what is an embedding?
See possible answers