hx_GetPKLessTables
Returns a list of table names from the current database Which do not have primary keys assigned.
2001-08-22
412 reads
SQLInsider Scripts
2001-08-22
715 reads
hx_dbMaintancePlans
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
362 reads
hx_DatabaseProperties
Displays database properties. Was this the best way of doing it? Probably not, but it works.
2001-08-22
531 reads
2001-08-22
392 reads
Blogs
Using a tnsnames.ora file with the Microsoft Connector for Oracle in SSIS
One of the nice things about the Microsoft Connector for Oracle is that it...
ChatGpt Experiments–Getting Documentation
By Steve Jones
I get asked questions by salespeople all the time. Usually this is because a...
A New Word: Jouska
By Steve Jones
jouska – a hypothetical conversation that you compulsively play out in your head –...
Forums
Changing a datasource using T-SQL Script
I've been looking for a way to change multiple data sources for reports to...
Azure SQL Revealed: A Guide to the Cloud for SQL Server
Comments posted to this topic are about the item Azure SQL Revealed: A Guide...
Refresh Limits
Comments posted to this topic are about the item Refresh Limits
Ask SSC