Which site?

I would recommend that anyone who works with DATETIME read:

A) Tibor Karaszi's article on the subject:

http://www.karaszi.com/SQLServer/info_datetime.asp

and

B) Rick Snodgrass' book on tempoaral SQL, which can be downloaded in PDF format...

You can't get it into a local variable for exactly the reasons you stated.

Can you post some more detail on what, exactly, you're trying to do (i.e. what you're parsing,...

sp_helpfile will show you the files sizes.

All it really requires, IMO, is a bit of discipline.

Script every object from your database and check it into VSS.

Any time you need to change an object, check out and...

What does "crashes" mean? Are you getting an error? Did you remember to update the new server to the latest service pack?

Well I have to admit, I haven't actually read it (or any others, for that matter) -- Some of the SQL Server MVPs said it was good in a thread...

Test it and tell us. You haven't posted sample data or queries so there's no way to answer that question... If the rowsize is greater than 8k, you won't...

How about posting the DDL for the real table?

What is it representing? Is it normalized? Can you split up the data in any way based on some business...

Maybe you should change your website to "lucky13" instead?

Looks like it's time to change that

IDENTITY_INSERT is intended for sysadmin use when something goes wrong; I don't think there's a workaround to...

Your question is pretty vague; so I'll turn it around. How are YOU doing it, and what problems are you having that prompted this post?

What are you using IDENTITY_INSERT for? Why not just let the IDENTITY columns increment themselves?

http://www.amazon.com/exec/obidos/tg/detail/-/1861004761/qid=1098739424/sr=8-2/ref=sr_8_xs_ap_i2_xgl14/102-1036834-3046505?v=glance&s=books&n=507846

Jonathan,

SQL Server does not let you select from tables using ordinal positions. Try the following batch:

create table #tbl1 (cola char(1), colb char(1))

create table #tbl2 (cola char(1), colb char(1))

insert #tbl1

select...