I normally pass the values to a string to table function (I can send you one if you need it just message me). This creates a temp table with each...

Have you checked your permissions on the cube? What about the fixed server role - are you a member? What about the user you are using for the service does...

Not necessarily just a DBA tool, but we use HP OpenView to monitor our servers, restart services that stall, page us of ports not responding ...

I find it very handy...

I'm noticing lots of vendors now throwing in a BI solution to their package. So I agree it is on the rise. But I am not seeing BI used as initially...

1434 is the listner service if it is blocked you must know the port that your server is running on and specify this in your connections.

Are you using Windows...

I have had great luck with the microsoft newsgroups http://www.microsoft.com/office/community/en-us/FlyoutOverview.mspx   go to the excel area and figure out what area you belong in.

What are you client OS's? XP SP2 perhaps? Have you looked at your Firewall settings? You will need to open TCP port 1433 and UDP port 1434. That is assuming...

I'm 34, been in IT since grad school- almost for 13 years now. I enjoy my job, but the hectic IT industry is taking its toll. Due to a recent truck...

I disagree. There is a huge difference between OLAP and OLTP production - at least in our environment. In our hospital if the OLTP system goes down, patient care suffers...

One thing missing in the DW DBA article is the ability for the DBA to adapt quickly. Datawarehouses typically aggregate data and may only use a subset of OLTP data....

I find co-workers/boss are very valuable. Get me competent co-workers/boss that don't slack off all the time and I would be happy.

Beyond that Location, location, location (no Houstin, New...

Interesting, but isn't a broken down shack in San Diego go for 500k? 100K isn't going to go very far with that housing market. Maybe move this position to North...

Are you using the correct version of JetCompact? I think the link I sent you was for 2000 here is one for 2003 and Access xp http://support.microsoft.com/kb/295334

have you tried the Jet Compact Utility http://support.microsoft.com/default.aspx?scid=kb;EN-US;273956    Sometimes it works.  I have not see any freeware software, most are shareware around $150. Whats you data worth? Here is a...

I completely agree and have been waiting for almost 5 yrs for Sun to fix the Java components in Netscape 7.