Yelena,

What you are asking is not hard.  What you can do (for example), is create roles for your users/developers in the second database, which give them *execute* permissions on the...

Yep - we are going with SQL RS - but until we've finished rewriting the reports Crystal has a (limited) life.  

BTW : SQLRS is "free" as long as you have...

I think more than anything else - it's a matter of control and good discipline.  "Best Practice" standards will tell you to stay the hell out of master databases, and...

My 2 cents worth on this point - this week I've had 2 clients who both came to grief with Norton AntiVirus on their servers.  In both cases when the...

I would be interested to know how your migration goes.  I tried a going 10 before I figured out what the issue was, and my 8.5 reports wouldn't work  -...

There is a reason for this - and appologies if I misquote someone here - but my answer is based on an overheard conversation which went something like this...

In win2000...

Hi Fred1234 - yes recreating a table with and indentity column would reseed that table to 1 - you'd have to create that table and reseed the new table...

Cheers for that - *sigh* I have a client that FOUR different collations to look after - still haven't convinced them to take the plunge yet....

Agreed all round. We've been using this model for some years years now and it has made a world of difference.

It's a moot point - but how many DBA's...

...and besides, the SQL option is just sooooo much easier to implement! Less headache factor 🙂

The costing is a very valid argument. Feature for feature you could make Oracle match SQL (or vice versa) to the point where the business wouldn't really care as...

RE truncating the Logs - if you're going to go to the effort of truncating 'em - why not just set the database to simple logging and be done with...