Im trying to create a setup cd using office setup wizard. I want the setup to
install my MSDE SP3 at the end of the installation. So I've placed the
following command in the setup.lst under [RunCommands]
MSDERelA\setup.exe InstanceName="TaShel" SAPWD "sa" SecurityMode="SQL
MSDERelA is a folder on my setup cd containing the MSDE files.
I can use the same command to run it from the command prompt but the command
is not running during the setup process.
If anyone could shed some light on this problem of mine.
Thanks
Dorji
hi Dorji,
Dorji wrote:
> Im trying to create a setup cd using office setup wizard. I want the
> setup to install my MSDE SP3 at the end of the installation. So I've
> placed the following command in the setup.lst under [RunCommands]
I'm not prepared about office setup wizard... try asking in the Office ng
hyerarchy...
BTW...
MSDERelA\setup.exe InstanceName="TaShel" SAPWD "sa" SecurityMode="SQL
=
MSDERelA\setup.exe InstanceName="TaShel" SAPWD="sa" SecurityMode=SQL
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
Showing posts with label wizard. Show all posts
Showing posts with label wizard. Show all posts
Friday, March 23, 2012
Friday, March 9, 2012
Run DTS from SQL server jobs..
Hi is it possible to run multiple DTS from a SQL server
job? I tried the SQL enterprise manager wizard to build a
job but it does not allow me to select a DTS job. Am I
doing anything wrong?You can schedule multiple packages to run from one job. Manually edit the
job, and add as many Operating system command steps as there are DTS
pacakges to run. You can use the dtsrunui.exe to get the proper command
line using the advanced button in the user interface. It can generate the
command line for you, and you can copy paste it into the job step.
Simon Worth
"Yaheya Quazi" <yquazi@.ucmerced.edu> wrote in message
news:5c4501c52400$71c39450$a401280a@.phx.gbl...
> Hi is it possible to run multiple DTS from a SQL server
> job? I tried the SQL enterprise manager wizard to build a
> job but it does not allow me to select a DTS job. Am I
> doing anything wrong?|||See the post a few items down titled Calling a DTS job thru a Stored
Procedure. That would allow you to specify as many jobs as you like.
"Yaheya Quazi" wrote:
> Hi is it possible to run multiple DTS from a SQL server
> job? I tried the SQL enterprise manager wizard to build a
> job but it does not allow me to select a DTS job. Am I
> doing anything wrong?
>
job? I tried the SQL enterprise manager wizard to build a
job but it does not allow me to select a DTS job. Am I
doing anything wrong?You can schedule multiple packages to run from one job. Manually edit the
job, and add as many Operating system command steps as there are DTS
pacakges to run. You can use the dtsrunui.exe to get the proper command
line using the advanced button in the user interface. It can generate the
command line for you, and you can copy paste it into the job step.
Simon Worth
"Yaheya Quazi" <yquazi@.ucmerced.edu> wrote in message
news:5c4501c52400$71c39450$a401280a@.phx.gbl...
> Hi is it possible to run multiple DTS from a SQL server
> job? I tried the SQL enterprise manager wizard to build a
> job but it does not allow me to select a DTS job. Am I
> doing anything wrong?|||See the post a few items down titled Calling a DTS job thru a Stored
Procedure. That would allow you to specify as many jobs as you like.
"Yaheya Quazi" wrote:
> Hi is it possible to run multiple DTS from a SQL server
> job? I tried the SQL enterprise manager wizard to build a
> job but it does not allow me to select a DTS job. Am I
> doing anything wrong?
>
Wednesday, March 7, 2012
Run a stored proc thru the index tuning wizard?
Is there any way to run the index tuning wizard on a stored proc, other than
copying the content of the stored proc into sql query analyzer?
I tried highlighting a sql call to the sp, and running itw on that along
with all tables in the db, but it just said it couldn't find anything to
add. And I know that is not the right answer.
Thanks in advance!
Hi Derrick
"Derrick" wrote:
> Is there any way to run the index tuning wizard on a stored proc, other than
> copying the content of the stored proc into sql query analyzer?
> I tried highlighting a sql call to the sp, and running itw on that along
> with all tables in the db, but it just said it couldn't find anything to
> add. And I know that is not the right answer.
> Thanks in advance!
>
If your stored procedure uses temporary tables then ITW will not be able to
tune it.
John
copying the content of the stored proc into sql query analyzer?
I tried highlighting a sql call to the sp, and running itw on that along
with all tables in the db, but it just said it couldn't find anything to
add. And I know that is not the right answer.
Thanks in advance!
Hi Derrick
"Derrick" wrote:
> Is there any way to run the index tuning wizard on a stored proc, other than
> copying the content of the stored proc into sql query analyzer?
> I tried highlighting a sql call to the sp, and running itw on that along
> with all tables in the db, but it just said it couldn't find anything to
> add. And I know that is not the right answer.
> Thanks in advance!
>
If your stored procedure uses temporary tables then ITW will not be able to
tune it.
John
Run a stored proc thru the index tuning wizard?
Is there any way to run the index tuning wizard on a stored proc, other than
copying the content of the stored proc into sql query analyzer?
I tried highlighting a sql call to the sp, and running itw on that along
with all tables in the db, but it just said it couldn't find anything to
add. And I know that is not the right answer.
Thanks in advance!Hi Derrick
"Derrick" wrote:
> Is there any way to run the index tuning wizard on a stored proc, other th
an
> copying the content of the stored proc into sql query analyzer?
> I tried highlighting a sql call to the sp, and running itw on that along
> with all tables in the db, but it just said it couldn't find anything to
> add. And I know that is not the right answer.
> Thanks in advance!
>
If your stored procedure uses temporary tables then ITW will not be able to
tune it.
John
copying the content of the stored proc into sql query analyzer?
I tried highlighting a sql call to the sp, and running itw on that along
with all tables in the db, but it just said it couldn't find anything to
add. And I know that is not the right answer.
Thanks in advance!Hi Derrick
"Derrick" wrote:
> Is there any way to run the index tuning wizard on a stored proc, other th
an
> copying the content of the stored proc into sql query analyzer?
> I tried highlighting a sql call to the sp, and running itw on that along
> with all tables in the db, but it just said it couldn't find anything to
> add. And I know that is not the right answer.
> Thanks in advance!
>
If your stored procedure uses temporary tables then ITW will not be able to
tune it.
John
Run a stored proc thru the index tuning wizard?
Is there any way to run the index tuning wizard on a stored proc, other than
copying the content of the stored proc into sql query analyzer?
I tried highlighting a sql call to the sp, and running itw on that along
with all tables in the db, but it just said it couldn't find anything to
add. And I know that is not the right answer.
Thanks in advance!Hi Derrick
"Derrick" wrote:
> Is there any way to run the index tuning wizard on a stored proc, other than
> copying the content of the stored proc into sql query analyzer?
> I tried highlighting a sql call to the sp, and running itw on that along
> with all tables in the db, but it just said it couldn't find anything to
> add. And I know that is not the right answer.
> Thanks in advance!
>
If your stored procedure uses temporary tables then ITW will not be able to
tune it.
John
copying the content of the stored proc into sql query analyzer?
I tried highlighting a sql call to the sp, and running itw on that along
with all tables in the db, but it just said it couldn't find anything to
add. And I know that is not the right answer.
Thanks in advance!Hi Derrick
"Derrick" wrote:
> Is there any way to run the index tuning wizard on a stored proc, other than
> copying the content of the stored proc into sql query analyzer?
> I tried highlighting a sql call to the sp, and running itw on that along
> with all tables in the db, but it just said it couldn't find anything to
> add. And I know that is not the right answer.
> Thanks in advance!
>
If your stored procedure uses temporary tables then ITW will not be able to
tune it.
John
Subscribe to:
Posts (Atom)