I am having the same error, but my issue is a bit different. Wew have a mixed enviroment, some SS2000 and SS2005.  We have deployed the SS2005 management studio to...

I am having the same error, but my issue is a bit different. Wew have a mixed enviroment, some SS2000 and SS2005.  We have deployed the SS2005 management studio to...

Newbie's solution works.  This is a NT4 domain issue. If you are using AD, then there shouldn't be a problem.

http://support.microsoft.com/?id=323280

This basically says to have this regkey:

Windows Registry Editor Version...

I would like to not be bored.  I need a place that will consistantly invest in new technologies and allow us the time to learn those technologies.

-----------------------------------------

"a little english to...

That was two points?  Isn't that kind of SQL DBA 101 stuff?

Exactly. The question should read "over 2 billion objects".  The thing the documentation doesn't indicate is whether or not that includes the system objects.  I guess when you are talking...

Per Microsoft, you can also use the INDEXPROPERTY() function.

http://www.microsoft.com/sql/techinfo/tips/administration/autoindexes.asp

Interesting question.  Here is the explaination from Microsoft:

http://www.microsoft.com/middleeast/tips/SQL_Server_tip5.aspx

If I find myself spending too much time (more than a couple of hours) on an issue, I usually go searching on Google groups.  It saves me a ton of...

OK, that is what I said to do a page of posts ago...

My usual process is to drop the constraint relationships, truncate the tables and then re-apply the contraints.  Too many times I hve run into the log expanding beyond what it...

The question should have been phrased differently.  When migrating databases like that, I would have truncated, not deleted, the data.  That should have reset the identities in one step.  Besides,...

While the answer of using the -e startup parameter is correct, it is only temporary.  If you want to permanently move the errorlog, I thought you needed to change it...