Hi,
I have to show particular item progress status in a report column in graphical format.
For example, if item finish state is 60% then, column should display status in progress bar or similar to that.
Is this possible?
Any help would be appreciated.
Thanks
Hi,
you either make a graph showing 60 in the scale of 100 or use any thrid party tool from dundas to show gauges (or a different object)
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
sqlI have a database table. I need to set a particular data field to allow for Auto Incrementing. Basically I need to set up the initial integer value to start at. Then to specify the amount to increment by.
What I have done so far is to right click on the field name in SQL Server 2005. Then, on the pop-up menu I select the menu option for properties.
When the properties are displayed I see some fields listed in dark grey but I am not able to edit these fields. In other words, if I try to type text in this field, nothing happens. The fields I am talking about are:
Identity Increment
Identity Seed
Is Identity
Does anyone know what the problem is? What do I have to do to edit these fields.
Check if you have the necessary permissions.|||You can not change the properties directly in the Column Properties window, instead, you can right click the column and choose 'Modify'. Enjoy it
For working with linked servers , Mr. Hills had replied like , one can
not see the login rights etc if the particular user is not in the
admin role in the Enter prise manager.
Since the E.Manager is a open book so that any one can access any
database , Do you explain me When the sql server E.manager ks the
user's login and password .
With thanks
RAGHUWhen you register a server in EM you specify an authentication mode.
If you choose Windows Authentication then the login information is taken
from your Windows domain login - you will have access only to the databases
to which your login has been granted permissions.
If you choose SQL Server Authentication then you can opt either to save the
login name and password in the registry or to prompt for a login name each
time you try to connect to the server in EM. Your level of access is
determined by the SQL Server login name supplied.
For maximum security use Windows Authentication or set the option to prompt
for a login name each time you connect. If you choose Windows Authentication
then also password protect your screen saver so that your PC is secure when
you are away.
Does that answer your question?
--
David Portas
----
Please reply only to the newsgroup
--
hi,
I need to do a security setup in SQL server 2000. the scenario is as follows:
In a team, only one person(Team Leader) should access the particular DB (through Enterprise Manager and rest of the persons in the Team(developers) should access through code.
How to do this.
Thanks and Regards
Sridhar, not sure what you mean by "through code"... executing code in an app? or maintaining proc/trigger code on a database? You're trying to restirct WHAT groups can do, not necesarily thru what tool? (because if a developer has permission to update tables, they can get in thru EM)... In SQL 2005 SP2, you can put a SERVER TRIGGER on LOGONS and probably not allow certain logons in thru certain application names that way.. What type of access are you talking about? Bruce|||In SQL server 2005 we introduced a new feature that hopefully will help to solve your scenario: digital signatures in SQL Modules.
The general idea is to allow certain permissions only when the call comes directly from a signed module (SP, user defined function, etc.). I strongly recommend reading the following resources:
· BOL
o Understanding Execution Context:http://msdn2.microsoft.com/en-us/library/ms187096.aspx
o Module Signing: http://msdn2.microsoft.com/en-us/library/ms345102.aspx
o ADD SIGNATURE: http://msdn2.microsoft.com/en-us/library/ms181700.aspx
· Laurentiu Cristofor’s Blog:
o http://blogs.msdn.com/lcris/archive/2005/06/15/429631.aspx
o http://blogs.msdn.com/lcris/archive/tags/SQL+Server+-+cryptography/default.aspx?p=2
· Raul Garcia’s blog:
o http://blogs.msdn.com/raulga/archive/tags/SQL+Server+Signatures/default.aspx
Feel free to ask us any question or feedback on this topic. We will be glad to help.
Thanks,
-Raul Garcia
SDE/T
SQL Server Engine
|||hi bruce,
1. In my setup there are some developers for a project accessing the database through th EM and once the same once the same project implemented in production level, it should not get accessed through the EM (either they may only view the tables not edit/delete). how to do this?
2. What permission should be given to database so that throgh the application it can be edited/deleted/updated and not through the EM.
|||I strongly recommend reading the following thread. Here we discuss in detail about application security, and from your last post, I think it is something similar to what you are asking for:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=775364&SiteID=1
Please let us know if this information was useful.
Thanks,
-Raul Garcia
SDE/T
SQL Server Engine
