You just need to turn off the identity using the syntax mentioned above, then add a higher value, then turn it back on.  Sql server will automatically insert at values...

SQL server now is able to figure out to use the composite index even if you only query on one or two fields.  Sql Server 7 didn't do that. But...

Here's one solution using a user_defined function.  You may need to check it for syntax, but I think it'll be right.  I also have one that doesn't use a user-defined function,...

I've seen this error when running a query/process/sp that uses a lot of temp tables specified with a # at the beginning.  A way to get around this is to...