Please, be advised on the following if you will use the Copy Database Wizard. Books Online say that you need to be in the sysadmin role on both servers, that...

Hi,

there is too few details. OLEDB job can fail for so many reasons. David is right. It could be a certain type of data or length of the field...

Hello,

Are you sure you are rebuilding in the same database where you run SHOWCONTIG? Sometimes we have several windows open in Query Analyzer connected to Development and Production servers.....

Did you...

1. You do not need to specify a \ in the DNS alias. \ is used to separate a server name of the instance name

2. Are you sure you have...

Hi,

are you taking the old computer off the network? If yes, then ask you network admins to create a DNS alias for the new server with the name of the...

Graeme,

Justin is right it is a good solution.

Another solution is: since a Delete is a logged operation that puts entries in the transaction log for the active transaction iven...

Hello,

The general recommendations that will increase performance are

1. Split the table and put 2 new tables on different filegroups on different drives.

2. If the old documents are not accessed often...

Hello,

It is more of the administrative then a technical issue. In the similar case we kept Builtin/Administrators but removed support groups from Windows Administrators group. There was only Administrator, and 1...

Brian,

You are certainly right. Ownership Chaining is not a feature. It is a concept and as such it was present in 7.0  (I am not sure about 6.5 security) What...

Excellent Discussion!

I just would like to add one thing unrelated to the original question but important for the quering across databases and owners.

SQL Server SP3 (and SP3A) introduced a...

Did you try a group/role login with checking Impersonate checkbox?

For example I connect my Server1 to my Server2. I am logged as Domain\mylogin to server1. I entered Builtin\Administrators role as...

Vas,

You do not have to specify a database name if you are sure you are inside the database you need to query. If you use Query Analyzer and the the...

I love the explanation!

"Answer E is incorrect because A, B, and C are incorrect. " But E says: "All of the above are incorrect..." !!!

The correct explanation would...

Make a business owner  and your management sign  a DRP (Disaster Recovery Plan) that includes different scenarios for different times a Server or a Data Center is down. Then they...

This error message is not related to the logins. 

This error message means that the second server may be off line or the firewall port was closed. Please, try to ping the...