Diff backup Problems

Hi,
I am taking a diff backup of a read only database over a
network link but the size of the diff backup is the same
as the normal backup.
Is there any thing that I need to take in account as the
database is sometimes put to read write and then to read
only mode so need a differential
Thanks
Anup
Hi
Eventually. enough pages would have changed in the DB that the differential
is the same as a normal backup.
e.g.
If every index in clustered, and every index gets re-built, in effect the
whole DB's pages will have changed.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"ap" <anonymous@.discussions.microsoft.com> wrote in message
news:00f401c5185f$39b32a50$a601280a@.phx.gbl...
> Hi,
> I am taking a diff backup of a read only database over a
> network link but the size of the diff backup is the same
> as the normal backup.
> Is there any thing that I need to take in account as the
> database is sometimes put to read write and then to read
> only mode so need a differential
> Thanks
> Anup
|||Checked all but no such thing something has changed so
any ideas what to do ?

>--Original Message--
>Hi
>Eventually. enough pages would have changed in the DB
that the differential
>is the same as a normal backup.
>e.g.
>If every index in clustered, and every index gets re-
built, in effect the
>whole DB's pages will have changed.
>Regards
>--
>Mike Epprecht, Microsoft SQL Server MVP
>Zurich, Switzerland
>IM: mike@.epprecht.net
>MVP Program: http://www.microsoft.com/mvp
>Blog: http://www.msmvps.com/epprecht/
>"ap" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:00f401c5185f$39b32a50$a601280a@.phx.gbl...
a[vbcol=seagreen]
same[vbcol=seagreen]
the[vbcol=seagreen]
read
>
>.
>
|||Hi,
When was the last full backup taken?
I suggest that you take a latest full backup and then the differential
backup. If you still have the same question, please let us know the size of
the original full backup file vs differential backup file size.
Thanks
Yogish

Diff backup Problems

Hi,
I am taking a diff backup of a read only database over a
network link but the size of the diff backup is the same
as the normal backup.
Is there any thing that I need to take in account as the
database is sometimes put to read write and then to read
only mode so need a differential
Thanks
AnupHi
Eventually. enough pages would have changed in the DB that the differential
is the same as a normal backup.
e.g.
If every index in clustered, and every index gets re-built, in effect the
whole DB's pages will have changed.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"ap" <anonymous@.discussions.microsoft.com> wrote in message
news:00f401c5185f$39b32a50$a601280a@.phx.gbl...
> Hi,
> I am taking a diff backup of a read only database over a
> network link but the size of the diff backup is the same
> as the normal backup.
> Is there any thing that I need to take in account as the
> database is sometimes put to read write and then to read
> only mode so need a differential
> Thanks
> Anup|||Checked all but no such thing something has changed so
any ideas what to do ?

>--Original Message--
>Hi
>Eventually. enough pages would have changed in the DB
that the differential
>is the same as a normal backup.
>e.g.
>If every index in clustered, and every index gets re-
built, in effect the
>whole DB's pages will have changed.
>Regards
>--
>Mike Epprecht, Microsoft SQL Server MVP
>Zurich, Switzerland
>IM: mike@.epprecht.net
>MVP Program: http://www.microsoft.com/mvp
>Blog: http://www.msmvps.com/epprecht/
>"ap" <anonymous@.discussions.microsoft.com> wrote in
message
>news:00f401c5185f$39b32a50$a601280a@.phx.gbl...
a[vbcol=seagreen]
same[vbcol=seagreen]
the[vbcol=seagreen]
read[vbcol=seagreen]
>
>.
>|||Hi,
When was the last full backup taken?
I suggest that you take a latest full backup and then the differential
backup. If you still have the same question, please let us know the size of
the original full backup file vs differential backup file size.
Thanks
Yogish

Diff backup Problems

