.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

DB Restriction

Posted By:      Posted Date: September 27, 2010    Points: 0   Category :Sql Server
 
How can i restrict users from Droping and Creating new databases on server is there any way i can make a procedure or trigger or any policy to prevent users from Droping and Creating databases @server


View Complete Post


More Related Resource Links

IP Address Blocking or Restriction in SQL Server

  
"is it possible to block connections to SQL Server based on IP address". As far as now there is no official way in SQL Server to block the connections in SQL Server based on IP address. However this can be done from the OS end, we have the following three options available, refer HERE for more.


.Firewall
.IPSec
.RRAS IP Filter

Process.Start - arguments length restriction to 2080 characters

  
Hi, I'm wondering why is there a limit to "The sum of the length of the arguments and the length of the full path to the process " to 2080? I see that the documentation says that a Win32Exception is thrown if this exceeds 2080 characters. Can someone please explain to me this limit? I'm trying to start a process and I have a lot of arguments to pass, and of course ... I exceed the limit of 2080.   Thanks, Ionut.

Calendar Date Picker Restriction

  
Is there a way to restrict the user to selecting only the first day of a month from the Date Picker calendar? The database list the yearmonth column as datetime and the entries are 01/01/2010, 02/01/2010, 03/01/2010. . . to represent the month. So I need to be able to provide the calendar in the parameter panel but only let the user select the first day of a month. If I can't do this is there some way of providing an error message when/if they select another day of the month that would instruct them to select the first day of the month? Any help is greatly appreciated.

Restriction in uploading the files

  
Hi, There is Attach file link on the Newform.aspx of list to upload the files.As a part of client requirement user should be able to upload the files only from Picture Library.So in the pop up i need to display the Picture library and the corresponding files in it.Could you share your thoughts regarding this? Thanks & Regards, Sudheer

pattern restriction

  
I am validating below 2 XML with below schema with GroupOrder Value = "5" and GroupOrder Value ="" (means it should accept 1-20 or EMPTY). XML1 is validate successfully with below schema, but not successful for XML2..what need to make change in schema..please help? DECLARE @xml1 XML(test) SELECT @xml1 = '<PDI_Approval_MetaData> <TranDetails> <GroupOrder Value="5"></GroupOrder> </TranDetails> </PDI_Approval_MetaData>' DECLARE @xml2 XML(test) SELECT @xml2 = '<PDI_Approval_MetaData> <TranDetails> <GroupOrder Value=""></GroupOrder> </TranDetails> </PDI_Approval_MetaData>'   CREATE XML SCHEMA COLLECTION [dbo].[test] AS N' <xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema"> <xs:simpleType name="GroupOrder"> <xs:restriction base="xs:string"> <xs:pattern value="[1-9]"/> </xs:restriction> </xs:simpleType> <xs:element name="PDI_Approval_MetaData"> <xs:complexType> <xs:sequence> <xs:element name="TranDetails"> <xs:complexType> <xs:sequence> <xs:element name="GroupOrder"> <

pattern restriction schema

  
I validate below XML for GroupOrder value that should be between 1-9, below schema works perfect for me. but my GroupOrder value can also be EMPTY...so what need to change in below schema so that it will accecpt both EMPTY value as well as 1-9 DECLARE @x XML(test) SELECT @x = '<PDI_Approval_MetaData> <TranDetails> <GroupOrder Value=""></GroupOrder> </TranDetails> </PDI_Approval_MetaData>' CREATE XML SCHEMA COLLECTION [dbo].[test] AS N' <xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema"> <xs:simpleType name="GroupOrder"> <xs:restriction base="xs:string"> <xs:pattern value="[1-9]"/> </xs:restriction> </xs:simpleType> <xs:element name="PDI_Approval_MetaData"> <xs:complexType> <xs:sequence> <xs:element name="TranDetails"> <xs:complexType> <xs:sequence> <xs:element name="GroupOrder"> <xs:complexType> <xs:attribute name="Value" type="GroupOrder" use="optional" /> </xs:complexType> </xs:element> </xs:sequence> </xs:complexType> </xs:element&g

