Try the link below for sample code from Microsoft but you need to know Memory stream because you can use it to convert the image to bytes and if you...

It is an interesting behavior but it is not a bug because ANSI SQL OUTER JOINS default mathematically to a NULL.  There are also known issues with the ISNULL function...

Try the two links below for how to configure SQL Server Agent permissions to perform DTS automation.  You need to install SQL Server Agent with a service account with the...

I think because a View is query rewrite and OUTER JOIN default mathematically to a NULL.   That is the reason extra care is needed to get expected results.  Check out SQL...

Read this thread for Microsoft own documentation and how you can get more out of MSDE. Thona knows how you can get more out of MSDE.  Hope this helps.

http://forums.asp.net/612379/ShowPost.aspx

Kind regards,

Gift...

I am not sure but try and change tinyint to int16 because tinyint maps to SByte in .NET FCL (framework class library) and it is not CLR compliant.  I would...

Create the tables in Interbase and run INSERT INTO it will take time but you can do it.  Hope this helps.

Kind regards,

Gift Peddie

The main problem is there is no time stamp data type in SQL Server, the time stamp is a derived data type used internally by SQL Server.  To get seconds...

Try the link below to use DATEDIFF function with timespan which gives you time interval without time interval function.  Hope this helps.

http://www.stanford.edu/~bsuter/sql-datecomputations.html

Kind regards,

Gift Peddie 

The concurrent users issue is only related to write users not read, people have tested MSDE for more than 2500 read users.  Hope this helps.

Kind regards,

Gift Peddie

Try the code below it is what is recommended by my book SQL Server 2000 A beginner's guide by Dusan Petkovic.  But this code is for SQL Server 2005 so...

I would create  a Unique index with IGNORE_DUP_KEY option because when an attempt is made to enter data for which there is a unique index and the IGNORE_DUP_KEY clause is...

I would not let an application create a new database for my users, I would check and shrink the database as needed by running DBCC Shrinkfile  and create a new one...

I don't think new database will be automatically created when you get to the 2gig limit.  All the detailed info about MSDE and other SQl Server editions are covered in Maximum...

Try these two links for Arrays in SQL Server, I am assuming you know Arrays and Strings are classes but SQL Server types are Structures, the former are reference types...