Hi,
I am taking a diff backup of a read only database over a
network link but the size of the diff backup is the same
as the normal backup.
Is there any thing that I need to take in account as the
database is sometimes put to read write and then to read
only mode so need a differential
Thanks
AnupHi
Eventually. enough pages would have changed in the DB that the differential
is the same as a normal backup.
e.g.
If every index in clustered, and every index gets re-built, in effect the
whole DB's pages will have changed.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"ap" <anonymous@.discussions.microsoft.com> wrote in message
news:00f401c5185f$39b32a50$a601280a@.phx.gbl...
> Hi,
> I am taking a diff backup of a read only database over a
> network link but the size of the diff backup is the same
> as the normal backup.
> Is there any thing that I need to take in account as the
> database is sometimes put to read write and then to read
> only mode so need a differential
> Thanks
> Anup|||Checked all but no such thing something has changed so
any ideas what to do ?
>--Original Message--
>Hi
>Eventually. enough pages would have changed in the DB
that the differential
>is the same as a normal backup.
>e.g.
>If every index in clustered, and every index gets re-
built, in effect the
>whole DB's pages will have changed.
>Regards
>--
>Mike Epprecht, Microsoft SQL Server MVP
>Zurich, Switzerland
>IM: mike@.epprecht.net
>MVP Program: http://www.microsoft.com/mvp
>Blog: http://www.msmvps.com/epprecht/
>"ap" <anonymous@.discussions.microsoft.com> wrote in
message
>news:00f401c5185f$39b32a50$a601280a@.phx.gbl...
>> Hi,
>> I am taking a diff backup of a read only database over
a
>> network link but the size of the diff backup is the
same
>> as the normal backup.
>> Is there any thing that I need to take in account as
the
>> database is sometimes put to read write and then to
read
>> only mode so need a differential
>> Thanks
>> Anup
>
>.
>|||Hi,
When was the last full backup taken?
I suggest that you take a latest full backup and then the differential
backup. If you still have the same question, please let us know the size of
the original full backup file vs differential backup file size.
--
Thanks
Yogishsql

Diagrams

What are these diagrams in each database used for?
If I make a link betwwen two tables in a diagram ,,does it affect the
relationships?
Why dosn't it detect the relations between the tables?
Thanks
They are a simple ERD tool for visualising the schema of your database.
Changes to relationships in a diagram will affect your schema (it will
prompt to warn you).If you don't have foreign key relationships setup then
it won't be able to automatically determine the table relations.
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Reza Alirezaei" <anonymous@.discussions.microsoft.com> wrote in message
news:e$xI1SEPEHA.1388@.TK2MSFTNGP09.phx.gbl...
> What are these diagrams in each database used for?
> If I make a link betwwen two tables in a diagram ,,does it affect the
> relationships?
> Why dosn't it detect the relations between the tables?
> Thanks
>
|||How can I setup a foreign key while I'm designing a tabel?
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:O3a59pEPEHA.252@.TK2MSFTNGP10.phx.gbl...
> They are a simple ERD tool for visualising the schema of your database.
> Changes to relationships in a diagram will affect your schema (it will
> prompt to warn you).If you don't have foreign key relationships setup then
> it won't be able to automatically determine the table relations.
> --
> HTH
> Jasper Smith (SQL Server MVP)
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
>
> "Reza Alirezaei" <anonymous@.discussions.microsoft.com> wrote in message
> news:e$xI1SEPEHA.1388@.TK2MSFTNGP09.phx.gbl...
>
|||Reza,
CREATE TABLE master_table
(
master_id INT NOT NULL PRIMARY KEY,
master_name VARCHAR(200)
)
--One way of creating a Foreign Key
CREATE TABLE child_table
(
child_id INT NOT NULL PRIMARY KEY,
master_id INT NOT NULL REFERENCES master_table(master_id),
child_name VARCHAR(200)
)
--Another way, using Alter table
ALTER TABLE [dbo].[child_tyable] ADD
FOREIGN KEY
(
[master_id]
) REFERENCES [dbo].[master_table] (
[master_id]
)
GO
You can find basic tsql syntax in BooksOnLine.
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Reza Alirezaei" <anonymous@.discussions.microsoft.com> wrote in message
news:#jDyX8EPEHA.3016@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> How can I setup a foreign key while I'm designing a tabel?
> "Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
> news:O3a59pEPEHA.252@.TK2MSFTNGP10.phx.gbl...
then
>
|||You can also drag and drop in columns in the diagram itself to visually
create your relationships however I would recomend the approcah from Dinesh
i.e. explicitly create them as part of your schema as its too easy to get
things the wrong way round using the diagram tool.
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Dinesh T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
news:uaAAHKFPEHA.3052@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Reza,
> CREATE TABLE master_table
> (
> master_id INT NOT NULL PRIMARY KEY,
> master_name VARCHAR(200)
> )
> --One way of creating a Foreign Key
> CREATE TABLE child_table
> (
> child_id INT NOT NULL PRIMARY KEY,
> master_id INT NOT NULL REFERENCES master_table(master_id),
> child_name VARCHAR(200)
> )
> --Another way, using Alter table
> ALTER TABLE [dbo].[child_tyable] ADD
> FOREIGN KEY
> (
> [master_id]
> ) REFERENCES [dbo].[master_table] (
> [master_id]
> )
> GO
> You can find basic tsql syntax in BooksOnLine.
>
> --
> Dinesh
> SQL Server MVP
> --
> --
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Reza Alirezaei" <anonymous@.discussions.microsoft.com> wrote in message
> news:#jDyX8EPEHA.3016@.tk2msftngp13.phx.gbl...
database.[vbcol=seagreen]
> then
message[vbcol=seagreen]
the
>

