Take a look in BOL for hints. Sometimes it's appropriate, but think twice before doing it - what will work in one case may not work as well in another....

Remember to double quote your path & filename, it will break if embedded spaces.

Andy

I run a couple of the developer edition 512m on one of my machines as well, have not had any problems, though I don't usually have more than 1 or...

This from BOL:

When executing xp_cmdshell with the Microsoft® Windows® 95 or Microsoft Windows 98 operating systems, the return code from xp_cmdshell will not be set to the process exit code...

I'll go along with the idea that if you've done a really good middle tier, you don't care as much about the column names. Or at least they are all...

Take a look at DBCC CheckIdent with the reseed option. Does just what you need I think.

Andy

Whether it really needs it depends on how much data you're loading, you need a large cache for data and procedures. By default SQL grabs it all, then releases some...

I've got one of those big diagrams of the SQL system tables - useful at times, especially during a discussion with someone else where you both easily see it. I...

I honestly haven't looked - are you looking for something in particular or just curious?

Andy

Pretty good Jason - though I think if you want a rock solid EOM function, you'd want to eliminate the time portion, easily done though.

Andy

Did they give a reason why (for not using Hungarian)?

Something I see used VERY little is user defined type - talk about self documenting, look over to see that the column is of type zip code. Now whether that...

You're not doing a select from the test1 table? I would think that this is an expensive method of doing paging - I'd at least consider just inserting the primarykey...

Selects have no guaranteed order - you're going to have to use the order by in your second select to get the results you want.

Andy

Replication is definitely one way to approach that problem. Depending on the complexity, a simple update statement or DTS package might be just as good. I'd suggest reading through BOL...