SELECt * FROM (set of join tables...) WHERE City = 'Toronto' AND City = 'Vancouver'

The WHERE criteria will never be fulfilled. If you want to get result for both Cities...

Thanks for this good documented article. I definitely will get more into test driven development on SQL Server now. Actually in my old times as Cobol programmer (Hear, hear) this...

Check this http://www.simple-talk.com/sql/learn-sql-server/sql-server-full-text-search-language-features/

Takes about 10seconds to google for the whole sentence and you get an answer.

I just scripted a linked server I have. Maybe you can ignore the whole server option stuff.

EXEC master.dbo.sp_addlinkedserver @server = N'YourServerName', @srvproduct = N'SQL Server'

EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname =...

I use SQL Response to monitor all my servers in various locations around the globe.

Using a SSD is a really smart idea! Thanks for that!!:satisfied:

LOL, so there are two of us then

Interesting question! Well, I get my ideas when I'm not thinking of having an idea. Best place is in the morning under the shower. Then I'm in this state of...

Have you tried to increase the OLE/DDE timeout value? Just a guess but worth a try. The following example sets the timeout value 60seconds.

Application.SetOption "OLE/DDE Timeout (Sec)", 60

Interesting! Do you think a dynamic pivot form would do the trick?:unsure:

Hi,

If I understand correctly you want to create the controls on a form on the the fly using some "meta" data about the form from a table?

Check this: http://pubs.logicalexpressions.com/pub0009/LPMArticle.asp?ID=259

This explains...

Check this http://www.sqlservercentral.com/Forums/Topic509369-338-1.aspx or create an acceess project (adp).

Some time ago I played around with Access and stored procedures. I share this file on my SkyDrive (ZIP).

This is the link:

http://cid-fc70428b0c8daeb3.skydrive.live.com/self.aspx/.Public/MS%20Access?authkey=8k8hGJ7srSY%24...

Being able to read sometime helps :blush:

Hi,

Thanks for this very comprehensive script. I tried to help and run it on one of my servers but I see the same as kwilt.

Script runs through reporting success but...

Hi RainbowFfolly,

I think your contribution is valuable and outstanding! No reason for any appologie!

Cheers and keep up this attitude

René

🙂