Changing SQL Server Agent settings on the fly?

Hello all,

I have created a simple package that imports data from a flat file into a database. To run the package I'm using a SQL Server Agent Job. The location of the file is stored as a connection string in the Connection Managers tab in the SQL Server Agent Job.

Is there a way to change this connection string programmatically? If not programmatically, is there a way to change this setting right before I execute the package. I want to change the location of this file based on user input. Also, I'm executing the package using the sp_start_job stored procedure to run the job.

Thanks in advance for any advice!

-Dwayne

You could just create the entire job on the fly, they can be scripted in T-SQL.

If you want to keep the job, then you could use sp_update_jobstep to update the step command. Now I have not looked at the command for the SSIS subsystem, but I'd recommend use the CmdExec subsystem and calling DTEXEC myself, the logging is much better. Even MS recommend that approach in one of their KB's now. BTW could read it here first, illustrates why - http://wiki.sqlis.com/default.aspx/SQLISWiki/ScheduledPackages.html

Finally leave the job alone, and store the value in a table. You could manually use the Exec SQL Task to query the value, or perhaps better still use a SQL server based configuration. Have a look in Books Online about configurations, they are very useful, and I suggest you use them anyway to help manage connection details.

Changing SQL server 2000's CPU Utilization for each databases

Hi ,
Know that SQL server 2000 will be able to utilise mutiple CPUs if there are
but is it possible for me to change the settings such that each databases
will be serviced by certain CPUs ?
could anyone show me how ? and will this improve performance instead of
letting SQL server manages its own CPUS utilization
tks & rdgsThere is no way to effectively do that unless you place each db in it's own
instance and affinitize the cpus to each instance. It's almost never worth
doing something like that.
Andrew J. Kelly SQL MVP
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:1481E81C-D33C-4C20-9448-3EF3D1216285@.microsoft.com...
> Hi ,
> Know that SQL server 2000 will be able to utilise mutiple CPUs if there
> are
> but is it possible for me to change the settings such that each databases
> will be serviced by certain CPUs ?
> could anyone show me how ? and will this improve performance instead of
> letting SQL server manages its own CPUS utilization
> tks & rdgs|||Hi Andrew ,
assuming that i have multiple instances(e.g instance A , instance B) and i
have 5 CPUS. how do i get instance A to be serviced by 3 CPUS and instance B
serviced by 2 CPUS ?
actually , from my vendor , i knew that they have changed the cpu
utilization but no difference performance-wise , i am just curious how they
did it
rdgs
"Andrew J. Kelly" wrote:

> There is no way to effectively do that unless you place each db in it's ow
n
> instance and affinitize the cpus to each instance. It's almost never wort
h
> doing something like that.
> --
> Andrew J. Kelly SQL MVP
>
> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> news:1481E81C-D33C-4C20-9448-3EF3D1216285@.microsoft.com...
>
>|||maxzsim wrote:
> Hi Andrew ,
> assuming that i have multiple instances(e.g instance A , instance B)
> and i have 5 CPUS. how do i get instance A to be serviced by 3 CPUS
> and instance B serviced by 2 CPUS ?
> actually , from my vendor , i knew that they have changed the cpu
> utilization but no difference performance-wise , i am just curious
> how they did it
>
You can just check off the processors you want to use on the Processor
tab in SQL EM. Or you can use sp_configure.
David Gugick
Imceda Software
www.imceda.com|||tks , i found it at SQL EM
"David Gugick" wrote:

> maxzsim wrote:
> You can just check off the processors you want to use on the Processor
> tab in SQL EM. Or you can use sp_configure.
> --
> David Gugick
> Imceda Software
> www.imceda.com
>

Changing SQL server 2000's CPU Utilization for each databases

