Database Configuration Problems

I am trying to learn ASP.NET using Visual Basic Standard Edition 2003 and an MSDE database. I am having problems configuring the login. Is this a workable configuration? Are there instructions somewhere for setting up this configuration? I have no problem using Access 2003, but I would like to use MSDE.Hold everything!!! If you're just starting out, then why not learn ASP.NET 2.0 instead? Go to the Home page of this site and follow the 3 steps of "Getting Started with ASP.NET." You get a great free developement tool (Visual Web Developer Express) and download SQL Express 2005 (which replaces MSDE) too (not sure if this is part of the download... if not, google for download... it's free too). That way, you're up-to-date with the latest technology.

database compatibility between sql 2005 standard v/s sql 2005 64 bit

I am a newbie developing a web site. My local machine has sql 2005 standard edition on it. The host that I am trying to use only has sql 2005 64 bit version.

would I be able to do the use the same database between the two ( i.e. once my site is running at host, would I be able to download the database on my local machine, make changes to my site and then upload again on the hose without any glitches?). In addition, how about sql express doing the same with sql 2005 64 bit.

Thanks a lot for taking time to read the post.

get a new host lol...come to my employeer, www.hosting.com. we offer express & std 32BIT lol who only offers 64bit.

Database Backup and Backup in Database Maintenance

We are running SQL Enterprise Edition 2000 under Windows 2003 Standard
Edition server. Under Enterprise Manager, is there a difference between
the backup job setup under Databases, All Tasks, Backup Database and
Mangement, Database Management Plans. For some reasons, I am not able to
restore the backup file setup under Management, Data Management Plans.
Thanks.Hi Diane
I assume you mean the database maintenance plan rather than management plan?
If you set up a job using the backup wizard you will create a job that only
backs up the database. If you set up a maintenance plan it will set up one
or more jobs that can backup the database as well as re-index and do other
maintenance tasks on one or more databases.
If you wish to restore a database taken as part of a maintainance job, you
can us the restore wizard or the Restore T-SQL command in Query Analyser.
You may want to read "Designing a Backup and Restore Strategy" in Books
online regarding what you should have in place.
John
"Diane Walker" <ett9300@.yahoo.com> wrote in message
news:euTxi%23cYGHA.4760@.TK2MSFTNGP03.phx.gbl...
> We are running SQL Enterprise Edition 2000 under Windows 2003 Standard
> Edition server. Under Enterprise Manager, is there a difference between
> the backup job setup under Databases, All Tasks, Backup Database and
> Mangement, Database Management Plans. For some reasons, I am not able to
> restore the backup file setup under Management, Data Management Plans.
> Thanks.
>

data types help?

Which data type do I need to assign to my field to let users enter characters such as +=-_|\ etc...pretty much every single character from a standard keyboard...
thanksAny of the CHAR() related types, such as CHAR(), VARCHAR(), NCHAR(), NVARCHAR(), or TEXT should do nicely.

-PatP|||I have varchar now (on a web site with sql server as a database) but only save the letter and number for this example ab+ not the plus...

But I do have function, that I will probably have to customize,that is causing it only to save letters and numbers,

Thanks for your help once again

Data Type

What is the standard for primary key IDs as far as data type. Integer vs
Numeric?
Thanks
Are they going to be whole numbers? If so, there is little benefit to
making them numeric, unless you know you will exceed the capacity of INT (in
which case, you can use BIGINT)...
http://www.aspfaq.com/
(Reverse address to reply.)
"Niles" <Niles@.discussions.microsoft.com> wrote in message
news:609C4EC9-10C7-43F6-BB0A-D930F90B8AE7@.microsoft.com...
> What is the standard for primary key IDs as far as data type. Integer vs
> Numeric?
> Thanks
|||>> What is the standard for primary key IDs as far as data type. Integer vs[vbcol=seagreen]
There are no standards w.r.t data types for a key.
Anith
|||"Niles" <Niles@.discussions.microsoft.com> wrote in message
news:609C4EC9-10C7-43F6-BB0A-D930F90B8AE7@.microsoft.com...
> What is the standard for primary key IDs as far as data type. Integer vs
> Numeric?
What are you modelling?
Say it's cars... you'd want VIN. If it's books, ISBN.
etc.

> Thanks

Data Type

What is the standard for primary key IDs as far as data type. Integer vs
Numeric?
ThanksAre they going to be whole numbers? If so, there is little benefit to
making them numeric, unless you know you will exceed the capacity of INT (in
which case, you can use BIGINT)...
http://www.aspfaq.com/
(Reverse address to reply.)
"Niles" <Niles@.discussions.microsoft.com> wrote in message
news:609C4EC9-10C7-43F6-BB0A-D930F90B8AE7@.microsoft.com...
> What is the standard for primary key IDs as far as data type. Integer vs
> Numeric?
> Thanks|||>> What is the standard for primary key IDs as far as data type. Integer vs[vbcol=seagreen]
There are no standards w.r.t data types for a key.
Anith|||"Niles" <Niles@.discussions.microsoft.com> wrote in message
news:609C4EC9-10C7-43F6-BB0A-D930F90B8AE7@.microsoft.com...
> What is the standard for primary key IDs as far as data type. Integer vs
> Numeric?
What are you modelling?
Say it's cars... you'd want VIN. If it's books, ISBN.
etc.

> Thanks

Data Type

What is the standard for primary key IDs as far as data type. Integer vs
Numeric?
ThanksAre they going to be whole numbers? If so, there is little benefit to
making them numeric, unless you know you will exceed the capacity of INT (in
which case, you can use BIGINT)...
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Niles" <Niles@.discussions.microsoft.com> wrote in message
news:609C4EC9-10C7-43F6-BB0A-D930F90B8AE7@.microsoft.com...
> What is the standard for primary key IDs as far as data type. Integer vs
> Numeric?
> Thanks|||>> What is the standard for primary key IDs as far as data type. Integer vs
>> Numeric?
There are no standards w.r.t data types for a key.
--
Anith|||"Niles" <Niles@.discussions.microsoft.com> wrote in message
news:609C4EC9-10C7-43F6-BB0A-D930F90B8AE7@.microsoft.com...
> What is the standard for primary key IDs as far as data type. Integer vs
> Numeric?
What are you modelling?
Say it's cars... you'd want VIN. If it's books, ISBN.
etc.
> Thanks