Greetings,

It will not work because it takes forever for the reporting services after I pressed the button view report to make the call to SQL Server and execute the underlying...

Greetings,

ok, still hoping someone may have a clue. Is it normal to have MANY reset connection? It is where I see most of the time is lost

Here is a...

Greetings,

I can't believe there is not much people experiencing that issue.

Sure no one hit that snag before?

Thank you

Greetings,

I noticed a few new things:

- The problem appears like from nowhere. It worked fine then the report began to have issues.

- The CPU hits a steady 25% utilization for...

Greetings,

I figured something out. Maybe someone will have an idea where the issue is:

Running Profiler, I saw that between the time the button to generate the report is pressed and...

I forgot to say the report throws that error msg:

Execution 'mx5h5h55xwab3p55el5bbv45' cannot be found (rsExecutionNotFound)

Greetings,

Hmmm....If it is a star schema, I don't see much performance issue why you cannot have all your subsets and query by periods. Especially that the periods definitions are indexed.

Maybe...

Greetings,

I did that exam, passes with 875/1000 and everything you need to know about encryption will be in the articles here.

http://www.sqlservercentral.com/Articles/Security/

Just read those with SQL Server 2005 and encryption in...

Greetings,

Welcome to the giant databases world.

I can't give you precise and detailled info, but I can help you to get started.

You will have 3 foes to tacle:

1 - Access...

Greetings,

----> Based solely on what you wrote <----

Fire that consultant!

I worked on a few (ok...many) projects "bringing" data from mainframe/unix/flat files/etc to a SQL Server/DB2/oracle database used for datawarehouse...

Greetings,

Make sure the windows logon running the service has been granted rights on the mail server.

make also sure there is no rule in your network preventing traffic between the SQL...

Greetings,

I would approach it this way If you backup your logs:

1 - I would push back the delete of the old files as much as the functional or the space...

Greetings,

Put simply (On a time crunch here):

If you are using mirroring, "roughly" the data sent from datacenter 1 to datacenter 2 will be the size of you database(s) log(s) +...

Greetings,

That is not the case. There is no sp that is execute at the start with the sp_procoption.

...Still a mystery... Next week I'll be able to restart the service and...

Greetings,

The only way is to create a trace with a filter on those users. Make that trace auto-start when the SQL server service starts.

HOWEVER, be aware your users with SA...