Viewing 12 posts - 1 through 12 (of 12 total)
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...
June 8, 2004 at 4:17 am
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...
June 8, 2004 at 4:02 am
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...
June 5, 2004 at 9:21 am
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...
June 5, 2004 at 6:22 am
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 -...
June 4, 2004 at 1:32 am
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...
June 3, 2004 at 1:40 am
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...
September 10, 2003 at 5:27 pm
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....
May 27, 2003 at 7:27 am
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...
May 20, 2003 at 6:45 am
...and besides, the SQL option is just sooooo much easier to implement! Less headache factor 🙂
May 20, 2003 at 5:15 am
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...
May 20, 2003 at 5:12 am
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...
May 6, 2003 at 4:36 am