does sqlserver install auto w/Small Bus Srv 2003

Does SQL server install automatically with SBS?
I did an install last night for a client, not at server
at this time.
Did this install auto?I do not believe that it is part of the automated setup.
Rand
This posting is provided "as is" with no warranties and confers no rights.

does sqlserver install auto w/Small Bus Srv 2003

Does SQL server install automatically with SBS?
I did an install last night for a client, not at server
at this time.
Did this install auto?I do not believe that it is part of the automated setup.
Rand
This posting is provided "as is" with no warranties and confers no rights.

Does SQL Server 2005 Express has the method that delete automatically rows ordered by time colum

Hi, I made table that stores monitoring data every 1 minute.

It should have only 60 minutes-data from current time.

I delete data which stored 60 minutes ago before insert.

I'll be happy to find that the database engine does automatically above procedure.

You could use an insert trigger which fires when new data is inserted. Place your delete statement here to delete old records.

--
SvenC

Does SQL Server 2005 Express has the method that delete automatically rows ordered by time c

Hi, I made table that stores monitoring data every 1 minute.

It should have only 60 minutes-data from current time.

I delete data which stored 60 minutes ago before insert.

I'll be happy to find that the database engine does automatically above procedure.

You could use an insert trigger which fires when new data is inserted. Place your delete statement here to delete old records.

--
SvenC

Does rebuilding index update statistics?

Hi, everybody?
I wonder if rebuilding indexes update statistics automatically.
If not, do I have to update statistics separately?
Thanks.Yes, DBREINDEX does. But INDEXDEFRAG does not (Maint Wiz is using DBREINDEX).
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Kim Keuk Tae" <zyuuzika@.korea.com> wrote in message news:OUNg6T7ZDHA.628@.TK2MSFTNGP10.phx.gbl...
> Hi, everybody?
> I wonder if rebuilding indexes update statistics automatically.
> If not, do I have to update statistics separately?
> Thanks.
>
>sql

Does Link in Subscription Point to Live or Snapshot?

This should be an easy one...

You get an email that contains a link to a report. The email was sent automatically as part of a subscription.

Does that link point to a snapshot that was taken when the report was run, or does clicking the link cause the report to re-run altogether?

Thanks,
Dan

Hello Dan,

The link will always point to the current report. For instance, if you have an email subscription that goes out at 6am daily, and today at 8am, you open the report from the link in today's and yesterday's email, they both will take you to the most current report.

As for if it will be re-run, that depends on how you have the execution on the report setup. Whether it is 'Always run this report with the most recent data' or 'Render this report from a report execution snapshot' will determine this.

Hope this helps.

Jarret

|||

Hi Jarret,

That's exactly what I needed to know.

Thanks so much!

Dan

Does index-rebuilding update statistics?

Hi, everybody!
Recently, I've decided that I should do index-rebuilding.
I wonder doing it updates statistics automatically.
Thanks in advance.> I wonder doing it updates statistics automatically.
Yes, unless you use the STATISTICS_NORECOMPUTE clause in the CREATE INDEX
statements.
--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

Does a transaction automatically rollback on error?

When I write code for a multiple statements transaction do I need to check'if @.@.ERROR > 0 ' after each SELECT, INSERT, DELETE or UPDATE statement so that the'rollback tran' statement can be given, or SQL server will automatically rollback the transaction and we don't need to check for @.ERROR > 0 ?

If you start a transaction (with BEGIN TRANSACTION) you must end it with a COMMIT or ROLLBACK. So, yes, you should check the @.@.ERROR value after each pertinent statement and explicitly ROLLBACK the transaction if there is an error. I am not sure if there were any changes in this area for SQL Server 2005.|||In SQL 2005, you could do:

BEGIN TRY
.....
COMMIT
END TRY
BEGIN CATCH
.....
ROLLBACK
END CATCH

The good thing is you could put multiple SQL statementsin the TRY block. But there are some limitations too. check out books on line.