Restrict DTS execution

Hi,
Does anyone know how to restrict the exceution of DTS packages?
The case is I've got some users which want to see the packages that are
currently created but I do not want them to run those packages. I already
know how to restrict the creation via sp_add_dtspackage.
Hi!

> Does anyone know how to restrict the exceution of DTS packages?
> The case is I've got some users which want to see the packages that are
> currently created but I do not want them to run those packages. I already
> know how to restrict the creation via sp_add_dtspackage.
I find this article very helpful:
http://www.windowsitpro.com/Article/...11/27111.html.
Dejan Sarka, SQL Server MVP
Mentor, www.SolidQualityLearning.com
Anything written in this message represents solely the point of view of the
sender.
This message does not imply endorsement from Solid Quality Learning, and it
does not represent the point of view of Solid Quality Learning or any other
person, company or institution mentioned in this message

Restrict DTS execution

Hi,
Does anyone know how to restrict the exceution of DTS packages?
The case is I've got some users which want to see the packages that are
currently created but I do not want them to run those packages. I already
know how to restrict the creation via sp_add_dtspackage.Hi!

> Does anyone know how to restrict the exceution of DTS packages?
> The case is I've got some users which want to see the packages that are
> currently created but I do not want them to run those packages. I already
> know how to restrict the creation via sp_add_dtspackage.
I find this article very helpful:
http://www.windowsitpro.com/Article...111/27111.html.
Dejan Sarka, SQL Server MVP
Mentor, www.SolidQualityLearning.com
Anything written in this message represents solely the point of view of the
sender.
This message does not imply endorsement from Solid Quality Learning, and it
does not represent the point of view of Solid Quality Learning or any other
person, company or institution mentioned in this messagesql

Restrict DTS execution

Hi,
Does anyone know how to restrict the exceution of DTS packages?
The case is I've got some users which want to see the packages that are
currently created but I do not want them to run those packages. I already
know how to restrict the creation via sp_add_dtspackage.Hi!
> Does anyone know how to restrict the exceution of DTS packages?
> The case is I've got some users which want to see the packages that are
> currently created but I do not want them to run those packages. I already
> know how to restrict the creation via sp_add_dtspackage.
I find this article very helpful:
http://www.windowsitpro.com/Article/ArticleID/27111/27111.html.
--
Dejan Sarka, SQL Server MVP
Mentor, www.SolidQualityLearning.com
Anything written in this message represents solely the point of view of the
sender.
This message does not imply endorsement from Solid Quality Learning, and it
does not represent the point of view of Solid Quality Learning or any other
person, company or institution mentioned in this message

Restoring SQL Server Data

hi. I just ran a dts that overwrote my data in my sql server 2000 database. Is it possible to still recover my old data?if you are running in full backup mode and you just ran DML statements, backup the transaction log of the database and restore the whole backup (full + evtl. differential + transaction log) with the option point -in-time recovery, stopping the restore until a specific time. if you don′t have the full backup model or no full backup, then there is no chance.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

I agree with the above answer, but if you have not been taking backups you will not be able to recover the database.

sql

Restoring DTS packages

I am receiving the following error message in restoring and saving DTS packages in SQL Server (SS 2000):

"Class not registered"

First time I have encountered this issue and will much appreciate suggestion on how to fix.

You can also try posting in the DTS forum:

http://groups.google.com/group/microsoft.public.sqlserver.dts?lnk=srg|||

Thanks for this suggestion.

I did post to the DTS forum, however no responses received

Restoring Deleted Columns

I just deleted a few columns from a database that I am in the process of
moving. I totally screwed up and didn't dts the data in the columns over to
the new one. Is there any way to restore the data?
Thanks,
Drew"Drew" <dlaing@.NOswvtc.state.va.SPAMus> wrote in message
news:uGxwwqYdEHA.3796@.TK2MSFTNGP10.phx.gbl...
> I just deleted a few columns from a database that I am in the process of
> moving. I totally screwed up and didn't dts the data in the columns over
to
> the new one. Is there any way to restore the data?
Restore from your last good backup. You have one, right?
Steve|||Got it... I just wasn't sure how to do it... I figured it out...
Thanks,
Drew
"Steve Thompson" <stevethompson@.nomail.please> wrote in message
news:%23NqhtMZdEHA.3632@.TK2MSFTNGP11.phx.gbl...
> "Drew" <dlaing@.NOswvtc.state.va.SPAMus> wrote in message
> news:uGxwwqYdEHA.3796@.TK2MSFTNGP10.phx.gbl...
over[vbcol=seagreen]
> to
> Restore from your last good backup. You have one, right?
> Steve
>

Restoring Deleted Columns

I just deleted a few columns from a database that I am in the process of
moving. I totally screwed up and didn't dts the data in the columns over to
the new one. Is there any way to restore the data?
Thanks,
Drew
"Drew" <dlaing@.NOswvtc.state.va.SPAMus> wrote in message
news:uGxwwqYdEHA.3796@.TK2MSFTNGP10.phx.gbl...
> I just deleted a few columns from a database that I am in the process of
> moving. I totally screwed up and didn't dts the data in the columns over
to
> the new one. Is there any way to restore the data?
Restore from your last good backup. You have one, right?
Steve
|||Got it... I just wasn't sure how to do it... I figured it out...
Thanks,
Drew
"Steve Thompson" <stevethompson@.nomail.please> wrote in message
news:%23NqhtMZdEHA.3632@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> "Drew" <dlaing@.NOswvtc.state.va.SPAMus> wrote in message
> news:uGxwwqYdEHA.3796@.TK2MSFTNGP10.phx.gbl...
over
> to
> Restore from your last good backup. You have one, right?
> Steve
>

Restoring Deleted Columns

I just deleted a few columns from a database that I am in the process of
moving. I totally screwed up and didn't dts the data in the columns over to
the new one. Is there any way to restore the data?
Thanks,
Drew"Drew" <dlaing@.NOswvtc.state.va.SPAMus> wrote in message
news:uGxwwqYdEHA.3796@.TK2MSFTNGP10.phx.gbl...
> I just deleted a few columns from a database that I am in the process of
> moving. I totally screwed up and didn't dts the data in the columns over
to
> the new one. Is there any way to restore the data?
Restore from your last good backup. You have one, right?
Steve|||Got it... I just wasn't sure how to do it... I figured it out...
Thanks,
Drew
"Steve Thompson" <stevethompson@.nomail.please> wrote in message
news:%23NqhtMZdEHA.3632@.TK2MSFTNGP11.phx.gbl...
> "Drew" <dlaing@.NOswvtc.state.va.SPAMus> wrote in message
> news:uGxwwqYdEHA.3796@.TK2MSFTNGP10.phx.gbl...
> > I just deleted a few columns from a database that I am in the process of
> > moving. I totally screwed up and didn't dts the data in the columns
over
> to
> > the new one. Is there any way to restore the data?
> Restore from your last good backup. You have one, right?
> Steve
>