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)

You're in deep sh**. This is mainly about politics.

Unless there are some issues you can only solve with oracle, there is no reason to migrate. (guess not because now...

Regarding windows-authentication, check if the 'Developer'-group is added to the local\groups\guests or users of your sqlbox (or a group they are member of).

Check the IIS anonymous login setting. Maybe someone did put an overauthorized user-account overthere.

Seems fine, but check this :

(You'll need to grant read access to all needed objects in stead of only to the sp(s))

-- TESTSCRIPT based on Northwind

-- create SQL-user-login

sp_addlogin @loginame =...