Diagrams

What are these diagrams in each database used for?
If I make a link betwwen two tables in a diagram ,,does it affect the
relationships'
Why dosn't it detect the relations between the tables'
ThanksThey are a simple ERD tool for visualising the schema of your database.
Changes to relationships in a diagram will affect your schema (it will
prompt to warn you).If you don't have foreign key relationships setup then
it won't be able to automatically determine the table relations.
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Reza Alirezaei" <anonymous@.discussions.microsoft.com> wrote in message
news:e$xI1SEPEHA.1388@.TK2MSFTNGP09.phx.gbl...
> What are these diagrams in each database used for?
> If I make a link betwwen two tables in a diagram ,,does it affect the
> relationships'
> Why dosn't it detect the relations between the tables'
> Thanks
>|||How can I setup a foreign key while I'm designing a tabel?
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:O3a59pEPEHA.252@.TK2MSFTNGP10.phx.gbl...
> They are a simple ERD tool for visualising the schema of your database.
> Changes to relationships in a diagram will affect your schema (it will
> prompt to warn you).If you don't have foreign key relationships setup then
> it won't be able to automatically determine the table relations.
> --
> HTH
> Jasper Smith (SQL Server MVP)
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
>
> "Reza Alirezaei" <anonymous@.discussions.microsoft.com> wrote in message
> news:e$xI1SEPEHA.1388@.TK2MSFTNGP09.phx.gbl...
> > What are these diagrams in each database used for?
> > If I make a link betwwen two tables in a diagram ,,does it affect the
> > relationships'
> > Why dosn't it detect the relations between the tables'
> >
> > Thanks
> >
> >
>|||Reza,
CREATE TABLE master_table
(
master_id INT NOT NULL PRIMARY KEY,
master_name VARCHAR(200)
)
--One way of creating a Foreign Key
CREATE TABLE child_table
(
child_id INT NOT NULL PRIMARY KEY,
master_id INT NOT NULL REFERENCES master_table(master_id),
child_name VARCHAR(200)
)
--Another way, using Alter table
ALTER TABLE [dbo].[child_tyable] ADD
FOREIGN KEY
(
[master_id]
) REFERENCES [dbo].[master_table] (
[master_id]
)
GO
You can find basic tsql syntax in BooksOnLine.
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Reza Alirezaei" <anonymous@.discussions.microsoft.com> wrote in message
news:#jDyX8EPEHA.3016@.tk2msftngp13.phx.gbl...
> How can I setup a foreign key while I'm designing a tabel?
> "Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
> news:O3a59pEPEHA.252@.TK2MSFTNGP10.phx.gbl...
> > They are a simple ERD tool for visualising the schema of your database.
> > Changes to relationships in a diagram will affect your schema (it will
> > prompt to warn you).If you don't have foreign key relationships setup
then
> > it won't be able to automatically determine the table relations.
> >
> > --
> > HTH
> >
> > Jasper Smith (SQL Server MVP)
> >
> > I support PASS - the definitive, global
> > community for SQL Server professionals -
> > http://www.sqlpass.org
> >
> >
> > "Reza Alirezaei" <anonymous@.discussions.microsoft.com> wrote in message
> > news:e$xI1SEPEHA.1388@.TK2MSFTNGP09.phx.gbl...
> > > What are these diagrams in each database used for?
> > > If I make a link betwwen two tables in a diagram ,,does it affect the
> > > relationships'
> > > Why dosn't it detect the relations between the tables'
> > >
> > > Thanks
> > >
> > >
> >
> >
>|||You can also drag and drop in columns in the diagram itself to visually
create your relationships however I would recomend the approcah from Dinesh
i.e. explicitly create them as part of your schema as its too easy to get
things the wrong way round using the diagram tool.
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Dinesh T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
news:uaAAHKFPEHA.3052@.TK2MSFTNGP09.phx.gbl...
> Reza,
> CREATE TABLE master_table
> (
> master_id INT NOT NULL PRIMARY KEY,
> master_name VARCHAR(200)
> )
> --One way of creating a Foreign Key
> CREATE TABLE child_table
> (
> child_id INT NOT NULL PRIMARY KEY,
> master_id INT NOT NULL REFERENCES master_table(master_id),
> child_name VARCHAR(200)
> )
> --Another way, using Alter table
> ALTER TABLE [dbo].[child_tyable] ADD
> FOREIGN KEY
> (
> [master_id]
> ) REFERENCES [dbo].[master_table] (
> [master_id]
> )
> GO
> You can find basic tsql syntax in BooksOnLine.
>
> --
> Dinesh
> SQL Server MVP
> --
> --
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Reza Alirezaei" <anonymous@.discussions.microsoft.com> wrote in message
> news:#jDyX8EPEHA.3016@.tk2msftngp13.phx.gbl...
> > How can I setup a foreign key while I'm designing a tabel?
> >
> > "Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
> > news:O3a59pEPEHA.252@.TK2MSFTNGP10.phx.gbl...
> > > They are a simple ERD tool for visualising the schema of your
database.
> > > Changes to relationships in a diagram will affect your schema (it will
> > > prompt to warn you).If you don't have foreign key relationships setup
> then
> > > it won't be able to automatically determine the table relations.
> > >
> > > --
> > > HTH
> > >
> > > Jasper Smith (SQL Server MVP)
> > >
> > > I support PASS - the definitive, global
> > > community for SQL Server professionals -
> > > http://www.sqlpass.org
> > >
> > >
> > > "Reza Alirezaei" <anonymous@.discussions.microsoft.com> wrote in
message
> > > news:e$xI1SEPEHA.1388@.TK2MSFTNGP09.phx.gbl...
> > > > What are these diagrams in each database used for?
> > > > If I make a link betwwen two tables in a diagram ,,does it affect
the
> > > > relationships'
> > > > Why dosn't it detect the relations between the tables'
> > > >
> > > > Thanks
> > > >
> > > >
> > >
> > >
> >
> >
>

