automate GACing assembly

Hi,

Unfortunately the deployment Utility does not support adding dll's to the GAC. Still I want to automate it. (By the way on target machines GacUtil is not present). I tried to make a setup project that only adds a dll to the GAC, however the setup project still makes an application folder. How can I turn this off?

Regards,
Henk

I haven't used the Visual Studio installer projects for some time, but is there not a File page in the project? Can you not delete the app folder in that File page?

Saying that I can highly recomend WiX as a method of generating MSIs. Checkout the very good tutorial if you are interested.

Windows Installer XML (WiX) toolset
(http://wix.sourceforge.net/)

|||Unfortunately, VS does not allow you to delete the application folder

Auto update statistics and Auto create statistics Options

According to BOL, Adding statistics improves query
performance because the SQL Server query optimizer can
better determine how to evaluate a query.
However, someone says that statistics updates will cause
locks on tables at unpredictable times and impact
performance for users.
Should we turn the options on ?
If we turn them off, how can we update the statistics ?
Can it be done in the Database Maintenance Plan ?Technically, yes... it's theoretically possible for auto update statistics
to cause performance degradation under certain performance situations. But
generally speaking... the potential performance problems associated with
turning the option off... are MUCH larger than the potential problems of
leaving them on...
I normally keep them on for databases that I help to manage for customers.
--
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Paul" <anonymous@.discussions.microsoft.com> wrote in message
news:a8cd01c3eb89$eb171030$a601280a@.phx.gbl...
> According to BOL, Adding statistics improves query
> performance because the SQL Server query optimizer can
> better determine how to evaluate a query.
> However, someone says that statistics updates will cause
> locks on tables at unpredictable times and impact
> performance for users.
> Should we turn the options on ?
> If we turn them off, how can we update the statistics ?
> Can it be done in the Database Maintenance Plan ?

Auto update statistics and Auto create statistics Options

According to BOL, Adding statistics improves query
performance because the SQL Server query optimizer can
better determine how to evaluate a query.
However, someone says that statistics updates will cause
locks on tables at unpredictable times and impact
performance for users.
Should we turn the options on ?
If we turn them off, how can we update the statistics ?
Can it be done in the Database Maintenance Plan ?Technically, yes... it's theoretically possible for auto update statistics
to cause performance degradation under certain performance situations. But
generally speaking... the potential performance problems associated with
turning the option off... are MUCH larger than the potential problems of
leaving them on...
I normally keep them on for databases that I help to manage for customers.
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Paul" <anonymous@.discussions.microsoft.com> wrote in message
news:a8cd01c3eb89$eb171030$a601280a@.phx.gbl...

quote:

---

> According to BOL, Adding statistics improves query
> performance because the SQL Server query optimizer can
> better determine how to evaluate a query.
> However, someone says that statistics updates will cause
> locks on tables at unpredictable times and impact
> performance for users.
> Should we turn the options on ?
> If we turn them off, how can we update the statistics ?
> Can it be done in the Database Maintenance Plan ?

---

auto increase text!

Hi,
I have an initial value like this:
'TEST0001'
I want to write a sql script that will automatically take that initial value
and keep adding 1 to it and insert into a table for me until it get to
'TEST9999'.
my table should now store:
TEST0001
TEST0002
...
...
TEST0010
TEST0011
...
...
TEST9999
How do I do this?
Thanks,
Tom ddeclare @.seed int
set @.seed = 1
while @.seed < 10000
begin
insert into tableName select 'TEST' + right('000' + cast(@.seed as
varchar(4)), 4)
set @.seed = @.seed + 1
end
"tom d" <tomd@.discussions.microsoft.com> wrote in message
news:1DB51C59-3F93-476E-91CE-6E7B4C7E7259@.microsoft.com...
> Hi,
> I have an initial value like this:
> 'TEST0001'
> I want to write a sql script that will automatically take that initial
> value
> and keep adding 1 to it and insert into a table for me until it get to
> 'TEST9999'.
> my table should now store:
> TEST0001
> TEST0002
> ...
> ...
> TEST0010
> TEST0011
> ...
> ...
> TEST9999
> How do I do this?
> Thanks,
> Tom d
>