How can I make SQL Server automatic generate scheme script for backup everyday?

How can I make SQL Server automatic generate scheme script for backup
everyday?Google "scptxfr.exe". It's a tool from Microsoft used in the Upgrade
process, but it'll work for this.
see
http://www.databasejournal.com/feat...10894_3401081_1
for an example.
HTH,
Stu|||Wow, so fast replied. Very thanks
"Stu" <stuart.ainsworth@.gmail.com> wrote in message
news:1133921881.553339.60870@.g43g2000cwa.googlegroups.com...
> Google "scptxfr.exe". It's a tool from Microsoft used in the Upgrade
> process, but it'll work for this.
> see
> http://www.databasejournal.com/feat...10894_3401081_1
> for an example.
> HTH,
> Stu
>sql

How can I make SQL Server 2005 automatic generate scheme script for backup everyday?

How can I make SQL Server 2005 automatic generate scheme script for backup
everyday?"ABC" <abc@.abc.com> wrote in message
news:ef5YwPOEGHA.1312@.TK2MSFTNGP09.phx.gbl...
> How can I make SQL Server 2005 automatic generate scheme script for backup
> everyday?
>
>
I believe you could use the SMO Scripter class to achieve this.
If your schema is in development I'd recommend you use a source control
program to backup the source code. Or you can use utilities like DBGhost or
RedGate SQL Compare to script the changes.
David Portas
SQL Server MVP
--

how can i insert id field automatic in table by stored procedure

i have a student table and i created a stored procedure to insert a new student in this table but student_id field wich i put it as primary key
got error because allready record has same value .
how i can know the last row's student_id value and input a new valid value in one stored procedure

thanksIf you make the Student_ID field an IDENTITY field, it will automatically increment for you.