Diagrams

What are these diagrams in each database used for?
If I make a link betwwen two tables in a diagram ,,does it affect the
relationships'
Why dosn't it detect the relations between the tables'
ThanksThey are a simple ERD tool for visualising the schema of your database.
Changes to relationships in a diagram will affect your schema (it will
prompt to warn you).If you don't have foreign key relationships setup then
it won't be able to automatically determine the table relations.
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Reza Alirezaei" <anonymous@.discussions.microsoft.com> wrote in message
news:e$xI1SEPEHA.1388@.TK2MSFTNGP09.phx.gbl...
> What are these diagrams in each database used for?
> If I make a link betwwen two tables in a diagram ,,does it affect the
> relationships'
> Why dosn't it detect the relations between the tables'
> Thanks
>|||How can I setup a foreign key while I'm designing a tabel?
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:O3a59pEPEHA.252@.TK2MSFTNGP10.phx.gbl...
> They are a simple ERD tool for visualising the schema of your database.
> Changes to relationships in a diagram will affect your schema (it will
> prompt to warn you).If you don't have foreign key relationships setup then
> it won't be able to automatically determine the table relations.
> --
> HTH
> Jasper Smith (SQL Server MVP)
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
>
> "Reza Alirezaei" <anonymous@.discussions.microsoft.com> wrote in message
> news:e$xI1SEPEHA.1388@.TK2MSFTNGP09.phx.gbl...
>|||Reza,
CREATE TABLE master_table
(
master_id INT NOT NULL PRIMARY KEY,
master_name VARCHAR(200)
)
--One way of creating a Foreign Key
CREATE TABLE child_table
(
child_id INT NOT NULL PRIMARY KEY,
master_id INT NOT NULL REFERENCES master_table(master_id),
child_name VARCHAR(200)
)
--Another way, using Alter table
ALTER TABLE [dbo].[child_tyable] ADD
FOREIGN KEY
(
[master_id]
) REFERENCES [dbo].[master_table] (
[master_id]
)
GO
You can find basic tsql syntax in BooksOnLine.
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Reza Alirezaei" <anonymous@.discussions.microsoft.com> wrote in message
news:#jDyX8EPEHA.3016@.tk2msftngp13.phx.gbl...
> How can I setup a foreign key while I'm designing a tabel?
> "Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
> news:O3a59pEPEHA.252@.TK2MSFTNGP10.phx.gbl...
then[vbcol=seagreen]
>|||You can also drag and drop in columns in the diagram itself to visually
create your relationships however I would recomend the approcah from Dinesh
i.e. explicitly create them as part of your schema as its too easy to get
things the wrong way round using the diagram tool.
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Dinesh T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
news:uaAAHKFPEHA.3052@.TK2MSFTNGP09.phx.gbl...
> Reza,
> CREATE TABLE master_table
> (
> master_id INT NOT NULL PRIMARY KEY,
> master_name VARCHAR(200)
> )
> --One way of creating a Foreign Key
> CREATE TABLE child_table
> (
> child_id INT NOT NULL PRIMARY KEY,
> master_id INT NOT NULL REFERENCES master_table(master_id),
> child_name VARCHAR(200)
> )
> --Another way, using Alter table
> ALTER TABLE [dbo].[child_tyable] ADD
> FOREIGN KEY
> (
> [master_id]
> ) REFERENCES [dbo].[master_table] (
> [master_id]
> )
> GO
> You can find basic tsql syntax in BooksOnLine.
>
> --
> Dinesh
> SQL Server MVP
> --
> --
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Reza Alirezaei" <anonymous@.discussions.microsoft.com> wrote in message
> news:#jDyX8EPEHA.3016@.tk2msftngp13.phx.gbl...
database.[vbcol=seagreen]
> then
message[vbcol=seagreen]
the[vbcol=seagreen]
>

