Now, when you search the Google archives you amazingly often cross the name Celko

For example, http://groups.google.de/groups?hl=de&lr=&selm=OnfVNuP3%24GA.246%40cppssbbsa04

or

http://groups.google.de/groups?hl=de&lr=&th=95c44e2a0f80d1ad&seekm=c0d87ec0.0303221840.7a2c9ddc%40posting.google.com&frame=off

This is for C#:

http://groups.google.de/groups?hl=de&lr=&th=450bf279be9dbda&rnum=1

I...

Hey, how do you say: Mr. Knows-it-all ? scnr

This is probably not more than guessing, so bear with me

- you are in the right db?

- the triggers exists?

- they are not recreated by any other operation?

Hey, I'm running...

See, if this helps:

http://www.terraserver.microsoft.com/

http://www.microsoft.com/technet/prodtechnol/sql/2000/plan/ssmsam.mspx

http://www.microsoft.com/sql/techinfo/administration/2000/scalability.asp

http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopTenWinners.asp

...but you are logged in with appropriate privileges, right?

So, as this sounds strange and as a kind of last resort, did you also try this from within Enterprise Manager? "Usually" this operations should only be a matter of...

And what was the error message?

How did you try to run this?

Are you trying to drop it via DROP TRIGGER? Maybe you should post your statement.

You're missing the fact, that when you move a db that db includes all of its objects. That is procedures, views, UDFs...

Here are some useful informations

http://support.microsoft.com/default.aspx?scid=kb;EN-US;314546

http://support.microsoft.com/default.aspx?scid=kb;EN-US;240867

http://support.microsoft.com/default.aspx?scid=kb;EN-US;274188

...you asked for it, Jeff

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql7/html/sqlquerproc.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_queryrecompilation.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_sa_4azp.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/statquery.asp

http://support.microsoft.com/default.aspx?scid=kb;EN-US;836136

And, of course, you can read about it in "Inside SQL Server 2000"

It might be worth considering to post this to

http://communities2.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.sqlserver.jdbcdriver&cat=en_US_2e7397de-c0af-4aee-9c28-eee388c0f48e&lang=en&cr=US

Okay, I'll make a start here

There are some explanations in BOL. Look for "Rebuild master". In addition I have a link to the...

ONe way could be to pipe the result of

EXEC master.dbo.xp_cmdshell 'osql -L'

to a table and analyze it thereafter.

AFAIK, this will work as long as the servers are not hidden,...

From my understanding so far, in most configurations I don't see any advantage in having multiple filegroups. I'd rather have one filegroup spread over as many physical drives as possible. Multiple...

...and I forgot, I haven't verfiy this myself, but I was told that the difference in execution plans is getting bigger with SQL Server 2005.