how-to: needed for a security audit
System-Generated List of Users with write-access to the SQL database, showing full names and user IDs
View Complete Post
We are trying to restore a SQL Server 2005 (all the databases). We have failed with the restore for a couple of times and the vendor says that we have to ensure that all database users are logged off the database. A restore will fail if other users
try to use the database while the restore operation is in
How could this be acomplished. There is no way that we can control if any user or app access the server while we are restoring.
The problem is that when when we are restoring the databases if someone access any of them while the restore is taking place the process fails.
The question is how should the restore be performed? Is there any way to change the state of the database so that the databases can be restored?
hello.. i'm a bit stuck with my project and i hope anyone out there could lend a hand.. im completely new to asp.net so please bear with me.. =)
i have a table in ms access where i have username, password and usertype.. i wanted to use that table so that when i log in, the user with the "admin" usertype will go to the admin page while the user with the "user" usertype will go to the members page.. i can log in so the only issue is how to redirect them to their respective pages.. any help would be appreciated.. =)
I created a new database with the help of Database Configuration Assistant !
I created with the scott account
Now i'm not able to connect to the database with the connect identifier with the scott account
The error i get is.,
Plz help !
In this article, the author delves into some commonly used ways of writing data access code and looks at the effect they can have on performance.
MSDN Magazine August 2009
Using Microsoft technologies, you can insert, edit, query, and delete database entries using any e-mail client such as Hotmail, Outlook, Yahoo, or even WAP phone. While e-mail is certainly a powerful and widely used tool, it is usually not integrated with an application for performing any tasks other than sending reminders. The application scenario described here, an e-mail-based SQL update program, uses a simple data model; however, this solution will apply to any data model that you are working with. It will also eliminate the need for complex n-tier Internet applications and serves as a low maintenance solution for providing data access.
Alok Mehta and Daniel Williams
MSDN Magazine January 2002
What if you need to convert an existing Microsoft Access 97 database application into a true client-server application that is based on a SQL Server back end? If you know a little about Visual Basic and SQL Server, it's easy to make your app take advantage of the power and scalability provided by SQL Server 7.0. Using some concrete code examples, this article takes you step by step through converting the native Jet queries in your Access application into stored procedures and pass-through queries that SQL Server can use. You'll also learn how to pass on parameters when your client-server app calls these SQL Server stored procedures and queries.
MSDN Magazine June 2000
Pre- .Net Framework 4.0 supported using Oracle.DataAccess.Client, using Oracle.DataAccess.Types, System.Data.OracleClient, OracleDataReader, OracleConnection. What are the equivalents in .Net Framework 4.0? Does it require any download?
I wanted to know how to prevent more than one user from
uploading the report at a time .I am new to .net ,plss help with the
code that would be great.Details are below:
This is a Windos based
app written in c# . When User A clicks Upload option on one server
from the menu to upload the files and at the same time when User B
clicks Upload option on different server , User B should be alerted a
message saying "User A's uploading is in progress,pls wait" . How to
achieve this, plsss help with the code.. I am thinking this logic should be kept in a stored proc, How do I write that proc? plss help
Thanks in advance!
Sharepoint server 2007 and remote sql 2000 SP4 database, after ShraPoint server crash only content databases are available and intact. Trying to restore from backup fail, stsadm -o restore says that not valid backup is available on path. How to get access
to available content database using a new installation with same server name, ip address and partitions configuration. How to recover site with content databases information.
Regards, thanks for help.
I would like to know how to hide certain documents (eg. Word, Excel, PPT, PDF) in a document libraries from unauthorized users? I tried implement Target Audience, but it doesn't work. If anyone know, i really appreciate for the guidance.
p/s: If my posting is not relevnt to the thread, please kindly move it to the appropriate places. Thanks!
Hello,i have made a very simple file upload app, that i want
users to be able to upload images to a folder on my server, well
localhost for the time being here is the simple upload code...
I'm trying to put a registration page together in Visual Web Designer.
I would like to send a confirmation Email after someone is leaving his registration data and pressing the INSERT button.
The key fields in my database are: Email, Name, Surname, Address
Before I send the confirmation Email I would like to check if the email value entered in the form is realy added to the database.
Please for help in this matter. I was copy past already some C code in my page, therefore it will be fine if the code can be in C.
Again, I need help to:
- checking if record is realy added to database after pressing INSERT button
- setup the confirmation Email
Thank you in advance.
Hi. I created a web application using "Forms Authentication".
There is a folder name "uploads", and it creates subfolders as username when they register. Web application stores users' files and images under their folder ("uploads/username")
I tried to find a way to restrict users to download and upload files to their folder only and couldn't find a good one.
Then I came up with this idea that stores "web.config" file each time user registers and the web.config should look like below. Username will be changed dynamically according to username.
This method actually works but I am little worried if this is a good practice as far as performance wise. Because it'll create web.config files as many as users and there might be other holes that I don't recognize.
I appreciate any advice or better suggestion for this problem.
--------web.config in "/Root/uploads/username directory"--------------