DHCP and SQL

Hello!!
I was wondering whether this was possible.
Running a DHCP on a 2003 Server platform I want to link the DHCP database to
a SQL database. The DHCP database is in windows/system32/dhcp I believe.
The idea is to have a web interface which access the SQL database with some
PHP programming. The SQL database gets the data from the DHCP server and all
the changes made, with the webinterface, on to the SQL database is updated
on the DHCP.
Has anyone tried this before and is it possible?
Thanks,
Fernando.
This is really a windows network programming question. You might have
better luck in a different newsgroup.
Cheers,
'(' Jeff A. Stucker
\
Senior Consultant
www.rapidigm.com
"Fernando" <fernando@.microsoft.com> wrote in message
news:O7PatKe6FHA.3136@.TK2MSFTNGP09.phx.gbl...
> Hello!!
> I was wondering whether this was possible.
> Running a DHCP on a 2003 Server platform I want to link the DHCP database
> to
> a SQL database. The DHCP database is in windows/system32/dhcp I believe.
> The idea is to have a web interface which access the SQL database with
> some
> PHP programming. The SQL database gets the data from the DHCP server and
> all
> the changes made, with the webinterface, on to the SQL database is updated
> on the DHCP.
> Has anyone tried this before and is it possible?
> Thanks,
> Fernando.
>
>
|||Thanks Jeff,
I will do that.
Regards,
Fernando.
"Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
news:OPPSw%23g6FHA.564@.TK2MSFTNGP10.phx.gbl...
> This is really a windows network programming question. You might have
> better luck in a different newsgroup.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Senior Consultant
> www.rapidigm.com
> "Fernando" <fernando@.microsoft.com> wrote in message
> news:O7PatKe6FHA.3136@.TK2MSFTNGP09.phx.gbl...
>

