If you are trying to "share" the database file between servers, you cannot do this. A server holds the locks on the file and it cannot be shared, even in...

David is right, there isn't a real "Load balancing" solution. The best you could do, and I've done it, is to setup a second server with "read only" data and...

OLAP tends to be larger data sets since it precaclulates values for the cubes. This depends on how you define the cube and how much data in your warehouse is...

I've read about it, basically a "blade" server living in an AS/400 box. Separate NIC, disk, etc. Haven't worked with it, but the cost of the card is probably not...

The disk counters can be a little misleading. Read this http://www.oreillynet.com/lpt/a/1503.

Not sure if it's your issue, but it's interesting. You could have a large Q with low transfer if the...

I'd like to share a beer as well. In fact, be happy to buy one for anyone that's lucky enough to come to PASS.

Especially Antares, you need one

Do you get this regularly or is it a one time thing? Haven't seen it, but it seems that the server got confused and attemped to unlock something that wasn't...

Not specific to passwords, but usually that's the only change to most logins. It does guarentee the pwd was not changed since that date.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com...

I did find that Groupwise has a MAPI interface, but not sure if this will work.

Upgrading a server tomorrow and will try some integration, but since it's send only to...

According to this http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q263/5/56.asp&NoWebContent=1, isn't supported. I suspect without some extended stored procedure, it will not work.

"Microsoft does not support using SQL Mail to communicate with mail servers such as...

Need to do this myself as well. I'm thinking I may have to use SMTP mail rather than a groupwise integration, but researching this now.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server...

Not sure how a check constraint will help with joins and retrieving data, but they supposed to be faster than joins in inserting data.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com...

I tend to use a result set, keep things consistent, but no real reason why output parameters don't work. They've confused developers at times, so I stick with what they're...

Sorry, no idea here, but I haven't done that much with UDFs.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

This is a little vauge. Do you mean an automatic report from the server? Send it to LTP1. There is no facility within the server to print reports. Everything happens...