no way to get around it.

btw if a user add a column to a table, you must recompile the view if yo want that column to be available using this...

Actualy... since you're starting ... maybe better to be using join syntax.

SELECT L.drinker -- (drinker likes beer)

FROM likes L

inner join serves S -- (joins drinker...

first start with telling the system what you know:

i.e. Likes (a drinker likes beer)

then join it with what you know next:

i.e. Serves (you know the bars where they server what...

BOL has good info !

search for "Choosing the Recovery Model for a Database"

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/17ca2e0a-016d-4fb8-83b7-354578d6cfb9.htm

Short:

Simple recovery model: Full and differential backups supported.

bulk-recovery and full recovery:full / diff / log backups supported.

regarding bulk...

I'm glad you got it to work.

Here is the actual proc we use.

To send without recepients, set the parameter to '' (empty string) in stead of NULL.

You need to adjust these parameters in the proc !!

Ask...

Did they pull the plug only for the virtualisation part or for the full ad-hoc regression test infrastructure(s) ?

Thank you for sharing your struggles ...

Especially the fact that despite the warnings we give, people confirm them not to be a problem (again and again) until they...

that's because you get so see object_ids in stead of the actual names ...

Read the link I provided and you'll be able to generate a nice script after some modification.

it...

- probably your log-backup is created before the end of the full backup.

- many of us start with making a log-backup before making a full backup.

If that is...

- it is prooven oledb outperforms odbc.

- use profiler to detect if you have issues with tempdb.

then you can optimise it.

You need to measure it to be able to...

as stated before : SSNS is obsolete with sql2008.

Maybe the better way is to the the dot net frameworks version of notification services. (I cannot recall the dotnet name for...

have a look at : "Generate Create FK-indexes" http://www.sqlservercentral.com/scripts/Indexing/61391/

Thank you for the feedback.

- seems like only fk-in the fact ??

- I've read this nice art regarding a technique often used in questionairs...

"Introduction to Bitmasking in SQL Server 2005"

...