Registration Confirmation Best Practice?

May 24, 2007

Hi.

I am about to write my registration confirmation tables.
Right now I have my registration form and table "Users"
that receives input from user registration.

I want to do email confirmation of a registered account.
I was thinking of doing this by creating a table "Verify"
that is set to 0 if not verified and 1 if the user verifies
his email address.

Then I started thinking about the original registration
information. If a user "doesn't" verify, then there is all
this dormant data in the "Users" database. So, maybe
it is better to write all the registration data to the "Verify"
table and then have SQL move that data to the "Users"
table upon verification? This sounds a bit sloppy to me...
is this how the email verification of data is done or, if
not, can somebody suggest a best practice?

I thank you.

View 3 Replies


ADVERTISEMENT

Email Confirmation Steps After Registration

Jun 5, 2007

Hi.

I have set up my confirmation system to work as thus:

1) user registers
2) registration goes into a temp table with a code
3) user gets a MD5 code in his inbox
4) user clicks back
5) click-back page moves registration data from TEMP table to USER table and sends the user to the signin page.

6) ...

Now, my question is - how do I handle this final step in account
confirmation? Should the first signin act as a final confirmation of
the users account? This makes sense. Should the data in the USER table self-delete after a day if there has been no first sign-in? Should I have a column in the USER table to show if the first login has happened? How should I do this?

I am sure I could mess around with this but it would be great to
get feedback from somebody that has done this multiple times and has a sense of what the best practice is (based on large volume examples).

Your feedback is much apprecaited.

Thanks.

View 2 Replies View Related

Confirmation Please

Apr 17, 2007

I have a task to perform a new SQL Server 2005 installation at a client.
They have a system with 10 external SCSI drives, each of 72GB. They only have one database of 80GB in use at this system.

1) Userdata: I think that I will put 5 disks at SCSI channel 1, with RAID 3 or 6, with formatted space of 140GB.
2) Log: I think that I will put 3 disks at SCSI channel 2, with RAID 5, with formatted space of 70GB.
3) TempDB: I think that I will put 2 disks at SCSI channel 3, with RAID 0, with formatted space of 140GB.

System already has two built-in drives (RAID 1) for operating system, where I think I will put system databases.

I am open for suggestions and improvements!


Peter Larsson
Helsingborg, Sweden

View 19 Replies View Related

Need Confirmation

May 22, 2007

I am working with a client who has all databases, logs, tempdb and user/system databases on a single raid set.
In order to make some speed improvement, we have decided to move log files to a second raid controller card.

To accomplish this, we are thinking about taking these steps:

1) Detach database XYZ.
2) Stop database service.
3) Create a new partition on new controller card.
4) Copy old log files from I: to new K: drive.
5) Remove drive letter I: from system.
6) Change drive letter K: to I:
7) Attach database

My question is, does SQL Server recognize the log files automatically, since they are placed at same logical position (i: drive)?


Peter Larsson
Helsingborg, Sweden

View 5 Replies View Related

Confirmation Of Success

Feb 13, 2004

Just a thought.

If an issue is resolved please note that the problem has been resolved. Because there are "many ways to skin a cat" it would be helpful to anyone else with a similar problem (or someone trying to learn) what the solution was.

View 7 Replies View Related

DTS Packages- Seeking Confirmation

Apr 8, 2008

Hello all,
I have 2 primary key fields the ssn and refnum... if the data in the file is duplicated it will not import to my table rights even though i am using DTS to do my import, correct? or do I need to add an extra validator in there?

View 2 Replies View Related

MSDE Confirmation Question

Jun 7, 2005

We have a project at work that requires us to run an msde database from cd. My sup. and I disagree on if this can be done or not. We currently have an application written in asp that uses an access db. We copy the *.mdb file and all the asp files to cd and use the app. to query the db. Now, we have a client who wants the same capability only using msde. They will not allow us to install the full version of sql on there machines. No one in the dept wants to re-write this app. so we're trying to figure out if we can make it work with msde. So, My first question is, does anyone think that it is possible to just copy the *.mdf file to cd (mind you WITHOUT the *.ldf file... can't write to a cd)andMy second question is, can a sql db run without both files in any situation(mdf,ldf)? (I believe this is impossible, but would like to here it from someone with more experience)Any comments are greatly appreciatedthanks

View 1 Replies View Related

Help: Table Lock Confirmation

Mar 12, 2004

I need confirmation from you SQL Server experts out there. Please let me know if the following works. Thanks!

This stored procedure gets a value and increments by 1, but while it does this, I want to lock the table so no other processes can read the same value between the UPDATE and SELECT (of course, this may only happen in a fraction of a second, but I anticipate that we will have thousands of concurrent users). I need to manually increment this column because an identity column is not appropriate in this case.

