We have a plan that is in monthly buckets, where sales is in daily buckets. We spread the plan down to the daily buckets to allow more flexibility.

Other considerations -...

You may also want to try creating some views.

This would seem to have some hope from the start.

Kind of a Parent Key table, if I'm reading this right.

Greg E

SET @STRATEGY_TYPE_KEY...

Our indexes in the Base Warehouse tend to be different than what is on Production, but they are very important - both for when we load data, and for user...

Try this article

https://helpdesk.handynetworks.com/supportsuite/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=142

and scroll to the bottom of this for some more details of what the account really needs

http://www.windowsecurity.com/articles/Hacking_an_SQL_Server.html

Using Regmon and Filemon, you can troubleshoot access/bootup problems, and restrict this...

Is it possible to do a complete unistall? Then see if there are traces left over?

Did you try applying SP2 after the install?

Greg E

MG (11/7/2008)

---

Dejan,

Is it really necessary to get delegation to work? From my experience and from what I've read here and elsewhere, if there is a reasonable alternative, it does not...

One other thing to verify - that all machines are in the same AD domain / forest.

If not, you have to verify that there is a trust in place. And...

See if these help out.

http://blogs.msdn.com/sql_protocols/archive/2005/10/12/479871.aspx

http://technet.microsoft.com/en-us/library/cc786325.aspx

Make sure the user the service is running under, the server, and the user accessing are not marked as Sensitive.

Also you will not see the...

Just a quick comment -

Looks like a Quad core machine - 4 proc, 4 cores each. Any particular reason you didn't go with x64 bit?

It is meant to address more...

Since it looks like it's specifically excluded from support, you might want to ask someone at Microsoft. See if there is a virtualization launch coming up near you.

https://www.getvirtualnow.com/usevents/cityselect.aspx

also check arount...

Junior_DBA (10/19/2008)

---

Hi Guys,

I am still testing, I tried changing accounts in "Services" to a domain account, I reboot the computer, I add under Local Security Policy "act as operating system",...

Jaco Pieterse (10/16/2008)

---

Hi guys,

If I have an IIS box(the db sever is seperate and licensed) for my SSRS 2005 that has 4 CPUs, must I purchase 4 processor licenses or...

We are looking at a similar usage. EE with CPU licensing, with an external connector license, was what I recall being told we needed.

Remember that at SQL 2005 launch they...

One remote option could be using psexec.exe on the client to call a batch file on the server.

Make sure you have some method of checking for failure in the event...

But...Has anyone had a dedicated "Data" organization that reported directly to the CIO? What I find ironic about the CIO is that the title is "Chief Information Officer" and...