Hi ,
Know that SQL server 2000 will be able to utilise mutiple CPUs if there are
but is it possible for me to change the settings such that each databases
will be serviced by certain CPUs ?
could anyone show me how ? and will this improve performance instead of
letting SQL server manages its own CPUS utilization
tks & rdgsThere is no way to effectively do that unless you place each db in it's own
instance and affinitize the cpus to each instance. It's almost never worth
doing something like that.
--
Andrew J. Kelly SQL MVP
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:1481E81C-D33C-4C20-9448-3EF3D1216285@.microsoft.com...
> Hi ,
> Know that SQL server 2000 will be able to utilise mutiple CPUs if there
> are
> but is it possible for me to change the settings such that each databases
> will be serviced by certain CPUs ?
> could anyone show me how ? and will this improve performance instead of
> letting SQL server manages its own CPUS utilization
> tks & rdgs|||Hi Andrew ,
assuming that i have multiple instances(e.g instance A , instance B) and i
have 5 CPUS. how do i get instance A to be serviced by 3 CPUS and instance B
serviced by 2 CPUS ?
actually , from my vendor , i knew that they have changed the cpu
utilization but no difference performance-wise , i am just curious how they
did it
rdgs
"Andrew J. Kelly" wrote:
> There is no way to effectively do that unless you place each db in it's own
> instance and affinitize the cpus to each instance. It's almost never worth
> doing something like that.
> --
> Andrew J. Kelly SQL MVP
>
> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> news:1481E81C-D33C-4C20-9448-3EF3D1216285@.microsoft.com...
> > Hi ,
> >
> > Know that SQL server 2000 will be able to utilise mutiple CPUs if there
> > are
> > but is it possible for me to change the settings such that each databases
> > will be serviced by certain CPUs ?
> >
> > could anyone show me how ? and will this improve performance instead of
> > letting SQL server manages its own CPUS utilization
> >
> > tks & rdgs
>
>|||maxzsim wrote:
> Hi Andrew ,
> assuming that i have multiple instances(e.g instance A , instance B)
> and i have 5 CPUS. how do i get instance A to be serviced by 3 CPUS
> and instance B serviced by 2 CPUS ?
> actually , from my vendor , i knew that they have changed the cpu
> utilization but no difference performance-wise , i am just curious
> how they did it
>
You can just check off the processors you want to use on the Processor
tab in SQL EM. Or you can use sp_configure.
--
David Gugick
Imceda Software
www.imceda.com|||tks , i found it at SQL EM
"David Gugick" wrote:
> maxzsim wrote:
> > Hi Andrew ,
> >
> > assuming that i have multiple instances(e.g instance A , instance B)
> > and i have 5 CPUS. how do i get instance A to be serviced by 3 CPUS
> > and instance B serviced by 2 CPUS ?
> >
> > actually , from my vendor , i knew that they have changed the cpu
> > utilization but no difference performance-wise , i am just curious
> > how they did it
> >
> You can just check off the processors you want to use on the Processor
> tab in SQL EM. Or you can use sp_configure.
> --
> David Gugick
> Imceda Software
> www.imceda.com
>

Changing SQL server 2000's CPU Utilization for each databases

Hi ,
Know that SQL server 2000 will be able to utilise mutiple CPUs if there are
but is it possible for me to change the settings such that each databases
will be serviced by certain CPUs ?
could anyone show me how ? and will this improve performance instead of
letting SQL server manages its own CPUS utilization
tks & rdgs
There is no way to effectively do that unless you place each db in it's own
instance and affinitize the cpus to each instance. It's almost never worth
doing something like that.
Andrew J. Kelly SQL MVP
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:1481E81C-D33C-4C20-9448-3EF3D1216285@.microsoft.com...
> Hi ,
> Know that SQL server 2000 will be able to utilise mutiple CPUs if there
> are
> but is it possible for me to change the settings such that each databases
> will be serviced by certain CPUs ?
> could anyone show me how ? and will this improve performance instead of
> letting SQL server manages its own CPUS utilization
> tks & rdgs
|||Hi Andrew ,
assuming that i have multiple instances(e.g instance A , instance B) and i
have 5 CPUS. how do i get instance A to be serviced by 3 CPUS and instance B
serviced by 2 CPUS ?
actually , from my vendor , i knew that they have changed the cpu
utilization but no difference performance-wise , i am just curious how they
did it
rdgs
"Andrew J. Kelly" wrote:

