http://www.sqlservercentral.com/scripts/contributions/37.asp seems to work fine without a MAPI profile.

sp_makewebtask also makes a hamfisted but effective SMTP sending tool.

I can see the next generation of zealots coming over the hill. They're currently conducting the PS2/XBOX debate.

I seem to remember that there was a film about Steve Jobs...

Whilst you are experiencing the 100% datablocking try running sp_who, then running DBCC INPUTBUFFER(x) where x is one of the SPID's returned by sp_who.

I like the idea of this tool.

I tend to do a DBCC DBREINDEX on a regular basis, which is probably a bit OTT.

The only time I looked at a DBCC...

Nice to see someone playing devil's advocate.

I'm not sure that I totally agree although I have very limited XML exposure.

My understanding is that the rules about what an XML file...

Actually, I quite like the idea behind the multiple clipboard thing, it is just the implementation that is crap!

It would be nice to be able to save one of these...

quote:

---

I generally put in some text that allows me to get past the assistants balloon help and into the actual help file...

I think the problem with Access is that it is an end-user database and as such has to be as simple and as forgiving as possible.

This is fine, but how...

How about you type in a search term, the QA Assistant refuses to return entries for that search term, but only returns synonyms plus 3 random entries. Just like...

Thats the baby. Thanks

I agree with this 100%

• Don't use spaces in table names
• Stick to alphanumerics, (preferably without the numerics unless you absolutely must)
• Don't use reserved words for tables i.e have a...

Can anyone remember the SP that fixes orphaned users?

I seem to remember that if the login name and user name were the same it assigns a matching SID.

Keith,

You sound as disillusioned with UK Education as the parents who care!

My experience of school IT was 30 of us kids sharing a Commodore pet, then shortly afterwards having 8...

I would like the following features within Yukon.

• Upgradeable MS XML component. At present SQL2000 locks you into MS XML3.0
• Not really a SQL Server issue but ...

I always wondered what it was that made something other than an animal masculine or feminine.

Someone told me that in French if a bloke liked it then it would be...