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
366 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
366 reads
2001-08-22
718 reads
Returns a list of table names from the current database Which do not have primary keys assigned.
2001-08-22
416 reads
2001-08-22
552 reads
2001-08-22
709 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
410 reads
Very simple, how much space is free on the hard drives of the SQL Server you are connected to.
2001-08-22
664 reads
2001-08-22
375 reads
2001-08-22
724 reads
This script will search all logged in users and return the spid along with the number of seconds since that spids last batch was executed.
2001-08-22
941 reads
By Steve Jones
Recently I was trying to delete a folder and kept getting the “something is...
In the introduction of this blog post series, I explained the use case: extracting...
In the introduction of this blog post series, I explained the use case: extracting...
I tried to set the execution timeout in SSMS for SQL Server 2017 using...
Comments posted to this topic are about the item Implementing Change Data Capture
Comments posted to this topic are about the item What is new in Copilot,...
I have a complex environment that uses quite a few SQL Server 2022 servers. We have a powerful SQL Server running Enterprise that hosts most of our transaction data. However, there are remote locations that run Standard, Web, Express, and Express with Advanced Services editions for local collection of data before the data is transferred to our central Enterprise Edition server. We are considering using Change Data Capture (CDC) to lower the amount of data we transfer from clients. Which editions can we implement this feature on?
See possible answers