Top vs where restriction for paging performance

  
Which is more efficient?   select top (@count) col1 from  (select col1, row_number() OVER(ORDER BY col1) as row_num from table1) as a where row_num > @start order by row_num   select col1 from  (select col1, row_number() OVER(ORDER BY col1) as row_num from table1) as a where row_num > @start and row_num <= @start + @count order by row_num

XML for Analysis Parser; The restriction value - sql server 2005 with Excel 2010 error

  

Trying to refresh an existing pivot table that is connected to Analysis Services Sql Server 2005 database.  My excel 2010  gets the eroor:\

XML for Analysis parser:  The restriction value provided by the consumer either does not match other restrictions or refers to an unknown object.

I already tried the pivot table patch and I am still experiencing the error.  I also tried starting a new excel spreadshsst and connecting to two other sql servers of newer verions and was succesful.


Datatable and minLength restriction

  

Hi, i want to define an element which cannot be empty or with a minimum length , i was trying with datatable to insert the minLegth restriction

but it rejects it and accepts only the maxLength restriction, are there any way to resolve this?

I was thinking of regular expressions with facets but i have the same problem, datatable rejects it.

In my applications now i only read the schema and then write it to a file to see how does datatable sees the schema.

The xsd i load in the datatable is this:

 

<?xml version="1.0" standalone="yes"?>
<xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
  <xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:MainDataTable="tabella" msdata:UseCurrentLocale="true">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="tabella">
          <xs:complexType>
          &nbs

Sites User Restriction

  

i am having a sitecollection named "Test" and taking inside subsite "TestSubsite". On the "TestSubsite" i am having any Content Editor web part. and having 2-3 users of site.

Now i have to restrict users except System Account that if any user change the content of the web part then it should not reflect on the other user except only that user who change the contents . After approval of the change then it should reflect on the other users.

so please provide solution how can i do this.if using programming(workflow) then share code.


How to Get Fullscreen Plus Resolution Restriction?

  

Hi I am new to WPF, and am not sure how to do something that I thought would be simple.

I would like to create a fullscreen window that, if it gets bigger than 1024x768, gets colored bands (for example black strips in widescreen movies) along the edges, so that it remains fullscreen, but the main window does not get any bigger than 1024x768.

So far, I have managed to make the window fullscreen, but I don't know where to look to figure out the size restriction.

I would greatly appreciated it if someone could please suggest a resource where I could read up on this, or if someone has encountered this already and knows the solution any advice/code examples would be great!

Thanks!


PInvoke restriction: cannot return variants

  

Greetings,

I have written an console application that would backup some ComApplications properties using the methods available in ComAdmin.dll.

So, i have added a reference of this dll to my console application. So, this would require the dll at runtime too (i.e. while the exe is running). But, i dont want to copy this dll all time with the console exe.

So, i just thought of using DllImport to import all the required methods and start using them in my console application. But, i get this "PInvoke restriction: cannot return variants." . I understand this is an restriction and i would like to know, do we have any ways to overcome this.

Is this possible to achieve my goal using DllImport with any workarounds ?

I tried to explore the ComAdmin.dll in reflector and copy the classes and Interface code into my console application - with this, i was able to execute the first two line successfully.

   COMAdminCatalog comAdminobj = new COMAdminCatalog();
   COMAdminCatalogCollection collection = ((COMAdminCatalogCollection)comAdminobj.GetCollection("Applications"));
   collection.Populate();
   return collection;

But, it failed with system invalidoperationexception while populating the collection, without much information. Has anyone come acro

infopath form view restriction for sharepoint user/groups

  

Hi,

I would like to restrict sharepiont groups on infopath form views . I mean when they login to sharepoint site and open the form they should see their view in the form.  we have sharepoint foundation 2010. 

I have gone through following link

http://social.msdn.microsoft.com/Forums/en/sharepointinfopath/thread/25951740-8865-4421-8ef1-c850d783e674

I think this service required sharepoint server 2010. Is there any link where I can work out this on sharepoint foundation.

any help appreciated.

 

Thanks

MKditta


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend