Automating MSDE Setup

On microsoft support web site
"http://support.microsoft.com/default.aspx?scid=kb;en-us;234626" I saw the
article 234626 "SAMPLE: Setup1.exe Fully Automating MSDE Setup with the
Package and Deployment Wizard (PDW)" about automation of MSDE setup from PDW
of Visual Basic but only setup1.exe is downloadble. I can't use it because my
setup1.vbp is already customized for my application. I can't find a location
to download a source code of setup1.exe for merge it with my custom
setup1.vbp.
Please help me!
Thanks in advance.
hi Terenzio,
"Lingua Terenzio" <Lingua Terenzio@.discussions.microsoft.com> ha
scritto nel messaggio
news:0954BE29-F0A0-495A-AA4A-B3525941C718@.microsoft.com
> On microsoft support web site
> "http://support.microsoft.com/default.aspx?scid=kb;en-us;234626" I
> saw the article 234626 "SAMPLE: Setup1.exe Fully Automating MSDE
> Setup with the Package and Deployment Wizard (PDW)" about automation
> of MSDE setup from PDW of Visual Basic but only setup1.exe is
> downloadble. I can't use it because my setup1.vbp is already
> customized for my application. I can't find a location to download a
> source code of setup1.exe for merge it with my custom setup1.vbp.
> Please help me!
> Thanks in advance.
have a look at
http://msdn.microsoft.com/vstudio/do...instdwnld.aspx
it provides the full VB6 code for installing MSDE 1.0 ... you have to
customize it a little to support MSDE 2000 in order to manage all MSDE 2000
setup.exe boostrapper installer parameters...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Automaticaly popluating Current Date in a Db Field

Hi,
I have a field in he db called LogDate. I have made it a timestamp type. Is
there a formula or a default value i can set for this field in the table
design view so that everytime a record is added, this field is automaticalll
y
populated with teh current date?
Thanks
--
pmudDid youy read anything in the SQL Server documentation about the timestamp
datatype? In spite of its poor name, it has nothing to do with date or
time.
Try the following instead:
CREATE TABLE dbo.MyStuff
(
StuffName NVARCHAR(32) PRIMARY KEY,
CreatedDate SMALLDATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
);
GO
INSERT dbo.MyStuff(StuffName) SELECT N'foo';
WAITFOR DELAY '00:00:01';
INSERT dbo.MyStuff(StuffName) SELECT N'bar';
GO
SELECT StuffName, CreatedDate FROM dbo.MyStuff;
DROP TABLE dbo.MyStuff;
"pmud" <pmud@.discussions.microsoft.com> wrote in message
news:19D4287C-0ED6-401A-AE61-9B0F0FB5EDAB@.microsoft.com...
> Hi,
> I have a field in he db called LogDate. I have made it a timestamp type.
> Is
> there a formula or a default value i can set for this field in the table
> design view so that everytime a record is added, this field is
> automaticallly
> populated with teh current date?
> Thanks
> --
> pmud|||First, you need to define the field as a datetime data type. The timestamp
data type is used for concurrency checking using optomistic locking and does
not represent an actual date and time.
I typically use a default value of CURRENT_TIMESTAMP to put the current date
and time in a field.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"pmud" <pmud@.discussions.microsoft.com> wrote in message
news:19D4287C-0ED6-401A-AE61-9B0F0FB5EDAB@.microsoft.com...
> Hi,
> I have a field in he db called LogDate. I have made it a timestamp type.
> Is
> there a formula or a default value i can set for this field in the table
> design view so that everytime a record is added, this field is
> automaticallly
> populated with teh current date?
> Thanks
> --
> pmud|||Hi Aaron and Geoff,
Thanks for the reply. I made it a datetiem, and in the default value, I used
the function, GetDate() , and it worked. :)
pmud
"Geoff N. Hiten" wrote:

> First, you need to define the field as a datetime data type. The timestam
p
> data type is used for concurrency checking using optomistic locking and do
es
> not represent an actual date and time.
> I typically use a default value of CURRENT_TIMESTAMP to put the current da
te
> and time in a field.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "pmud" <pmud@.discussions.microsoft.com> wrote in message
> news:19D4287C-0ED6-401A-AE61-9B0F0FB5EDAB@.microsoft.com...
>
>|||Good. Just FYI, getdate() is the T-SQL specific function. The ANSI
(cross-platform) standard is CURRENT_TIMESTAMP. They are absolutely
equivalent for SQL Server, except using getdate() will provoke the "Wrath of
CELKO" (tm). :)
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"pmud" <pmud@.discussions.microsoft.com> wrote in message
news:996A9A56-738B-4C38-8BE3-F89BBB68BBD2@.microsoft.com...
> Hi Aaron and Geoff,
> Thanks for the reply. I made it a datetiem, and in the default value, I
> used
> the function, GetDate() , and it worked. :)
>
> --
> pmud
>
> "Geoff N. Hiten" wrote:
>|||Hi geoff,
I had saved my tiable with GetDate() as the default value adn data type as
datetime. Now I changed teh default value to CURRETNT_TIMESTAMP as suggested
by you, but when i click on Save , the default value automatically changes t
o
GetDate() . What do you suggest for this? Can this be a problem?
Thanks
--
pmud
"Geoff N. Hiten" wrote:

> Good. Just FYI, getdate() is the T-SQL specific function. The ANSI
> (cross-platform) standard is CURRENT_TIMESTAMP. They are absolutely
> equivalent for SQL Server, except using getdate() will provoke the "Wrath
of
> CELKO" (tm). :)
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "pmud" <pmud@.discussions.microsoft.com> wrote in message
> news:996A9A56-738B-4C38-8BE3-F89BBB68BBD2@.microsoft.com...
>
>|||> I had saved my tiable with GetDate() as the default value adn data type as
> datetime. Now I changed teh default value to CURRETNT_TIMESTAMP as
> suggested
> by you, but when i click on Save , the default value automatically changes
> to
> GetDate() . What do you suggest for this? Can this be a problem?
This is Enterprise Manager playing tricks on you. My suggestion is to stop
using Enterprise Manager for these things, use Query Analyzer and learn the
T-SQL equivalent(s).
A|||Ok. Thanks Aaron. I will try through Quey Analyzer.
--
pmud
"Aaron Bertrand [SQL Server MVP]" wrote:

> This is Enterprise Manager playing tricks on you. My suggestion is to sto
p
> using Enterprise Manager for these things, use Query Analyzer and learn th
e
> T-SQL equivalent(s).
> A
>
>|||> Ok. Thanks Aaron. I will try through Quey Analyzer.
If you use Enterprise Manager to "verify" be aware that it may still want to
convert CURRENT_TIMESTAMP to GETDATE().

automatically set processor affinity mask not checked

I take that by default for multi CPU machines, the "Automatically set
processor affinity mask for all processors" is checked in the properties of
the server in SQL 2005
My question is, if its not checked, what does that mean and what are the
pros and cons of it ?
So how can I check which processors are being used ?
If I look at the processors, all the processors are checked ?
So in essence, is it the same thing as if this setting was checked ?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:A1C1FE69-965D-4A38-B1B8-D61E5CB38CD0@.microsoft.com...
> Check out sp_configure and the "affinity mask" option. Checking the
> checkbox means 0 (all processors can be used). Un.checking this box is
> setting it to some other bitmask, where you specify which processors can
> be used.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Hassan" <hassan@.test.com> wrote in message
> news:OPwvm$7VIHA.2304@.TK2MSFTNGP06.phx.gbl...
>

automatically set processor affinity mask not checked

I take that by default for multi CPU machines, the "Automatically set
processor affinity mask for all processors" is checked in the properties of
the server in SQL 2005
My question is, if its not checked, what does that mean and what are the
pros and cons of it ?Check out sp_configure and the "affinity mask" option. Checking the checkbox means 0 (all processors
can be used). Un.checking this box is setting it to some other bitmask, where you specify which
processors can be used.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Hassan" <hassan@.test.com> wrote in message news:OPwvm$7VIHA.2304@.TK2MSFTNGP06.phx.gbl...
>I take that by default for multi CPU machines, the "Automatically set processor affinity mask for
>all processors" is checked in the properties of the server in SQL 2005
> My question is, if its not checked, what does that mean and what are the pros and cons of it ?
>
>|||So how can I check which processors are being used ?
If I look at the processors, all the processors are checked ?
So in essence, is it the same thing as if this setting was checked ?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:A1C1FE69-965D-4A38-B1B8-D61E5CB38CD0@.microsoft.com...
> Check out sp_configure and the "affinity mask" option. Checking the
> checkbox means 0 (all processors can be used). Un.checking this box is
> setting it to some other bitmask, where you specify which processors can
> be used.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Hassan" <hassan@.test.com> wrote in message
> news:OPwvm$7VIHA.2304@.TK2MSFTNGP06.phx.gbl...
>>I take that by default for multi CPU machines, the "Automatically set
>>processor affinity mask for all processors" is checked in the properties
>>of the server in SQL 2005
>> My question is, if its not checked, what does that mean and what are the
>> pros and cons of it ?
>>
>|||> So how can I check which processors are being used ?
Configured to be used, or actually doing some work at a particular point in time? For the later, you
can for instance use Task Manager. For the former, check your sp_configure setting.
> If I look at the processors, all the processors are checked ?
> So in essence, is it the same thing as if this setting was checked ?
There is a slight difference between having all checked and the checkbox not checked (the later is
value 0). SQL Server has as many schedulers as processors. With value 0, a scheduler isn't tied to a
particular processor. With anything but 0, each scheduler is tied to a particular processor. If you
want to dig more into schedulers, threads, workers etc, check out Kalen's Inside SQL Server 2005
book.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Hassan" <hassan@.test.com> wrote in message news:eMOEut8VIHA.5132@.TK2MSFTNGP02.phx.gbl...
> So how can I check which processors are being used ?
> If I look at the processors, all the processors are checked ?
> So in essence, is it the same thing as if this setting was checked ?
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:A1C1FE69-965D-4A38-B1B8-D61E5CB38CD0@.microsoft.com...
>> Check out sp_configure and the "affinity mask" option. Checking the checkbox means 0 (all
>> processors can be used). Un.checking this box is setting it to some other bitmask, where you
>> specify which processors can be used.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Hassan" <hassan@.test.com> wrote in message news:OPwvm$7VIHA.2304@.TK2MSFTNGP06.phx.gbl...
>>I take that by default for multi CPU machines, the "Automatically set processor affinity mask for
>>all processors" is checked in the properties of the server in SQL 2005
>> My question is, if its not checked, what does that mean and what are the pros and cons of it ?
>>
>>
>sql

Automatically open a default project on application launch

I was wondering if there was a way to set a default project to open in Microsoft SQL Server 2005 when the application launches.

Perhaps there's a certain registry key I could edit?

The best place to ask that question is in the following forum "SQL Server Tools General
"

Thanks

Michelle

Automatically open a default project on application launch

I was wondering if there was a way to set a default project to open in Microsoft SQL Server 2005 when the application launches.

Perhaps there's a certain registry key I could edit?

The best place to ask that question is in the following forum "SQL Server Tools General
"

Thanks

Michelle

Auto Reload of report on parameter selection?

this might be a stupid question.

I have a parameter which has a default value set to it. when a second value is selexcted is it necessary to click the view report button.

Could it be set to auto reload on dropdown selection.

I am using reporting Services 2000

Thanks.

Hey guys,

Would there be a runtime load function available for the above problem.

thanks