Thats exactly what SQLAgent is doing !

Enterprise Manager / Management / SQLAgent / Jobs

Create a new job, add a jobstep containing your SQLscript,...

Works fine overhere ...

CREATE TABLE [BillPayment] (

 [billpaymentId] [int] IDENTITY (1, 1) NOT NULL ,

 [billPaymentDate] [datetime] NULL ,

 [newBillBalance] [float] NULL ,

 [billAmount] [float] NULL ,

 CONSTRAINT [PK_BillPayment] PRIMARY KEY  CLUSTERED

 (

  [billpaymentId]

&nbsp

can you post your DDL ?

I like the article, but concering the newsequentialid ...

can someone find the flaw in my testquery which proves they'r not sequential ???

Declare

@test-2 table

...Do note that you CAN include varchar(max) fields in indexes but you cannot create and index on a varchar(max) field itself....

Indeed, including the varchar(max) column, you would aim for an...

- keep in mind to rebuild all tables / indexes and to run sp_updatestats and DBCC updateusage.

- indeed sp1 takes longer than the actual upgrade

- IMO dts-migration has been enhanced...

... 5. Concerned about something I read in the Resource Guide. It seemed to indicate that any syntax referencing something like dbname.dbo.tablename would need to be corrected to boname.sys.tablename. Yet,...

- you can deny the users rights to any object in the database. Check BOL !

DENY

    { ALL [ PRIVILEGES ] | permission [ ,...n ] }

    {

        [ (...

Scott Coleman explained it very clearly

may i add that you cannot index a varchar(max) column...

- I hope you're performing SQL backups using the T-sql backup statement or a maintenance job from sqlserver

- If a db is "to big" that my have two causes :

  ...

Thanks for the feedback.

in this case, you didn't get the answer overhere, but now others will !

actualy you can name your backup files whatever you want.

And in fact, you can also name your sqlserver db-files whatever you want.

If you stick with the guidelines of using the...

Thumbs up for Collin !

In theory it should be done using Cluster Administrator.

"How to change the network IP addresses of SQL Server virtual servers" :

http://support.microsoft.com/kb/244980/

http://support.microsoft.com/kb/230356

SQLServer itself does...

indeed sp_updatestats and dbcc updateusage should be part of your maintenance job !

and like you experianced, should also be the first step when...

Keep in mind dbcc dbreindex will keep a lock on your table, so others may not be able to use it during the reindex !

If you have updates/deletes on your...