Depending on the data you should rewrite the table and make sure normalized, or setup a seperate table to split data to ensure 8k never an issue. Although with variable length...

Thanks for your change and hope I didn't come off rude.

The only question I have is if you need to keep track of the cards that have been dealt. You wouldn't want a dealer playing a Second Ace of Spades...

This is one that can help and read the notes for additional info.

http://www.sqlservercentral.com/scripts/contributions/268.asp

use sp_helprolemember to get role memeberships such as database owner which are not in the output.

Sorry forgot

http://www.sqldts.com

You could also check out ApexSQL Log which has free lifetime upgrades.

However I suggest you first look at things you need to do for the future to be proactive as...

I agree too vague. What are all the conditions of how you can deliver. If you are firewalled against the customers and they cannot VPN to you directly then you...

I personally have done nothing with telnet but I believe Hummingbird has a command line interface you cvan call the scripts with. If that is true then you can call...

As for the question:

Does a composite index serve a query well that is only using one of the fields in the index?  Should a separate index be created?

The answer is...

Just as an FYI on storage. It is placed in the sysproperties table, the [name] field will read "MS_Description" and the ID is the objects id. So if you have...

How rows are physically stored has nothing to do with in which order rows found by a query is returned.... unless you say ORDER BY

Actually this has always been...

Here is a few places to start.

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

http://www.planet-source-code.com (Lots of available code to learn from)

http://www.javascript.com (Site was a bit cumbersome thou)

http://www.codeproject.com/vbscript/  (Tutorials and lots of...

And that depends that the log is still intact with the point in time it occurred. If you have set to Truncate in SQL 7 or Simple Recovery in 2000,...

Only way to get rid of the IsNull function is use a case statement to check IS NULL. Technically the Coalesce function is an extended version of the IsNull function...

Trigger would not work with a failure as it would be rolled back also. Transaction Log might be a good place but wil require a third party app.

I sugest setting...