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,158 reads
2001-08-26
1,442 reads
2001-08-22
427 reads
Displays database properties. Was this the best way of doing it? Probably not, but it works.
2001-08-22
571 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
415 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
453 reads
2001-08-22
611 reads
2001-08-22
782 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
494 reads
By James Serra
If you are migrating a data warehouse, there is a question worth asking before...
By Steve Jones
I’m back from a great vacation. I had the chance to visit two new...
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
Wa:083849450961 Jl. Raya Palur No.Km 5, Jurug, Ngringo, Kec. Jaten, Kabupaten Karanganyar, Jawa Tengah...
Wa:083849450961 Jl. Utan Kayu Raya No.94, RT.12/RW.10, Utan Kayu Utara, Kec. Matraman, Kota Jakarta...
Comments posted to this topic are about the item DML Trigger Types
How many types of DML triggers are there?
See possible answers