How To Create An Admin With Some Limitations?
Aug 17, 2007
I've a SQL 2005 with a certain number of db.
Until today i was the only admin of all dbs.
Now i need to give to another admin permission to manage one specific
db (but only that).
Ho censito un utente di sql con accessi abilitati solo a quel db.
If i connect to Enterprise manager with that limited login there is a
problem: i see (only see)
all dbs, also db where this login is not autorized.
How can i work for not permitting this login to see other dbs? He
only
can see them but i
don't want because of privacy. Is it possible?
View 4 Replies
ADVERTISEMENT
Mar 12, 2001
I have no right to connect to my hosting company using MS SQL2000 client.
And I have to use stored procedure, can any body tell me is it possible to
create stored procedure ( I need is complex one with loops of if loops).
If possible please list the syntax.
View 2 Replies
View Related
May 30, 2007
Can I get ordinary users to create reports rather than admin using a web browser interface?
View 2 Replies
View Related
Jul 23, 2014
What is the needed permission to create credential except for sysadmin?
Already granted securityadmin but still user does not have permission to perform this action.
View 1 Replies
View Related
Nov 10, 2014
We have one table where we store all documents in one of the column called "Doc" with varbinary(max) data type.
We want to download those documents from sql table to windows explorer and i wrote BCP in sql 2005. And things were fine.
The format file I used there looks like this,
9.0
1
1 SQLBINARY 0 0 "" 1 Doc ""
Now we are in 2014 and when I try the same code with same format file, it hangs in the middle. So I changed the file to 12.0 instead of 9.0 but still not working.
View 0 Replies
View Related
Jun 15, 2015
in my environment I am running the SQL Server agent job.i am getting below message.
create a master key in the database or open a master key in the session before performing this operation” errorÂ
View 5 Replies
View Related
Jul 28, 2015
I have built a SQL 2014 Always on Cluster. I need to create three Availability groups and listeners in the same instance. Do I need 3 separate IP address for each listener or one IP address can be shared for all 3 Listeners ?
View 3 Replies
View Related
May 31, 2007
i have an asp.net web application that uses SQL2000 backend. any users login to the application using a proper SQL login. so each user has unique logins
One of the roles within the application is to allow the user to create new logins for the application which inturn creates a SQL login. for this i have been using the following special sp's within an application specific sp:-
EXEC sp_addlogin @strUsername, null, 'WEA_MIS', @loginlang
EXEC sp_grantdbaccess @strUsername, @strUsername
EXEC sp_addrolemember @strRole, @strUsername
EXEC sp_password NULL, @strPassword, @strUsername
the only way ican get this to run is if the user executing the sp is a member of sys admin, ideally i dont want to be giving anyone access to sys admin. i thought security admin would allow me to do the above but it doesnt. Is there any other ways or ideas to get around this problem
Cheers,
Craig
View 5 Replies
View Related
Apr 17, 2015
I have made a clean install of SQL 2014 including MDS on a server with Win Server 2012 R2.
After the installation I cant create new models because on an error saying that "Must declare the scalar variable "@Version_Id". "
I can see that the tables gets created in the MDS database but the models dont show up in the web interface.
I get the same error message when I try to deploy an old model.
View 0 Replies
View Related
Jun 9, 2014
I want to generate dynamic temp table so, from one strored procedure am getting an some feilds as shown below
CM_id,CM_Name,[Transaction_Month],[Transaction_Year],''[Invoice raised date],''[Payment Received date],''[Payout date],''[Payroll lock date]
for i want to generate table for the above feilds with datatype
View 5 Replies
View Related
Jun 10, 2014
I have created a stored procedure for retrieving column name, as shown below
CM_id, CM_Name, [Transaction_Month], [Transaction_Year], [Invoice raised date],[Payment Received date],[Payout date],[Payroll lock date]
Now I am trying to create a temporary table using the above generated coluimns from Stored Procedure with datatype.
View 3 Replies
View Related
Apr 30, 2015
Need script for below.
1)Add the user ''ADabc' to local admin group in server.
2)Create login 'ADabc' and Grant sysadmin access for ADabc
View 3 Replies
View Related
Dec 9, 2014
we have roughly 22 people connected to one database. But after a while, their applications begin to drag due to in and out communication with the server. When i check the active connections on the sql server, some times i see 157 active connections, please how to i set a timeout or connection interval close, so as reduce the heavy load being put on the server. Or how can i automatically close connections when they get higher than 50 connections.
This settings should be sql server 2008 related.
View 5 Replies
View Related
Aug 27, 2015
I want to set up a database role so that users can use sp_readerrorlog through SSMS. It does a check on membership in the securityadmin role.
I have tested it and can see you can grant execute on xp_readerrorlog but the SSMS GUI uses sp_readerrorlog.
I thought I could create a user/certificate and add the signature to sp_readerrorlog but it's not permitted (likely because it's not a normal database object).
So the other solution is to add the users to the securityadmin role but then explicitly deny alter any login (best done with a custom server role in 2012+ but otherwise just manually in 2008). I tested this out and it works, I'm not able to alter any logins or increase my own permissions, I also did a check of what's reported from fn_my_permissions(null, null) and it shows minimal permissions like I'd expect.
View 0 Replies
View Related
Feb 27, 2006
I'm new to SQL so don't laugh if this is easy to spot but I'm having trouble with a select statement but I do not think it's the syntax etc, I'm convinced it must be due to some restrictions and limitations within SQL.
Could anyone shed some light? I've been 'googling' for two days now and can't find anything, much appreciated! thanks.
SELECT a.medno_id,
tblAction.action_shortdesc,
tblClassification.class_shortdesc,
tblType.type_shortdesc,
tblUnit.unit_shortdesc,
tblSystem.system_shortdesc,
a.med_oldserial,
a.med_builddate,
tblLibrary.lib_shortdesc,
a.med_f24bookno,
a.med_f24entry,
a.med_f102bookno,
a.med_f102entry,
tblTransport.trans_shortdesc,
a.med_courierno,
tblPOC.poc_surname,
a.med_title,
a.med_notes
FROM tblMedia a
INNER JOIN tblAction ON a.action_id = tblAction.action_id
INNER JOIN tblClassification ON a.class_id = tblClassification.class_id
INNER JOIN tblType ON a.type_id = tblType.type_id
INNER JOIN tblUnit ON a.unit_id = tblUnit.unit_id
INNER JOIN tblSystem ON a.system_id = tblSystem.system_id
INNER JOIN tblLibrary ON a.lib_id = tblLibrary.lib_id
INNER JOIN tblTransport ON a.trans_id = tblTransport.trans_id
INNER JOIN tblPOC ON a.poc_id = tblPOC.poc_id
WHERE a.medno_id = 327
ORDER BY a.med_effdate
I've spaced out the query so it's easy to read
I've started the query from scratch building my SQL adding one field at a time and it works perfect until it reaches a certain number of fields, it's as if SQL has a limit to no of fields it can return/be used in the select part of the statement. Are there any limitations I should know about? or am I being an idiot and doing something I shouldn't?
Hope this makes sense, thanks!
View 3 Replies
View Related
May 11, 2006
What are the limitations of the SQL 2005 Express Management Studio tools, as opposed to the full blown 2k5 Tools (i'm not referring to the Server, just the tools). I ask because the install for the 2005 Management Studio Tools alone is 878 megs.
View 1 Replies
View Related
Feb 27, 2008
Hi.
I've been using CE 3.1 in a .NET/C# application. My knowledge of database technology is very basic, and I'm wondering how far I can take my application with CE, given its limitations, which I stumbled across when I read the following about VistaDB: http://www.vistadb.net/compare_sql_compact.asp
For right now, my application uses a CE database as a fancy log file. There are only two tables in the database -- one to hold the log information, and one to hold information about different "runs" of my application. The only time a row is ever updated is when a row in the latter table is updated (once) to indicate that that "run" has completed. Other than that, I only add and delete rows.
Right now, two different processes on the same CPU (the same CPU as the database) write rows to the database during a run of my application. They do this by accessing a singleton object, hosted in a Windows service, via .NET remoting. One of these processes also polls the database continually to read it for display purposes.
So. My questions are:
I can live with the single-user limitation, given my application. But what exactly is it about using CE that limits me to a single user? I never actually specify user information, as far as I know. Am I missing it?
Can I assume that the "single CPU supported" limitation simply means that it only runs on a 32-bit Windows machine, and that it has nothing to do with multiple databases running on different CPUs at runtime?
Why is it that the two processes in my application seem to be able to connect to my database concurrently, when this is apparently a limitation?
As I said, my knowledge of this technology is quite elemental. Forgive me. But I figure I'm in the right place to change that. :-)
Thanks.
Mike
View 1 Replies
View Related
Nov 15, 2007
I am receiving an error message while using the System.Transactions.TransactionScope class. The error message that I am receiving is "Communication with the underlying transaction manager has failed". This error seems to only appear when I have my web application one server, Server1, and my database on a second, Server2. When I run the web app on the same server as the database (i.e., web site and database on Server2), I don't receive this error. So, this leads me to believe this has something to do with MS DTC. Is there a limit to how much data MS DTC can manage for a given transaction? If so, is it configurable? When I run my code, the application fails after a certain number of steps (this is repeatable). See sample code below. When I execute the code below, the error occurs on UpdateBody2();. If I comment out UpdateBody2(), the error will now occur on UpdateBody3();, and so on. This leads me to believe that I have hit some upper limit. My code follows a pattern similar to this:using {TransactionScope scope = new TransactionScope()){ UpdateHeader(); UpdateBody1(); UpdateBody2(); UpdateBody3(); UpdateFooter();}Where each of the classes follows a pattern of:UpdateHeader(){ using (SqlConnection conn = new SqlConnection()) { conn.Open(); // Do something conn.Close(); } } Environment:ASP.NET 2.0SQL/2005 StandardWindows Server 2003 Thanks.Steve
View 3 Replies
View Related
Jun 22, 2004
I'd like to use MSDE since it's free instead of SQL Server for my database. I will be hosting a portal type site. If all goes well and my site is wildly successful are there any limitations in MSDE that I need to worry about?
For instance, I thought there was a limit to the number of connections. I thought I remember seeing 5 or 50 on the microsoft download site.
If there is a connection limit of say 10, what happens when connection 11 comes in? Does it just wait for a free connection or does it fail?
Is anyone using is as the database on a large portal site? How many users are there in total? How many connected at the same time?
I am under the assumption that it is SQL Server underneath, so I assume the performance and abilities are very good. Is this a fair assumption?
Thanks for the input
View 5 Replies
View Related
Jun 6, 2006
Hi, I was curious if anyone knew if there was a way to get around SQL Express Edition 2005's limitations to support remote connections. If I install SQL Server 2005, will there be a smooth transition between the two on my IIS 5.1 server? My database is extremely simple and only consists of a single table without any complex queries. Idealy, I would like to spend no money since I am a poor collge student doing this as a project. Suggestions?
View 9 Replies
View Related
Jan 20, 1999
Does anyone know the limitations of access in records?
CZ
View 1 Replies
View Related
May 18, 2004
I updated a varchar field fom 500 length to 800 and now nothing works. Are there limitations to how big a varchar table entry can be and if so what is the alternative?
Cheers
View 2 Replies
View Related
Aug 2, 2006
Hi all there,I'm a newbee to this forum. I've a question, is there any limitationon "IN" clause in select query.for example :"SELECT EMP_ID, EMP_NAME FROM EMPLOYEE WHERE EMP_ID IN('EMP1001','EMP1002','EMP1003', etc, etc, so on)".I've read at some documentation that there is a limitation for Columnsin a table and i.e. we can have only 1024 columns per table, is thistrue?Plz help me !!Thanx in advance.Kind Regards,Harry
View 4 Replies
View Related
Nov 29, 2006
Hi,
What are the limitations of using the automated conversion tool and how to deal with compatability issues?
Thanks
View 2 Replies
View Related
Dec 12, 2007
Is it possible someone could let me know the exact differences between the SSMS Express Edition and SSMS Standard Edition?
Just simply what you cannot do in the Express edition but can in the full edition.
Thanks
View 7 Replies
View Related
Oct 3, 2006
Hi,
I'm thinking about using the FTP task in an integration i am developing, but before i do, i need to get an idea that what i want to do is possible.
With the FTP task could i get a list of directories on the FTP server, and compare the folders with a result set returned from a SQL query. If any of the directories on the FTP site then i want to download each of the relevent directories and there contents to the local machine.
Could someone give me an idea as to if this is possible via the task, or if indeed a script task would be better?
Many thanks,
Grant
View 7 Replies
View Related
May 12, 2006
I had a question about the CPU limitations of SQL express. It says limited to 1 CPU but what if I have multiple instaces since the application is a new service and runs in it 'sown memory space how is it limited to 1 CPU? does the service use multiple processors and the queris are binded to one?
Thanks
View 4 Replies
View Related
Mar 10, 2008
With the limitation of 1Gb of ram and 1 CPU for SQL Express, does that mean we cannot load it on a server with multiple CPU's and more ram, or that we can load it and it will only use 1CPU and 1Gb of ram?
View 7 Replies
View Related
Feb 10, 2006
can sqlExpress handle 200 users all at the same time?
View 1 Replies
View Related
Jul 9, 2006
Hi,
As SQL Server XE can run on one PC maximum, does it mean that it can't support multi users??? I mean could it be installed on one server and to be used by multiple users connected to server with their PCs?
thanks in advance
View 8 Replies
View Related
Aug 31, 2006
what are the limitations in MS SQL Server Express (for a network application)?
View 1 Replies
View Related
Jun 21, 2006
I was looking around, and I found this info on SQL Server Express:The 4 GB database size limit applies only to data files and not to log
files. However, there are no limits to the number of databases that can be
attached to the server.Does this mean I can use several different databases in my website, like one separate db containing forum entries, and one with user details and related stuff?
View 4 Replies
View Related
Oct 9, 2007
Can anyone tell me if SQL 2000 has a record limitation on tables?
The table that I have is very basic. It contains 6 columns, none of which can contain more than 10 characters, but I'm already sitting at 2,500,000 records and expecting up to 20-30 million records. Can it handle it?
Thanks in advance.
View 2 Replies
View Related
