Viewing 15 posts - 1,246 through 1,260 (of 2,496 total)
Is 'Show Advanced/All Properties' checked? You do not see the option you need unless advanced properties aer shown.
July 17, 2009 at 8:19 am
Sorry, I am out of ideas.
July 17, 2009 at 8:17 am
Registry access is often the problem, but ther can be other blocks to getting this working...
It is worth trying to control the services using a different tool as part of...
July 17, 2009 at 6:25 am
The default security model in Analysis Services is that the local Administrators group has ServerAdmin access and nobody else has.
A system administrator can grant ServerAdmin access to the DBA group,...
July 17, 2009 at 5:37 am
You need remote access to the target machine registry. Some sites lock this down, so you may need to talk to your Windows people to see what has been...
July 17, 2009 at 5:31 am
Lots of good advice in this thread!
Another way that anything relying on a MAC address can produce duplicate results is that you are relying on all MAC addresses being globally...
July 16, 2009 at 5:24 am
You will need to take disk images of all drives that contain program files that will be involved in the upgrade.
Some of the problems you encounter may leave you with...
July 16, 2009 at 5:09 am
I have some involvement in redundancy councelling, and would add some other points...
Do not be surprised if you feel low or depressed. Most people find the disruption to their...
July 16, 2009 at 5:02 am
There is a choice:
1) You can be lazy and put the SQL service account in the local Administrators group. In this situation you give SQL Server more rights than...
July 15, 2009 at 5:44 am
I agree with Rudy.
If you want to look at building your own conversion routine then look for 'Packed Decimal' or 'comp-3' in Google.
It will be quicker and easier...
July 13, 2009 at 10:00 am
On a 32-bit server the Perfmon TargetServerMemory results and Task Manager will never report more than 4GB memory in use.
In order to see if you are using more than 4GB...
July 10, 2009 at 6:01 am
In order to set up a custom role in msdb that inherits the capabilities of SQLAgentOperatorRole (or any other role) you need to do the following...
1) Create your role
2) Add...
July 9, 2009 at 3:53 am
In SQL Server 2005 and above, all tables have the capability of supporting multiple partitions. By default all data is kept in a single partition.
If you want to use...
July 8, 2009 at 5:41 am
W2003 R2 Standard can use up to 32 GB memory. You should check out other changes that came with R2 for W2003, they may also be useful.
Why are you...
July 8, 2009 at 5:17 am
Viewing 15 posts - 1,246 through 1,260 (of 2,496 total)