Install Path

I need to be able to look up the install path for sql from within a DTS
package. The registry reading stored procs have been deleted for 'security'
but I need to make sure that SQL Agent has full access to the directory for a
temp file. It would be ideal to get the install path and use that. This DTS
will be installed an mulitple instances so I would like to automate this.
Thom,
Maybe REGEDT32 and look for SQLPath?
HTH
Jerry
"Thom" <Thom@.discussions.microsoft.com> wrote in message
news:7A48EA99-65D1-4ECF-B996-84191EF2DA64@.microsoft.com...
>I need to be able to look up the install path for sql from within a DTS
> package. The registry reading stored procs have been deleted for
> 'security'
> but I need to make sure that SQL Agent has full access to the directory
> for a
> temp file. It would be ideal to get the install path and use that. This
> DTS
> will be installed an mulitple instances so I would like to automate this.

Install Path

I need to be able to look up the install path for sql from within a DTS
package. The registry reading stored procs have been deleted for 'security'
but I need to make sure that SQL Agent has full access to the directory for a
temp file. It would be ideal to get the install path and use that. This DTS
will be installed an mulitple instances so I would like to automate this.Thom,
Maybe REGEDT32 and look for SQLPath?
HTH
Jerry
"Thom" <Thom@.discussions.microsoft.com> wrote in message
news:7A48EA99-65D1-4ECF-B996-84191EF2DA64@.microsoft.com...
>I need to be able to look up the install path for sql from within a DTS
> package. The registry reading stored procs have been deleted for
> 'security'
> but I need to make sure that SQL Agent has full access to the directory
> for a
> temp file. It would be ideal to get the install path and use that. This
> DTS
> will be installed an mulitple instances so I would like to automate this.

Install Path

I need to be able to look up the install path for sql from within a DTS
package. The registry reading stored procs have been deleted for 'security'
but I need to make sure that SQL Agent has full access to the directory for
a
temp file. It would be ideal to get the install path and use that. This DT
S
will be installed an mulitple instances so I would like to automate this.Thom,
Maybe REGEDT32 and look for SQLPath?
HTH
Jerry
"Thom" <Thom@.discussions.microsoft.com> wrote in message
news:7A48EA99-65D1-4ECF-B996-84191EF2DA64@.microsoft.com...
>I need to be able to look up the install path for sql from within a DTS
> package. The registry reading stored procs have been deleted for
> 'security'
> but I need to make sure that SQL Agent has full access to the directory
> for a
> temp file. It would be ideal to get the install path and use that. This
> DTS
> will be installed an mulitple instances so I would like to automate this.sql

install of express 200 advanced sp1 fails

Had intial release installed; deleted it and associated software, and downloaded advanced, sp1 and mgmt. studio sp1.

Go to install and get just warnings(2-IIS and hardware);install goes on

then fails; look at log and it says my system doesn't meet minimum

hardware requirements.

Look at hardware requirements on readme and at MS and my system DOES

meet 'minumum reuquirements'; he only thing close is the 512 mb minimum

memory which is what my system has, 512mb memory.

1.7 P4, 30 gig of hard drive space,.net2.0,win2k with SP4,etc..

Anyone know what a workaround is or is this a 'bug'?

Take a looks at the setup logs (C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG) for starters. See if there is additional information available there.

Regards,

Mike Wachal
SQL Express team

Inserting NULL when foreign key gets deleted.

I have a couple of tables in my database (SQL server 2000)
1. Student -- Columns are as
"StudentID" -- INT
"StudentName" -- NVARCHAR
"DepartmentID" -- INT
2. Department -- Columns are as
"DepartmentID" -- INT
"DepartmentName" -- NVARCHAR
So in the table "Student", the field "DepartmentID" is a foreign key. Now
what I need to do is that when I delete a row in the "Department" table, the
n
the rows in "Student" table where the to be deleted "Department ID" occurs
must *not* get deleted. Instead NULL should be inserted there.
Can this be achieved through database schema? Or is it something that needs
to be done through triggers?
A.
Locate me in the blogosphere: http://spaces.msn.com/aayushpuriIn 2005, you can define SET DEFAULT and SET NULL for a foreign key reference
(and of course CASCADE
and restrict). In 200, you need to write code for this(trigger, for example)
.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Aayush Puri" <aayushpuri @. h o t m a i l . c o m> wrote in message
news:0F995DF3-EFED-475B-9F22-E96302A58F0B@.microsoft.com...
>I have a couple of tables in my database (SQL server 2000)
> 1. Student -- Columns are as
> "StudentID" -- INT
> "StudentName" -- NVARCHAR
> "DepartmentID" -- INT
> 2. Department -- Columns are as
> "DepartmentID" -- INT
> "DepartmentName" -- NVARCHAR
> So in the table "Student", the field "DepartmentID" is a foreign key. Now
> what I need to do is that when I delete a row in the "Department" table, t
hen
> the rows in "Student" table where the to be deleted "Department ID" occurs
> must *not* get deleted. Instead NULL should be inserted there.
> Can this be achieved through database schema? Or is it something that need
s
> to be done through triggers?
> A.
> --
> Locate me in the blogosphere: http://spaces.msn.com/aayushpuri|||Thanks a lot Tibor for the quick reply. In the meanwhile I also searched a
bit more for the solution to my problem. I got to this article on MSDN -
http://msdn.microsoft.com/library/d...fintegrity.asp.
It explains as to how to implement the "ON DELETE INSERT NULL" functionality
as TRIGGER in SQL server 2000.
A.
Locate me in the blogosphere: http://spaces.msn.com/aayushpuri
"Tibor Karaszi" wrote:

