Hi,

It's a nice trick, but the explanations in the article are a bit overloaded.

The only thing that you have to do is to set the Options tab as shown on picture...

Excellent!

First time I see an easy to understand and very useful SQL DMO example.

Congratulations,

Geert

Hi,

You are right, you need to list out all tables.

But why don't you use the standard role db_datawriter? This role has got the same permissions as you want. It also...

DBCC DBREINDEX reindexes tables one by one.

The table that it reindexes is locked exclusively.

If you don't need 24/24h, just put a message on the web "Web will be up again...

I knew I'm a natural talent without knowing it !

If column ACCT1 needs to change when ACCT changes, consider concatenating the 4 zeros in your application instead of storing it in a table. (after fetching the rows).

Saves Disk space and Network...

This is a known issue with Analysis Services.

You'll have to setup the security manually.

The SP3 does not add the users to the NT groups, therefore no-one has access.

Check the OLAP...

You should use a trigger for this.

Default values only accept constants.

Hi,

This is perfect logical.

To get the second query working, use the following WHERE clause:

... and ( B.intLanguage=2 OR B.intLanguage is null )

Why?

Because the...

Why tempting any bugs in the decision strategy of the garbage collector? You can sick the sodding thing on any objects you want to waste (set a=nothing) .

Destroying objects manually ASAP is best method.

This frees up memory and unloads DLL's earlier.

Hey,

Didn't know that, cool!

It's nice to have all tables linked to "db_owner", because the user "dbo" is linked to one login only. When...

When a file grows with large chunks, the system slows down (even appears to stop responding in some cases) for a few seconds.

If your transaction log grows to gigabytes every...

Hi,

Being a developer and an admin at the same time has also another drawback: you'll get called for small and large problems, all day long. A DBA has quite a...

Exactly

When you want to know if it's on Monday AND Thursday, just add their values together and AND the result

WHEN freq_interval | (2+16) =...