Retrieve the name of the current database for use with bcp and other procedures that require database name. This will help increase the portability of code and less maintenance required when migrating code to new database/server.
2003-05-22
194 reads
This script uses sysobjects and sysindexes to ID all tables in a database that are indexed, and/or clustered. It then runs through per table all of the indexes and runs DBREINDEX with their fillfactor. This eliminates having to maintain a list of all indexes and having code fail when it tries to modify indexes that […]
2002-12-19
1,757 reads
By Steve Jones
I got a message a few months back that Microsoft was deprecating the MySQL...
By James Serra
A TON of new features announcements at the European Microsoft Fabric Community Conference help...
I am trying to build an ETL for an Existing Table. The ETL (SSIS)...
(This is probably the wrong forum to be posting this question, so please forgive...
Hi, We are using database snapshot together with changetracking to keep a datawarehouse up...
In the current (2024) version of the Data Migration Assistant, which on-premises targets are available?
See possible answers