DHCP and SQL

Hello!!
I was wondering whether this was possible.
Running a DHCP on a 2003 Server platform I want to link the DHCP database to
a SQL database. The DHCP database is in windows/system32/dhcp I believe.
The idea is to have a web interface which access the SQL database with some
PHP programming. The SQL database gets the data from the DHCP server and all
the changes made, with the webinterface, on to the SQL database is updated
on the DHCP.
Has anyone tried this before and is it possible?
Thanks,
Fernando.This is really a windows network programming question. You might have
better luck in a different newsgroup.
Cheers,
'(' Jeff A. Stucker
\
Senior Consultant
www.rapidigm.com
"Fernando" <fernando@.microsoft.com> wrote in message
news:O7PatKe6FHA.3136@.TK2MSFTNGP09.phx.gbl...
> Hello!!
> I was wondering whether this was possible.
> Running a DHCP on a 2003 Server platform I want to link the DHCP database
> to
> a SQL database. The DHCP database is in windows/system32/dhcp I believe.
> The idea is to have a web interface which access the SQL database with
> some
> php programming. The SQL database gets the data from the DHCP server and
> all
> the changes made, with the webinterface, on to the SQL database is updated
> on the DHCP.
> Has anyone tried this before and is it possible?
> Thanks,
> Fernando.
>
>|||Thanks Jeff,
I will do that.
Regards,
Fernando.
"Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
news:OPPSw%23g6FHA.564@.TK2MSFTNGP10.phx.gbl...
> This is really a windows network programming question. You might have
> better luck in a different newsgroup.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Senior Consultant
> www.rapidigm.com
> "Fernando" <fernando@.microsoft.com> wrote in message
> news:O7PatKe6FHA.3136@.TK2MSFTNGP09.phx.gbl...
>

DHCP and SQL

Hello!!
I was wondering whether this was possible.
Running a DHCP on a 2003 Server platform I want to link the DHCP database to
a SQL database. The DHCP database is in windows/system32/dhcp I believe.
The idea is to have a web interface which access the SQL database with some
PHP programming. The SQL database gets the data from the DHCP server and all
the changes made, with the webinterface, on to the SQL database is updated
on the DHCP.
Has anyone tried this before and is it possible?
Thanks,
Fernando.This is really a windows network programming question. You might have
better luck in a different newsgroup.
--
Cheers,
'(' Jeff A. Stucker
\
Senior Consultant
www.rapidigm.com
"Fernando" <fernando@.microsoft.com> wrote in message
news:O7PatKe6FHA.3136@.TK2MSFTNGP09.phx.gbl...
> Hello!!
> I was wondering whether this was possible.
> Running a DHCP on a 2003 Server platform I want to link the DHCP database
> to
> a SQL database. The DHCP database is in windows/system32/dhcp I believe.
> The idea is to have a web interface which access the SQL database with
> some
> PHP programming. The SQL database gets the data from the DHCP server and
> all
> the changes made, with the webinterface, on to the SQL database is updated
> on the DHCP.
> Has anyone tried this before and is it possible?
> Thanks,
> Fernando.
>
>|||Thanks Jeff,
I will do that.
Regards,
Fernando.
"Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
news:OPPSw%23g6FHA.564@.TK2MSFTNGP10.phx.gbl...
> This is really a windows network programming question. You might have
> better luck in a different newsgroup.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Senior Consultant
> www.rapidigm.com
> "Fernando" <fernando@.microsoft.com> wrote in message
> news:O7PatKe6FHA.3136@.TK2MSFTNGP09.phx.gbl...
>> Hello!!
>> I was wondering whether this was possible.
>> Running a DHCP on a 2003 Server platform I want to link the DHCP database
>> to
>> a SQL database. The DHCP database is in windows/system32/dhcp I believe.
>> The idea is to have a web interface which access the SQL database with
>> some
>> PHP programming. The SQL database gets the data from the DHCP server and
>> all
>> the changes made, with the webinterface, on to the SQL database is
>> updated
>> on the DHCP.
>> Has anyone tried this before and is it possible?
>> Thanks,
>> Fernando.
>>
>