hx_OLEDBproviders
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
407 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
407 reads
Very simple, how much space is free on the hard drives of the SQL Server you are connected to.
2001-08-22
660 reads
2001-08-22
373 reads
2001-08-22
722 reads
This stored procedure was designed to scan all your character based columns in a particular database and show the minimum, maximum and average data length. As well as give an efficiency rating of the data stored. Input: None Output: Table name, Column name, Defined datatype and length, Average length of data for that column, Minimum […]
2001-08-10
1,669 reads
By Steve Jones
The Future Data Driven 2023 virtual conference is coming on Wednesday, September 27. Register...
By Steve Jones
A few years ago SQL Prompt added a command palette to let you search...
The Identity property creates an incremental value for the specified column automatically, which is...
We have about 20 SQL Servers. We use Net backup or Native backup for...
I have one SQL Database server which is old version and planning to migrate...
Comments posted to this topic are about the item Restore With Standby; A Review...