BEGIN TRANSACTION

UPDATE forum WITH (TABLOCKX)
SET forum_last_used_msg_id = forum_last_used_msg_id + 1
WHERE forum_id = @forum_id

SELECT @new_id = forum_last_used_msg_id
FROM forum
WHERE forum_id = @forum_id

COMMIT TRANSACTION

View 10 Replies View Related

Unique Confirmation Number

Jan 23, 2008

Hi to alll of you, i'm working in a project to save cars information, when the user who adds on the new record enter all the data, this will need to be printed with a particulary number, which needs to be unique, (lets take a passport number as an example) this generated number will takes some info from the filling fields, for example:

Cars Brand: BMW (catalog number: 120)
Cars Model: 325 (catalog number: 30)
Year: 2008 (catalog number: 18)

So the unique certification number will takes from the catalog numbers * 20 / 5 for example for cars Brand
for Cars Modelo: catalog number *3 + 15


CERTIFICATE NUMBER: 480-105

I'm not sure if this is possible.

I will realy thanks for your help in this issue.
Best Regards

Gian

View 2 Replies View Related

SP Compilation Confirmation Message?

Nov 13, 2006

How can we say whether the SP is successfully compiled or not if we are compiling it on the server as a part of the TSQL script since it does not throw any message like ORACLE does.

In oracle, system will let you know whether the the procedure is successfully complied or not?

Thanks/

View 6 Replies View Related

Native Client Confirmation

Sep 9, 2007

Hi

How can I check "Native client" is present on my client? I'm trying to eliminate all the reasons my client won't run a VC++ app which access a sql server.

thanks
Z

View 4 Replies View Related

Confirmation On Script Task Behavior

May 1, 2007

Hello,



I am looking for some confirmation on a behavior of the SSIS Script Task. I have a custom script task that takes an input file, and archives it after it has been processed into the database.



When I run this package in the Visual Studio GUI, if the destination drive is full, it throws an exception telling me that there is not enough disk space. So, my questions are:



1) If this happens when the package is running through the command line, would this exception still be thrown? (I am thinking it will be)



2) Also, Do I need to explicitly fail the script task in the event handler, in order to ensure this .Net exception being thrown will cause the component to fail. (I am fairly certain I do, since this is what I had to do inside of the Visual Studio GUI, but does anyone know if this same behavior would occur when running from the command line?)



Thanks,

Chris

View 1 Replies View Related

Request For Confirmation Of SQL 2005 Optimiser Bug With Derived Table And Convert()

Jul 23, 2007

I have discovered what looks like a bug in the optimiser. I've posted it at https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=288243 but I wonder if any of you with SQL 2005 RTM, 2005 SP1 or 2008 CTP could confirm when this was introduced and whether it is still an issue?






Code Snippet

-- Bug report

-- 2007/07/19

-- Alasdair Cunningham-Smith

-- alasdair at acs-solutions dot co dot uk

set nocount on

go

-- example date in in British date format

set dateformat dmy

go



use tempdb

go



create table foo( bar varchar( 30 ) not null )

go



insert into foo( bar ) values ( 'fishy' )

insert into foo( bar ) values ( '19/07/2007' )

go



-- this works fine in all versions - only valid dates are passed to the convert function

select

convert( smalldatetime, bar, 103 ) as bardate

from

foo

where

bar like '__/__/____'

go



