Viewing 15 posts - 1,786 through 1,800 (of 1,883 total)
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...
October 7, 2004 at 10:54 am
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...
October 6, 2004 at 3:35 pm
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...
October 6, 2004 at 3:21 pm
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...
October 6, 2004 at 2:24 pm
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...
October 6, 2004 at 10:10 am
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...
October 6, 2004 at 9:59 am
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...
October 6, 2004 at 9:51 am
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...
October 6, 2004 at 9:39 am
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...
October 5, 2004 at 9:40 am
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...
October 5, 2004 at 9:18 am
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...
October 4, 2004 at 4:23 pm
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...
October 4, 2004 at 4:00 pm
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...
October 4, 2004 at 8:44 am
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...
October 1, 2004 at 3:33 pm
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...
October 1, 2004 at 12:41 pm
Viewing 15 posts - 1,786 through 1,800 (of 1,883 total)