Search results for query: *

Is users table suitable for data such as user name and password? The context is one table in SQL 2000 Server for users data (Companies) in a Website marketplace who can access to it through a user name and password. And another table in the same database for users data (personnel of our...

I have a users table with a field to register the date the user was registered for the first time, and another field to register the user’s ‘reason’ of that registration. Now I’ m considering to add a field to register drops (when the user decides not continue with us, or we decide it). To do...

Hello, I have this SP, and I want to call another SP to update some data, how can I do it in this part of the code? (in bold) USE dataBase3 GO Declare @Date As smalldatetime SET @Date = '15/09/2007' --date format dd/mm/yyyy Declare @FirstDayYear As smalldatetime SET @FirstDayYear =...

Hello, Weekly I make a database backup from Enterprise Manager (right click to databaseName and I choose the option to make a copy to a CD). But now I want also to make a copy/backup of my DTS packages, Is this possible? If so, which are the steps to do it? Thanks

Hello, I’ m trying to use an Insert script to export data from a .csv file to a database table, but I receive errors in Query Analyzer saying that the specified column names of .csv file aren’ t valid, but the column names are correct.. This is the script: Use market GO INSERT INTO...

In short I will launch a marketplace, an ASP.NET VB.NET web application that will run in my own Windows 2000 server. So that start doing things correct I am building a Windows Service to store performance counters values into the database about Server System (Processor, Memory, Network and Disk...

How can I know how many physical disks or disks drives exists in an array? I don’t understand; What does ‘a disk drive in an array’ mean? And, ‘a physical disk’? And, ‘the number of spindles in physical disk’? A hard disk of a server can contain several physical disks? I ask it because I am...

I recently downloaded SharpDevelop 1.1 in order to create a Windows Service to collect, monitor and store into SQL database performance counter values of my server. Now I am doing my first steps creating a Windows Service example, but I don’ t know how to add a timer component/control to my...

I recently downloaded SharpDevelop 1.1 in order to create a Windows Service to collect, monitor and store into SQL database performance counter values of my server. Now I am doing my first steps creating a Windows Service example, but I don’ t know how to add a timer component/control to my...

I want to store into an SQL database the performance counters values collected by PerformanceCounter object, I mean using ASP.NET VB.NET code. But I am a little confused about what kind of application I have to build, so that I can start and stop a program that will collect data, maybe monitor...

In short I will publish an ASP.NET VB.NET web application, it’ s a marketplace programmed all in line (without any IDE), and I use SQL 2000 Server as a database. Now I am searching a way, tool or technique to control web app performance when it will be running in a production server. Which kind...

When logging and reporting exceptions information, is it useful include user information such as IP address or User-agent? If so, why can be useful this information? Thanks

In order to get in which page an exception occurred, which is the best method I can use? Request.QueryString.ToString() Request.Url.AbsoluteUri Request.Path Request.Url.ToString() ... Others? I need this information in Sub Application_Error() of Global.asax and in a Try/Catch block in the...

I know that "Server.GetLastError()" returns an object of type Exception, and it is (more or less) the whole wrapped package of the last exception. While GetBaseException() returns the exception that is the root cause of one or more subsequent exceptions, so the original exception that caused the...

Hello, I want to implement a system to handle all possible errors in my ASP.NET VB application. Now, in each aspx page, I have a Try...Catch block that handles the possibility of error while a code to store user activity is executed. My plan is: Every time an error happens in those...

In my website I track and record information of all visits. When a visit is a web browser I get and store: IP address, User-agent, Browser Name, Browser Version and Url Referrer. But if a web crawler visits my website I know that I can get and store the User-agent, and the IP address. But...

I have a marketplace where registered users have its private area, and there is also a public area (very similar to a forum). To enter in the private area the user has to enter e-mail and password, and once verified that exists in the database a new session starts with an ASP.NET Session()...

Knowing that there are two kinds of cookies, permanent and in-memory, if user has cookies disabled, is it possible that user only disables one kind of cookie? For example only disables permanent cookies? Or when cookies are disabled both kind of cookies are automatically disabled? Thanks

I have an ASP.NET web app where I track user activity using cookies, and I store that activity in the database. To do so, I give two cookies to client browser, user_id (permanent cookie) and session_id (in-memory cookie), and with both cookies I handle all the necessary work to store all the...

I have a table called ‘Sessions’ where I store some information about every client that visits my website. In that table I have a column called ‘Client_cookie’ where I want to store an identifier that must be unique for every client (but not for every new row. Since a client can have many...