-- this works on SQL 2000, but fails on SQL 2005 SP2 (I've not tried other SPs of SQL 2005):

-- Msg 295, Level 16, State 3, Line 2

-- Conversion failed when converting character string to smalldatetime data type.

--

-- I believe the query is rewritten as if the derived table query contained

-- "and convert( smalldatetime, bar, 103 ) < getdate()"

-- which would expose the convert to the invalid data

select

*

from

(

select

convert( smalldatetime, bar, 103 ) as bardate

from

foo

where

bar like '__/__/____'

) as derived

where

bardate < getdate()

go



-- Workaround:

-- Use a case statement to protect the convert operator from the invalid data

select

*

from

(

select

case when bar like '__/__/____' then

convert( smalldatetime, bar, 103 )

else

null

end as bardate

from

foo

where

bar like '__/__/____'

) as derived

where

bardate < getdate()

go



drop table foo

go



The workaround I discovered is simple but ugly. I invite your comments...



alasdair.

View 5 Replies View Related

Transact SQL :: Confirmation Of UNION ALL Query For INSERT INTO Temp Table

Jul 21, 2015

I have the following UNION ALL query with SELECT INTO @tblData temp table. I would like to confirm if my query is correct.

In my first SELECT statement, I have INSERT INTO @tblData.

Do I need another INSERT INTO @tblData again in my second SELECT statement after UNION ALL?

DECLARE @BeginDate as Datetime
DECLARE @EndDate as Datetime
SET @BeginDate = '7/1/2015'
SET @EndDate = '7/13/2015'
DECLARE @tblData table

[Code] ....

View 3 Replies View Related

EM Registration

Feb 26, 2002

New to 2000, I used EM to register the SQL server and the name is in the format of Server nameSQL Server Name. In SQL Sever 7.0 I always had one name which is my preference. How do I do this. I also am having trouble using a ODBC connection and connecting to SQL Sever from EM from other computers. I am wondering if the problem is the name format?

View 3 Replies View Related

New Sql Registration

Sep 28, 2004

I have a database that runs sql 7. Most of our workstations are running on a windows 98 platform, however, a few are running windows 2000. I am trying to set up a new sql registration in enterprise manager, but the connection is failing. All of the 98 machines are logging in with a sql user name, but I was told to log the 2000 machine as a NT server. If you can understand what my problem is, could you please advise me?
thanks :confused:

View 10 Replies View Related

SQL Registration

Oct 6, 2004

Our current production DBs are on windows 2000 and SQL Server 2000.
We just installed SQL Server on new windows 2003 server.
We need to copy the DB on to this new server.
When I tried to register the new server, I am getting the error message as server does not exists or access denied.

Could some one please assist on this why I am getting this error and how to solve this.

Thanks

View 10 Replies View Related

Registration

Sep 6, 2006

I have a client that is running SQL 2005 Standard edition and they purchased 10 more Cal's, do I have to enter new registration keys, and if so where do you enter them?

Thanks in advance.

Joe

View 3 Replies View Related

Run A New Server Registration

Nov 16, 2006

Hi:
My pc is windows 2003 server and I have installed SQL SERVER 2005 EXPRESS.
From Management Studio I made a New Server Registration with Windows Authentication.
I can't run the new server, its icon appears with a white dot (instead of green when a server is running or red when the
server is stopped)
I go to server properties and click the "Test" button and I get the next message error:
Testing the registered server failed. Verify the server name, credentials, an database, an then click Test again.
An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server)
what could be wrong?
How can I run the server?
Thanks!

View 5 Replies View Related

New Sql Server Registration

Feb 12, 2008

hi,
when we go for a new sql server registration, then there are two authentication modes i.e either through windows authentication or through sql server authentication.
May anyone please tell me the default password for the windows authentication mode for user "sa".
Thanks & Regards,
Sitangshu Roy

View 1 Replies View Related

Registration Of SQL With WEB Server

Apr 27, 2005

i need to know how can i register my SQL server with WEb based SQL server
i have the address MSSQL2.MINUTESUAE.COM now how can i register my SQL Server with them.
when i m going to conect with this server it register but after that Database not show it take to much time.

View 1 Replies View Related

Server Registration

Oct 5, 1999

Hi

I'm attempting to register a new sql server through the enterprise manager and recieving the following error message: login incorrect, userid not found.

I'm using the sql server wizard to register and selecting the sql server login information as the authentication mode. The login name and password is a valid account on the Windows NT server when i view the domain information.

any responses appreciated

thanks
Todd Minifie

View 1 Replies View Related

Server Registration In Sql

Nov 1, 2004

hi ,

i am trying to upgrade from sql 7 to sql 200 .. i am doing a new clean install using the copy database wizard.

both sql 7 and sql 2000 are on different server connected on the network.

the problem i am facing is that i am not able to see the sql 7 server under the source database.

i have tried doing a new registration on sql 7 .. it does not seem to show up.

i have tried using the ip address. does not work

could you tell me how i can register the sql 7 server so that it is visible to all the other servers on the network..

thanks,

ggupta

View 3 Replies View Related

New Server Registration Help

Mar 27, 2006

Hi Guys,

I was trying to register a new server. When I start the new ser. registration wizzard I've selected a pc with the MSDE installed and when I entered all the correct passwords it doesn't register. Both pc's are the domain administrators.