> There is no way to effectively do that unless you place each db in it's own
> instance and affinitize the cpus to each instance. It's almost never worth
> doing something like that.
> --
> Andrew J. Kelly SQL MVP
>
> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> news:1481E81C-D33C-4C20-9448-3EF3D1216285@.microsoft.com...
>
>
|||maxzsim wrote:
> Hi Andrew ,
> assuming that i have multiple instances(e.g instance A , instance B)
> and i have 5 CPUS. how do i get instance A to be serviced by 3 CPUS
> and instance B serviced by 2 CPUS ?
> actually , from my vendor , i knew that they have changed the cpu
> utilization but no difference performance-wise , i am just curious
> how they did it
>
You can just check off the processors you want to use on the Processor
tab in SQL EM. Or you can use sp_configure.
David Gugick
Imceda Software
www.imceda.com
|||tks , i found it at SQL EM
"David Gugick" wrote:

> maxzsim wrote:
> You can just check off the processors you want to use on the Processor
> tab in SQL EM. Or you can use sp_configure.
> --
> David Gugick
> Imceda Software
> www.imceda.com
>

changing source path

Hello,

I moved my Report source files from C:\Documents and Settings\username\My Documents\ to C:\Inetpub\wwwroot\Apps\Src it seems my Data Source does not work. I am able to open reports but could not connect database. Is there anywhere else I need to redefine the path.

Thanks,

I am not sure what you are doing - BUT - never put your source code in inetpub <wwwroot> and on top of it the directory is probably shared!!!!!!

You are missing the entire point of the deployment mechanism of any web service and most importantly Reporting Services!

Please slow down a little with all due respect! And I do mean with ALL DUE RESPECT!

Put your source code in a secure directory - open a new project in Visual Studio change the data source in your project

Chane the Project Properties to point to your server and ensure the data sources within your project point to the same...

Data Source=YOUR SERVER NAME;Initial Catalog=YOUR DATA BASE NAME

REmove your source code from inetpub!@.!!!!!

Deploy (which does a build) to your server -- protect your source code!

Best REgards,

|||

Hi Josun,

Thank you very much for the advice. I will try to move it somewhere else. However I think the problem is not because of inetpub. Do you have any idea why I am getting that problem when I move all the files from one server to another even though with same path.

|||

Well - Maybe

Please excue my "LEO ( Thai Beer induced state )

What is going on? Why so much wory about ----

I will go back and read your original post!

Something is a-miss here!

Changing settings on a Database

We had to change the settings of both our database and transaction because
the database is growing enormously. Once we made the changes is a restart of
either the system or the services required?
--
___________________________
GiacomoWhat settings did you change?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Giacomo" <gdagostino@.vision2000.ca> wrote in message
news:8B28B334-2E45-4316-8EF9-686109B70A25@.microsoft.com...
> We had to change the settings of both our database and transaction because
> the database is growing enormously. Once we made the changes is a restart
of
> either the system or the services required?
> --
>
> ___________________________
> Giacomo|||We set the both database and transaction logs ofr % growth!
"Tibor Karaszi" wrote:

> What settings did you change?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Giacomo" <gdagostino@.vision2000.ca> wrote in message
> news:8B28B334-2E45-4316-8EF9-686109B70A25@.microsoft.com...
>|||Hi,
No need to restart the SQL Server after changing the database growth %. This
will come in to effect with out any action.
Thanks
Hari
SQL Server MVP
"Giacomo" <gdagostino@.vision2000.ca> wrote in message
news:29E91932-86CF-4494-BABF-ED911BAF42A4@.microsoft.com...[vbcol=seagreen]
> We set the both database and transaction logs ofr % growth!
> "Tibor Karaszi" wrote:
>

Changing settings on a Database

We had to change the settings of both our database and transaction because
the database is growing enormously. Once we made the changes is a restart of
either the system or the services required?
___________________________
Giacomo
What settings did you change?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Giacomo" <gdagostino@.vision2000.ca> wrote in message
news:8B28B334-2E45-4316-8EF9-686109B70A25@.microsoft.com...
> We had to change the settings of both our database and transaction because
> the database is growing enormously. Once we made the changes is a restart of
> either the system or the services required?
> --
>
> ___________________________
> Giacomo
|||We set the both database and transaction logs ofr % growth!
"Tibor Karaszi" wrote:

> What settings did you change?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Giacomo" <gdagostino@.vision2000.ca> wrote in message
> news:8B28B334-2E45-4316-8EF9-686109B70A25@.microsoft.com...
>
|||Hi,
No need to restart the SQL Server after changing the database growth %. This
will come in to effect with out any action.
Thanks
Hari
SQL Server MVP
"Giacomo" <gdagostino@.vision2000.ca> wrote in message
news:29E91932-86CF-4494-BABF-ED911BAF42A4@.microsoft.com...[vbcol=seagreen]
> We set the both database and transaction logs ofr % growth!
> "Tibor Karaszi" wrote:

Changing settings on a Database

We had to change the settings of both our database and transaction because
the database is growing enormously. Once we made the changes is a restart of
either the system or the services required?
--
___________________________
GiacomoWhat settings did you change?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Giacomo" <gdagostino@.vision2000.ca> wrote in message
news:8B28B334-2E45-4316-8EF9-686109B70A25@.microsoft.com...
> We had to change the settings of both our database and transaction because
> the database is growing enormously. Once we made the changes is a restart of
> either the system or the services required?
> --
>
> ___________________________
> Giacomo|||We set the both database and transaction logs ofr % growth!
"Tibor Karaszi" wrote:
> What settings did you change?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Giacomo" <gdagostino@.vision2000.ca> wrote in message
> news:8B28B334-2E45-4316-8EF9-686109B70A25@.microsoft.com...
> > We had to change the settings of both our database and transaction because
> > the database is growing enormously. Once we made the changes is a restart of
> > either the system or the services required?
> > --
> >
> >
> >
> > ___________________________
> > Giacomo
>|||Hi,
No need to restart the SQL Server after changing the database growth %. This
will come in to effect with out any action.
Thanks
Hari
SQL Server MVP
"Giacomo" <gdagostino@.vision2000.ca> wrote in message
news:29E91932-86CF-4494-BABF-ED911BAF42A4@.microsoft.com...
> We set the both database and transaction logs ofr % growth!
> "Tibor Karaszi" wrote:
>> What settings did you change?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Giacomo" <gdagostino@.vision2000.ca> wrote in message
>> news:8B28B334-2E45-4316-8EF9-686109B70A25@.microsoft.com...
>> > We had to change the settings of both our database and transaction
>> > because
>> > the database is growing enormously. Once we made the changes is a
>> > restart of
>> > either the system or the services required?
>> > --
>> >
>> >
>> >
>> > ___________________________
>> > Giacomo
>>

changing set option to on from default server level setting

What are some things to watch out for if we change the default settings from
off to on for certain set options.
For eg: if i turn the set aritabort on at a server level, what are the cons
?
> For eg: if i turn the set aritabort on at a server level, what are the cons
That applications that relies on the old default behavior doesn't work correctly anymore. Always set
the setting in your app, and leave the defaults as is.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Jamie" <jamesw@.hotmail.com> wrote in message news:etw6jze1FHA.164@.TK2MSFTNGP10.phx.gbl...
> What are some things to watch out for if we change the default settings from off to on for certain
> set options.
> For eg: if i turn the set aritabort on at a server level, what are the cons ?
>

changing set option to on from default server level setting

What are some things to watch out for if we change the default settings from
off to on for certain set options.
For eg: if i turn the set aritabort on at a server level, what are the cons
?> For eg: if i turn the set aritabort on at a server level, what are the cons
That applications that relies on the old default behavior doesn't work correctly anymore. Always set
the setting in your app, and leave the defaults as is.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Jamie" <jamesw@.hotmail.com> wrote in message news:etw6jze1FHA.164@.TK2MSFTNGP10.phx.gbl...
> What are some things to watch out for if we change the default settings from off to on for certain
> set options.
> For eg: if i turn the set aritabort on at a server level, what are the cons ?
>

changing set option to on from default server level setting

What are some things to watch out for if we change the default settings from
off to on for certain set options.
For eg: if i turn the set aritabort on at a server level, what are the cons
?> For eg: if i turn the set aritabort on at a server level, what are the con
s
That applications that relies on the old default behavior doesn't work corre
ctly anymore. Always set
the setting in your app, and leave the defaults as is.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Jamie" <jamesw@.hotmail.com> wrote in message news:etw6jze1FHA.164@.TK2MSFTNGP10.phx.gbl...[v
bcol=seagreen]
> What are some things to watch out for if we change the default settings fr
om off to on for certain
> set options.
> For eg: if i turn the set aritabort on at a server level, what are the con
s ?
>[/vbcol]

Changing Language Settings

Hi,

I was wondering how to change the language settings on SQL Server. The server is currently set to US English, and I was wondering how it is possible to change it to UK English. The Server Regional Settings are set to UK English.

Also, on a semi-related topic, does SQL Server store dates in a universal format, and then when data is requested does it 'translate' these dates into the format required by that particular regional setting?

Thank you for any input

MarmanNot sure on the first question, but as far as dates are concerned, yes, they are stored in , I believe, integer format, and converted to whatever date format 1) you client uses, or 2) you ask for via CONVERT statement.

Changing default font

Hi,
is there a way to change the default font settings? currently every textbox
comes in Arial 10pt. i need that whenever i drag a textbox it comes Arial
8pt, for every report.If you find a way PLEASE post it here.
Mike Kruchten
"Kazar" <kazar@.kazar.kaz> wrote in message
news:OqpJLqJoEHA.3224@.tk2msftngp13.phx.gbl...
> Hi,
> is there a way to change the default font settings? currently every
textbox
> comes in Arial 10pt. i need that whenever i drag a textbox it comes Arial
> 8pt, for every report.
>|||still no idea :(
I wonder if its even possible... if not, it would be nice to have this
feature in the next version..
"Mike Kruchten" <mkruchten@.fsisolutions.com> wrote in message
news:OAXZvDLoEHA.3712@.TK2MSFTNGP15.phx.gbl...
> If you find a way PLEASE post it here.
> Mike Kruchten
> "Kazar" <kazar@.kazar.kaz> wrote in message
> news:OqpJLqJoEHA.3224@.tk2msftngp13.phx.gbl...
> > Hi,
> >
> > is there a way to change the default font settings? currently every
> textbox
> > comes in Arial 10pt. i need that whenever i drag a textbox it comes
Arial
> > 8pt, for every report.
> >
> >
>

Changing Database Server Locale Date time settings ?

Hi There

We currently have the following scenario:

4 app servers with regional date and time settings of locale A.

1 database server with locale settings B.

What is happening is that timestamps are being generated on the app servers, these are then in a sql command which fails on the database server since the timestamp format is invalid.

It was suggested that we change the regional locale settings of the database server, but will this not have serious implications , for example every current timestamp format in the datbase will become invalid?

In a nutshell is it safe to change a database servers regional date time locale settings ? Or are there serious implications?

Thanx

As long as date/time values are stored in datetime datatypes, changing the locale/regional settings 'should' not have any impact on the data.

If ServerA uses the form of 'dd/mm/yyyy' and attempts to pass that string value to serverB (and ServerB uses the form of 'mm/dd/yyyy', there is confusion and often failure. Is '06/12/2007' June 12th, or Dec 6th?

However, if you were to make sure that any time values passed to SQL procedures and functions was in the form of 'yyyymmdd' or 'yyyy/mm/dd' (standard ISO format), there would not be a problem for one server to interpret the date from a different server.