MSDE and DTS

Hi,
I have a DTS package that I would like to execute from an application
that uses MSDE as it's back end. Is it possible to 'attach' a DTS
package to an MSDE database and execute it from Say example VB.Net.
Any info will be appreciated.
Thanks,
VaughnIf you save a DTS package as VBScript, you should be able to run that
package from a .NET application.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
<vaughn.haybittle@.gmail.com> wrote in message
news:1157129984.437055.7530@.e3g2000cwe.googlegroups.com...
> Hi,
> I have a DTS package that I would like to execute from an application
> that uses MSDE as it's back end. Is it possible to 'attach' a DTS
> package to an MSDE database and execute it from Say example VB.Net.
> Any info will be appreciated.
> Thanks,
> Vaughn
>

MSDE and DTS

Hi,
I have a DTS package that I would like to execute from an application
that uses MSDE as it's back end. Is it possible to 'attach' a DTS
package to an MSDE database and execute it from Say example VB.Net.
Any info will be appreciated.
Thanks,
VaughnIf you save a DTS package as VBScript, you should be able to run that
package from a .NET application.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
<vaughn.haybittle@.gmail.com> wrote in message
news:1157129984.437055.7530@.e3g2000cwe.googlegroups.com...
> Hi,
> I have a DTS package that I would like to execute from an application
> that uses MSDE as it's back end. Is it possible to 'attach' a DTS
> package to an MSDE database and execute it from Say example VB.Net.
> Any info will be appreciated.
> Thanks,
> Vaughn
>sql

Msde 2000

Hi folks!

Ive got here a Windows 2000 Professional PC and want to install the MSDE 2000 (incl. SP3) Desktop Server.

But when i execute the setup.exe the following Error Message will return:

http://www.dorst.de/sql.jpg

Here is the setup.ini

[Options]
TARGETDIR="C:\Programme\MSDE2000"
DATADIR="C:\Programme\MSDE2000\Daten"
SAPWD="*****"
SECURITYMODE=SQL
DISABLENETWORKPROTOCOLS=0

Can anyone help?

THX !!!!!

Bye
CdRNoone knows why i cant install?|||Where did you get the the MDSE CD from? In seems that it may be corrupt.

I don't recall any internet calls during any installation I have performed. The fact that the website called s in Germany makes me wonder about the validity of the installation CD.

Be careful that it isn't corrupting your system.

Is there a reason that you are installing the German version?
("C:\Programme" as opposed to "C:\Program Files")|||The MSDE is included in a Program CD of Microsoft, but i tried to download it and install the MSDE... nothing change.

"C:\Programme" <- Thats the Standard-Programm-Dir :)

thx 4 help!

Bye

MSDE

how to execute queries like query analiser or how can i see records
The SQL Server 2000 Desktop Engine does not include graphical management
tools. You can manage instances/run query against them with the help SQL
Server 2000 graphical tools if installed with another edition of SQL Server.
or use third party tools for MSDE
http://www.betav.com/Files/Content/Tools/tools.htm
At the same time you can use command line utilities like osql.exe to run
queries against the databases.
Vishal Parkar
vgparkar@.yahoo.co.in | vgparkar@.hotmail.com
"sailal" <sailal@.discussions.microsoft.com> wrote in message
news:A8B0C900-C642-412F-BA8D-24F07E032DC7@.microsoft.com...
> how to execute queries like query analiser or how can i see records
|||We have a program called MSDE Manager that's free for personal use. Details
at our site.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"sailal" <sailal@.discussions.microsoft.com> wrote in message
news:A8B0C900-C642-412F-BA8D-24F07E032DC7@.microsoft.com...
> how to execute queries like query analiser or how can i see records

MSDB suspect

Hi,
What are the steps I should execute if MSDB database is showing suspect.
The conditions is we dont have a backup but the sqlserver is running.Look at the sql server logs and see what might have caused this. Look in bol for sp_resetstatus. Worst case scenario, you will have to detach the msdb and run instmsdb.sql to recreate (however, you will lose all information stored in the msdb - DTS packages, scheduled tasks, backup/restore history, replication).

Oh yes - One last step - BACKUP ... :-)