> In 2005, you can define SET DEFAULT and SET NULL for a foreign key referen
ce (and of course CASCADE
> and restrict). In 200, you need to write code for this(trigger, for exampl
e).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Aayush Puri" <aayushpuri @. h o t m a i l . c o m> wrote in message
> news:0F995DF3-EFED-475B-9F22-E96302A58F0B@.microsoft.com...
>
>

Inserting NULL when foreign key gets deleted.

I have a couple of tables in my database (SQL server 2000)
1. Student -- Columns are as
"StudentID" -- INT
"StudentName" -- NVARCHAR
"DepartmentID" -- INT
2. Department -- Columns are as
"DepartmentID" -- INT
"DepartmentName" -- NVARCHAR
So in the table "Student", the field "DepartmentID" is a foreign key. Now
what I need to do is that when I delete a row in the "Department" table, then
the rows in "Student" table where the to be deleted "Department ID" occurs
must *not* get deleted. Instead NULL should be inserted there.
Can this be achieved through database schema? Or is it something that needs
to be done through triggers?
A.
--
Locate me in the blogosphere: http://spaces.msn.com/aayushpuriIn 2005, you can define SET DEFAULT and SET NULL for a foreign key reference (and of course CASCADE
and restrict). In 200, you need to write code for this(trigger, for example).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Aayush Puri" <aayushpuri @. h o t m a i l . c o m> wrote in message
news:0F995DF3-EFED-475B-9F22-E96302A58F0B@.microsoft.com...
>I have a couple of tables in my database (SQL server 2000)
> 1. Student -- Columns are as
> "StudentID" -- INT
> "StudentName" -- NVARCHAR
> "DepartmentID" -- INT
> 2. Department -- Columns are as
> "DepartmentID" -- INT
> "DepartmentName" -- NVARCHAR
> So in the table "Student", the field "DepartmentID" is a foreign key. Now
> what I need to do is that when I delete a row in the "Department" table, then
> the rows in "Student" table where the to be deleted "Department ID" occurs
> must *not* get deleted. Instead NULL should be inserted there.
> Can this be achieved through database schema? Or is it something that needs
> to be done through triggers?
> A.
> --
> Locate me in the blogosphere: http://spaces.msn.com/aayushpuri|||Thanks a lot Tibor for the quick reply. In the meanwhile I also searched a
bit more for the solution to my problem. I got to this article on MSDN -
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_refintegrity.asp.
It explains as to how to implement the "ON DELETE INSERT NULL" functionality
as TRIGGER in SQL server 2000.
A.
--
Locate me in the blogosphere: http://spaces.msn.com/aayushpuri
"Tibor Karaszi" wrote:
> In 2005, you can define SET DEFAULT and SET NULL for a foreign key reference (and of course CASCADE
> and restrict). In 200, you need to write code for this(trigger, for example).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Aayush Puri" <aayushpuri @. h o t m a i l . c o m> wrote in message
> news:0F995DF3-EFED-475B-9F22-E96302A58F0B@.microsoft.com...
> >I have a couple of tables in my database (SQL server 2000)
> > 1. Student -- Columns are as
> > "StudentID" -- INT
> > "StudentName" -- NVARCHAR
> > "DepartmentID" -- INT
> > 2. Department -- Columns are as
> > "DepartmentID" -- INT
> > "DepartmentName" -- NVARCHAR
> >
> > So in the table "Student", the field "DepartmentID" is a foreign key. Now
> > what I need to do is that when I delete a row in the "Department" table, then
> > the rows in "Student" table where the to be deleted "Department ID" occurs
> > must *not* get deleted. Instead NULL should be inserted there.
> > Can this be achieved through database schema? Or is it something that needs
> > to be done through triggers?
> >
> > A.
> >
> > --
> > Locate me in the blogosphere: http://spaces.msn.com/aayushpuri
>
>