Cube Manager, eh?

I looked through BOL and it didn't say if the OLAP Administrator had the same rights as a Sysadmin. I know the developer would love to have sysadmin,...

No problem. Open a DOS command prompt, in Windows it's under START:PROGRAMS:ACCESSORIES. That will give you a black box with nothing in it but

C:

That's a console window.

You might be...

Wayne,

I use it when I run bcps, and I have no problems with it. That's running it as a stored procedure.

quote:

---

Has anyone...

You may have locking issues. You can find out, if you are not running this on your production system, by starting Profiler and then running some of the SQL statements...

0 in ADO disables the timeout; there is no infinite tries. RDO had a retry property that doesn't exist in ADO.

You should run that script in a console window, not...

The timeout through VB could be controlled by the application. If you are using ADO there is a CommandTimeout property. This indicates how long to wait (in seconds) while executing...

Andy,

No problem. Where should I post it? Here or in the scripts section?

I'll also have to clean it up a bit.

quote:

---

If you...

Andy,

I have been working with this problem this week. Amazing timing. We finished an application to a client a month ago, and she doesn't know SQL Server, but decided she...

wsang,

Again, your code looks ok. What you might do is create another variable to capture the Text1.Text so that you can see what is really being passed, and then use...

wsang,

I'm not sure where your problem is. I think, because the code corrupts your database in the backup, you should first work through the backup part, to be sure that...

Is the database restore corrupted if you restore through Enterprise Manager?

Patrick Birch

I have just coded a Restore for the same reason (this actually runs in the backgound).

Your code looks right, but it seems to not like the Text1.text. Just for...

Good article. I'm not a fan of Hungarian.

Sometime down the line write an article about stored procedure naming conventions (my favorite gripe). I have developers who "automatically" name their...

bcp is the easiest. I just finished moving a large accounting database from 6.5 to 2000 - a couple of bcp scripts worked like a charm. I had to edit...

That's what I thought, but no. It's strictly a SQL Server 7 box.

Version 5.15 is probably the database engine, but I'm just not sure what it's doing running upgrade steps...