OK Identity does not reuse. Should it ? Depends on the requirements. If your id column reaches the maximum value (int/bigint !!), you're in big troubles anyway and probably you'll...

I think I'll start counting from the other left side

Cheers

use IDENTITY. That's what it's made for.

Or keep your own parameter-file which you access using a genereate-new-id stored procedure.

this EOM-thing , does that mean you have to stand on a chair/table and that everyone else has to sing to you ? ended by 3 times hurray

identity just generates a (sequenced) number, but it does not generate it by recalculating it using the table itself, but it keeps it in a systemtable. It should be no...

The only time I ran regrebuild, I did not supply a parameter and it did the job. The reason I did not supply a parameter is because I did not...

Check "registry rebuild" in books online.

(regrebld utility)

I don't know such a tool.

IMO changing the system-date might be no issue on a TEST server, but on a production environment ???

Provide the date with a parameter to your...

kknudson,

Did you have DRI (foreign keys) ?

Select 'print '' object : ' + u.name + '.' + o.name + ''' ' + char(13) + ' go '+ char(13)

...

Maybe this can get you on tracke:

CREATE TABLE #tInfo (SQLServerComputerName nvarchar(500))

insert into #tInfo (SQLServerComputerName)

exec xp_cmdshell 'net name'

select SQLServerComputerName from #tInfo

drop table #tInfo

Don't open your cmdshell...

are you lookig for xp_cmdshell 'net name' ?

This is "nice to know"-stuff that helps to get you good credibility. But because it all gets more integrated, the "nice to know" tends to be...

I know this might be regarded as prejudiced source, but anyway :

- http://www.microsoft.com/sql/evaluation/compare/default.asp

- http://www.aw-bc.com/catalog/academic/product/0,4096,0201752832-TOC,00.html

- http://www.pinnaclepublishing.com/SQ/SQmag.nsf/0/73F96D35618BBF56852568D0007691CC

- http://www.benchmarkresources.com/?cat=3&Sel=Database

Edited by - alzdba on 07/31/2003 08:17:57 AM

Did you check the sqlserver-server's local (nt/w2k)-group members for guests and/or users to contain the needed domain-usergroups ? (e.g. yourdomain\domain users)