I am nothing but disgusted that M$ is doing such a poor Job!

I would have never expected that "we" are compiling those and M$ is simply playing catch up...

And the zaga continues. They posted that the membership scripting issue was "solved" on SP2 and guess what? When I checked my SP2 installation it still does not scripts built-in...

Sorry I just lost my post. Here are *my* reasons:

-If you shrink it all work performed by previous reindexing is spoiled( pages are moved in the file unless you use...

Answer: 0

I have seen this approach before and it *is* quite fast but when you try to make the returned values into readable format is when you get hit *hard* by...

As part o preparing a database for transactional replication it *is* MS advice to mark FKs, Triggers and Identity columns as NOT FOR REPLICATION *before* you create the publication. This...

I think the article was clear and very to the point but besides the advantages of using this technique the drawbacks should also be pointed out.

I have had memory...

The rights required are ddladmin, db_owner or sysadmin. If you are fine with granting ddladmin you will be fine. Other method is to use TRUNCATE TABLE (resets to...

-- My Solution: Use an indexed view: (Borrowing Names from mkeast )

CREATE TABLE dbo.NullPKTest

(

nid int PRIMARY KEY

, nulltest varchar(10) NULL...

Hey I am here ... just kidding

There are *many* talented people around but "references" are the KEY. If you can get to them...

If you SET the DB to read-only all locking mechanisms will be bypassed!

Maybe I am confused but what is "real-time" about all this ?

It is a nice summary of nifty features on DTS the title is misleading though.

A 10GB data warehouse is small enough to follow the proposed procedure.

When your data warehouse reaches 200 to 500GB you will get into a TOTALLY different ball game.

Cheers,

If you have Indexed views or Computed colums you need to have the correct "SET" environment:

set ansi_nulls on

set quoted_identifier on

set ansi_warnings on

set ansi_padding on

set arithabort on

set concat_null_yields_null on

set numeric_roundabort off

Cheers,

You need the help of Two stored procedures:

use distribution

sp_help_agent_profile @agent_type = 2 --LogReader=2

go

sp_help_agent_parameter @profile_id = 3

go

On the above example I used sp_help_agent_profile to determine what is the default (currently running)...