Viewing 15 posts - 8,446 through 8,460 (of 9,253 total)
alter permissions on the table would be required or one of the built in database roles db_owner or ddl_admin. All of these provide way to many permissions just to truncate...
February 11, 2009 at 3:29 pm
tung (2/11/2009)
Support for AWE is available only in the Enterprise and Developer editions and only applies to 32-bit operating systems.
Again, we are...
February 11, 2009 at 11:20 am
kotlas7 (2/10/2009)
February 11, 2009 at 1:50 am
I use SQL developer even against SQL server databases, it offers me JDBC connectivity to SQL, Oracle, Sybase and even Access.
February 11, 2009 at 1:48 am
create a database role and assign permissions to the role, then assign the users to the role
February 10, 2009 at 5:31 pm
SQL developer can be used with Microsoft databases you just need to obtain and install the java library
February 10, 2009 at 5:29 pm
maybe you're confused. You select from a view not execute. As noeld said just grant select on the view to whatever role\user
February 10, 2009 at 2:43 pm
Gift Peddie (2/10/2009)
I have used most and Oracle's SQL developer is not as good as SQL Server Express management studio.
snigger, and you think my statement was emphatic ROTFL
February 10, 2009 at 2:38 pm
Bruce W Cassidy (2/10/2009)
[font="Verdana"]One thing to bear in mind: Oracle is far more complex to set-up and administer from my personal experience than is SQL Server.
no one could argue...
February 10, 2009 at 1:39 pm
out of interest, what are your current min and max memory settings?
how many instances of sql?
February 10, 2009 at 7:00 am
Steve
yes i read into it that he just wants to test and sanitise the actual restore processes required so if he ever has to do it for real he'll have...
February 10, 2009 at 6:10 am
hey dont get me wrong i like SQL server and as you say price\performance you cant beat it. By flexibilty i am referring to the scalability of the Oracle cluster,...
February 9, 2009 at 4:35 pm
for your user databases, yes. Either backup and restore to the 64bit server or detach\attach the database files.
February 9, 2009 at 4:14 pm
Andrew Reilly (2/5/2009)
yet when the redundanies came it was all of the most experienced staff (and highest paid presumably) that got the chop.
i've worked for 2 software houses now in...
February 9, 2009 at 3:47 pm
Oracle is by far the most powerful and flexible of the two.
In Oracle RAC the distributed cache memory is shared between the cluster nodes and this offers failover and...
February 9, 2009 at 3:42 pm
Viewing 15 posts - 8,446 through 8,460 (of 9,253 total)