Hello,

The update fix discussed above didn't work for me.  Everytime I execute an update to change the ServerVersion to the value that SSRS is looking for, the ServerVersion value...

Try installing AS/400 Client Access software on the server and using that provider to setup your linked server.

Sue

The latter so that people...

You can get information of the DBCC executions by querying the default trace file for the Audit DBCC Event. It will have login, host name, application name,...

You can get information of the DBCC executions by querying the default trace file for the Audit DBCC Event. It will have login, host name, application name, etc.

Sue

That looks like it should work - it would be an easy one to test in a non-production environment. Make sure to qualify the table name with schema.TableName if you...

A CTE has an execution scope of a single (the important word) statement that follows the declaration of the CTE. So just for the select, insert, update, delete, etc that...

That looks like the code for a function to start a job in Powershell so I'm trying to guess at what it was originally and figure out what you are...

Some processes where there is access to other servers, external resources and some of the functions to get server name. I know Replication is one thing that uses it and...

So you have it set to change tracking automatic. How that works is that after the initial full population, it automatically updates the index for changed/added data. This is an...

I haven't used it for awhile but RedGate's Data Masker tool has custom rules you can create for to address these type of issues. Seems like it might work from...

For that report you use, how is it being determined that the log file was never more than 50% used at any point? I'm wondering if that's not where the...

Just to add...in case you needed to know what to move and wanted to keep doing this with scripts, you can do restore filelistonly to figure out what to put...

Number two isn't correct though. A full backup doesn't truncate the log. In full recovery or bulk logged model, a log backup will truncate the log. In simple recovery, a...

I would probably capture what's going with the IO from a SQL Server perspective querying sys.dm_io_virtual_file_stats. You can see the results by database id which should really help since your...