Did you try master..xp_cmdshell?

Personally, I agree with colin. Index Tuning Wizard gives us redicular recommendations. My original question is how to read its reports, not if it is reliable to use the tool.

Many...

John:

Thank you very much for your input. We should use sysusers to retrieve info on basic roles, sysprotects to retrieve info on detail permissions.

I think I understand the question. You are refering job owner, not object owner.

I had similar issues. I cannot see any better approach fixing them. I had to re-do...

You may have to use full ownership to access your table, such as, [owner].tablename

My "insight" is: it will run. The reasons are, we did not have any such an issue before, nor did we have any job running twice at the end of...

First of all, you do not have to uninstall SQL Server. You are right it is easier to re-install SQL Server. If you would like to move database locations, you...

Personal point of views.

Replication is nothing more than triggers. You can add triggers on your tables to update your reporting server. After creating triggers, you create your own replications. 🙂

If...

Here are my inputs.

OPENQUERY uses existing connected remote server. OPENROWSET uses existing retrieved data (rowset). The first one has more flexibility in retrieving data. The second one discloses your password.

When you backup log, you truncate the inactive transactions. Then, you can shrink log file. If you do not need logs, you can set the database in a SIMPLE mode....

I knew the way you described in the easiest way for multi-users. However, sometimes, one user loginID has been created. Then, I got a request to create a new loginID...

Did you check if the remote property on the remote server is turned off?

Did you check if the two servers are in different domains and a firewall is set in...

As far as I know, Microsoft has not solved the memory leak completely. As a result, a server or a service need to be restarted accordingly. How often we need...

Check the ownership of this table. If it is not dbo, you may have to include the ownership in front of your table name.

It is a disaster if a user has application role on a database. In this scenario, we can disconnect the user. However, it will be reconnected immediately. I had to...