I tried with windows authent. too and still the same. To be onest I was playing with this for about 2 days ;(

Both PC's are runnoing windows xp pro. I did hoewer manage to connect to the MSDE on the windows 2000 server.

Any help is appreciated.

View 2 Replies View Related

Registration Fails

Jun 30, 2004

For years I've had a server registration using sql server auth set up...now it's failing...can't be found not suthed BS...

I can still see mu other boxes in sql mode, and otyhers in mixed, and I can still see my remote boxes in Ireland and Pennysylvania...we're in NJ..

The person next to me does the same thing, had to reboot, but was fine.

I get ice in the winter...

bizzare-o world.

Any ideas?

Never seen anything like it...

I do know that our tech group has been doing some pushes lately...but I checked my settings and they seem fine..but why would I be able to see everything else but this one instance?

View 14 Replies View Related

SQL Server Registration

Aug 23, 2004

This is bizzare stuff...

Be glad if someone could have a look and comment....

I'd really would like to understand this...

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=38969

View 1 Replies View Related

Registration Problem

Aug 30, 2007

Dear All,
i've sql server 2005 server in my system. and sql 2000 client is also there.
now my problem is i was unable to register my server in sql server 2000.
but i was able to work with query analyser.
is there any way to register 2005 server ?


thank you very much

Vinod
Even you learn 1%, Learn it with 100% confidence.

View 5 Replies View Related

Server Registration

Jan 14, 2007

I want to register a new server,

 I go to Server Management Studio -> Right Click Database Engine -> New -> Server registration

Make up a server name and save

Apears the  "..sql server does not allow remote connections..."

I go to surface area configuration for services and connections, but it doenst have any components...

If you please help me...

Thanx

Best Regards

View 3 Replies View Related

Help With New Server Registration

Apr 19, 2006

I am trying for the first time to learn what to do and how to use SQLServer. I am following instructions in Books on Line to make a New Server Registration. The instructions read as follows:

Connecting to Servers




The toolbar of the Registered Servers component has buttons for the Database Engine, Analysis Services, Reporting Services, SQL Server Mobile, and Integration Services. You can register any of these server types for convenient management. Try this exercise to register the AdventureWorks database.


To register the AdventureWorks database






On the Registered Servers toolbar, click Database Engine if necessary. (It may already be selected.)


Right-click Database Engine, point to New, and then click Server Registration. The New Server Registration dialog box opens.


In the Server name text box, type the name of your SQL Server instance.


In the Registered server name box, type AdventureWorks.


On the Connection Properties tab, in the Connect to database list, select AdventureWorks, and then click Save.

I did steps 1 and 2 --- no problem. At step 3, for server name I typed MARKSDESKTOPSQLEXPRESS

At step 4 I typed: Adventureworks

At step 5 I went to Connection Properties and at the "Connect to database drop down box there were 2 choices: <default> or <browse server> (not Adventureworks). If I click on browse server, The browse server for Database window pops up but Adventureworks is not listed there either.

I did a search on my C drive and there are lots of Adventureworks files present so I must have downloaded the database OK.

Does anyone know where I go from here to connect to the Adventureworks database so I can continue with this tutorial?

Please help. Thanks

Mark

View 4 Replies View Related

Registration Of Sqlceoledb

Apr 14, 2008

Hi all.
I'm trying to connect with ADOCE 3.1 to a sdf file (SQLCE v 3.5).
I'm not able to open the connection because I think that sqlceoledb is non registered correctily or at all.
I read some post saying that it should be registered via regsvrce (for CE 5.0 in my case).
This tool is avilable in evC 4.0..I found, but I don't have it.
Is there any other way to achieve this or a place where to find the correct regsvrce(I found prevoius versions that don't work).
Where are informations stored in the registry (I mean which keys)


Below the code I use:

Dim cn as Object
Dim rs as Object

Set cn = CreateObject("ADOCE.Connection.3.1")

cn.Open "Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5;Data Source=Flashdisk est est.sdf"

Set rs = CreateObject("ADOCE.Recordset.3.1")

rs.Open "SELECT * FROM TestTable",cn,3,3
...... Thanks for any help

View 3 Replies View Related

REGISTRATION Question - SQL - Help PLEASE!

Jan 18, 2008



I purchased a SQLServer 2005 Workgroup Edition....My IT guy installed, but not sure if registration went through...As it turns out, this expensive software is NOT the right thing for my computer needs...so I am wondering...


1. Can ANYONE tell me how to check if the product key registration went through and was rec'd by Microsoft?

2. Can anyone ALSO tell me how I might be able to unregister this product key if it did, so that I can return the product, which has NEVER been used!


I've been looking and looking for answers -and not finding any! Anyone?

View 1 Replies View Related

SQL Express Registration

Mar 13, 2007

When trying to register SQLExpress, I get to the registration page, enter all required information but keep getting error that my email must be entered. It is entered. It is a valid MS Passport ID. I would like to register. What can I do to get past this apparently invalid validation?

Many TIA, jim

View 3 Replies View Related

Registration Problem

Oct 12, 2006

I tried to Register the SQL Express. I received the Email to comfirmation and verification but I don't received Any Key!



Can some one help me?



Thanks

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved