|
try this
alter table customer drop constraintname
constraintname is the name of the primary key constraint
|
|
|
|
|
I have the same problem too. What are you suppose to use.
|
|
|
|
|
Hi
What is the best version of sql server 2008 for my needs
1. all graphics function for make tables and query and so on...
2. database of over 2 million records
3. 30-40 users that work on the database
is the express edition fit for me ?
thank's in advance
|
|
|
|
|
Hi,
IIRC SQL Server Express is limited to 4GB of data.
Luc Pattyn [Forum Guidelines] [My Articles]
- before you ask a question here, search CodeProject, then Google
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get
- use the code block button (PRE tags) to preserve formatting when showing multi-line code snippets
|
|
|
|
|
I have an application I will call App1 which the customer access it's own database in an instance of SQL server which we have over 200 identically customer databases (identical schemas). However, we use a single login via web services that has admin rights over the entire database. It is the same for all customer databases. I want to reduce risk by lowering rights. APP1 only accesses the customer database via stored procedures. We also have several functions that we use which are called in the stored procedures. We do not use any views. We also created an ad hoc reporting app that I will call App2. App2 performs SELECT queries directly from the database tables. We do not update tables from App2. What is the simplest way to handle this. I would assume a role (I believe that would to be an application role) at the database level with execute permissions for App1. For App2, it would be the same except it would be SELECT ONLY, I would not allow it to have execute ability on the stored procedures. I think this is the best way but I would like some feedback before I go ahead and propose this change.
|
|
|
|
|
In reference to app2 the reporting app, we use procs to service 98% of our reporting requirements. ALL reporting procs are prefixed with rs and there is a standard SQL user with execute assigned to only those procs and select on all tables and views. We have some VERY complex reporting requirements.
We then have a script that goes through the database and assigns the correct rights for reportuser which the report dev runs whenever he publishes a new report.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
hai all,
In my database table i have a data in a table like below
X 102
Y 101
Z 123
X 142
Y 245
Z 625
X 234
Y 432
Z 111
How can i get the data from table kike below.
X Y Z
102 101 123
142 245 625
234 432 111
Please help me how to write select query for below.
Thanks in advance,
cheers,
sekhar
modified on Saturday, April 4, 2009 7:26 AM
|
|
|
|
|
Hi,
You need to use SQL 2005's PIVOT statement. Have a look at examples here[^].
Regards,
Syed Mehroz Alam.
My Blog
My Articles
Computers are incredibly fast, accurate, and stupid; humans are incredibly slow, inaccurate and brilliant; together they are powerful beyond imagination. - Albert Einstein
|
|
|
|
|
Hi,
I have a cte query that returns a hierarcy of content and subcontent shown below:
Id PId Name
----------------------------
1 0 HomePage
2 1 AboutUs
5 2 WhatWeDo
7 5 Alternate
8 5 Another one
10 8 Second
11 8 third
4 1 ContactUs
6 4 TotalItems
3 0 Testing
I want to take this result set and generate a Xml like the one shown below:
<ContentItems>
<Content Id='1' PId='0'>
<Name>HomePage</Name>
<Content Id='2' PId='1'>
<Name>AboutUs</Name>
</Content>
</Content>
....
</ContentItems>
I have tried using the FOR XML but it it seems to just put all the nodes under <contentitems> node. Any suggestions is appreciated. Thanks.
|
|
|
|
|
How to get the time difference between two dates in SQl?
|
|
|
|
|
|
Hi!
I have a database (master.mdb), and I want link 3 table (first, second, third) from a password protected (abc1234) database (secondary.mdb).
How could I link with VBA?
Thank you
|
|
|
|
|
Have a look into the information this site can supply Connectionstrings[^]
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hi all,
I am getting Error: Truncated incorrect time value.
while working with TIMEDIFF function in mysql.
pls help resolve this error.
Thanks inadvance.
No Defeat Is Final Until You Stop Trying!.......
|
|
|
|
|
hi,
i got the solution,
there is a max limitation for time value for TIMEDIFF function that's why its throwing error.
anyways thanks
No Defeat Is Final Until You Stop Trying!.......
|
|
|
|
|
SQL> create or replace procedure create_tablename(name varchar2) is
2
3 str varchar2(20) := name;
4 v_str varchar2(255);
5 Begin
6 v_str := 'Create table '||'AFR'||'_'||str||'(rollno NUMBER(2),name varchar2(10))';
7 Execute immediate v_str;
8 End;
9 /
Procedure created.
SQL> variable abc varchar2(20)
SQL> exec create_tablename(:abc);
BEGIN create_tablename(:abc); END;
*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "SCOTT.CREATE_TABLENAME", line 7
ORA-06512: at line 1
hey can any1 suggest what exactly the problem is?
The above code is for creating the table dynamically in Oracle 9i....
|
|
|
|
|
That's as close to a clear text message as you get from Oracle.
ORA-01031 means you're not having the privilege to do what you just tried to do.
ORA-06512 tell you where the error happened.
So it means that your user is not having Create Table rights in tablespace Scott.
|
|
|
|
|
Technically it's the SCOTT schema, not necessarily a SCOTT tablespace.
Scott (coincidentally)
|
|
|
|
|
|
Firstly thnx for your quick reply. And could you suggest a way in which the above error could be corrected. Even tried logging in as user:system. But it did not help. Same error.
|
|
|
|
|
Does Scott have 'create table' privileges?
|
|
|
|
|
Login with sys and whatever password you have, and set the correct correct privileges for user scott.
Or create a new user with the proper access rights for schema scott.
Or (this is from memory and might not be correct) add "SQLNET.AUTHENTICATION_SERVICES = (NTS)" into sqlnet.ora to be able to use NT security
|
|
|
|
|
I suppose it is unkind to laugh at people who are fumbling around with problems in technologies they do not understand, but this is a funny little exchange.
First: SQLNET.AUTHENTICATION_SERVICES has nothing to do with the person's problem.
Second: The person's error is quite self-explanatory.
Third: One wonders why he (or his helpers here) did not just Google the error message. The solution would have been quickly found.
The problem is that the person is either 1) trying to create a table in his own schema without having the CREATE TABLE privilege, or 2) trying to create a table in another schema without the CREATE ANY TABLE privilege. In addition, the user's account must have a quota on its default tablespace or have the UNLIMITED TABLESPACE privilege without one of which the ORA-01536 error will occur.
Kind regards,
Russ
|
|
|
|
|
'34523@#$@%^@^'
how can i find that above value contain special character in sqlserver 2005
|
|
|
|
|
in sql server 2000 you can use PATINDEX which will return the index of the given pattern, or you could use LIKE. If 2k5 has support for Regular Expressions you could use those, but i havent used 2k5 yet. We're going to upgrade to 2k8 shortly though.
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|