and siteid<>' '

Slight optimization suggestion: Check

Len(RTRIM(SiteId)) > 0

instead. Checking for a length of a string to be 0 vs versus...

Without a schema inline or otherwise no xml parser can determine the type for you. on your select statement, try using select * from table for xml auto, xmldata.

Tim C.

//Will...

Why not turn on "IDENTITY_INSERT" for that table instead during the duration of the insert? I assume the reason you want to turn off the identity property is becuse you...

Thanks, and you are correct a HEAVILY used site IMHO would quickly fill up the memory on a StateServer especially if objects were being serialized into it. What I would...

quote:

---

a) Not memory based;

b) Can work in a web farm environment with either a cookie based or cookieless sessionID.

c) Your sessionID is...

Here is a nice article on asp.net session state : http://www.eggheadcafe.com/articles/20021016.asp

Tim C.

//Will write code for food

One Windows to rule them all, One Windows to find them,

One Windows to bring them...

Well, MSFT already had the answer on how to use a db other than temdb, just needed to dig deeper.

HOW TO: Configure ASP.NET for Persistent SQL Server Session State Management

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q311209

Tim...

The #2 solution even tho in memory is in memory on one server. So farming is viable without having to "STICK" a user to a server for the duration of...

I defer to your experience with SQL Data Compare. I only used it till my

shareware on it ran out. We have been using the SQL Compare product for about...

Andy, there are three options for storing session state in asp.net now.

1) In local memory (Same old nasty non-farmable method)

2) In memory on a central server. (I Prefer this method)

3)...

http://support.microsoft.com/?kbid=269074

http://www.sqldts.com/default.aspx?6,105,212,0,1

Tim C.

//Will write code for food

One Windows to rule them all, One Windows to find them,

One Windows to bring them all and in the darkness bind them

In the Land of...

If you don't mind spending a tiny sum see SQL Data Compare :

http://www.red-gate.com/sql/summary.htm

As for built in that come with SQL Server, there are none that I know of.

Tim...

IMHO I believe the status column contains a bit masked value containing the

values that define the column. I believe the COLUMNPROPERTY ( id , column ,

property ) function...

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=9419&FORUM_ID=5&CAT_ID=1&Forum_Title=Administration&Topic_Title=Sp+For+retrieval+of+Data

Tim C.

//Will write code for food

One Windows to rule them all, One Windows to find them,

One Windows to bring them all and in the darkness bind them

In the Land of...