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 =...

If you're going for dynamic sql, your statements will always have to be compiled, optimized, security-checked, .... So you'll have to provide more access rights to the user(s).

When you...

is agent running on "local system" and did you remove "builtin\administrators" ?

you've got the solutions. Remember that "short circuits" overheat ! If you use to much short circuits, your box might fireup. Do some performance checks as to what costs your...

You've had the alternatives in previous replies. Having Declarative Referential Integrity (DRI) in place would have prevented those rows from getting inserted.

wild guess :

exec master.dbo.xp_SMTPSendMail80 @query = N'select * from sysusers',

'user@server.net',

'user@server.net',

'server.mail',

'help error'

btw It's a nice practice to name your sp-parameters because it will not get you into troubles when you swap...

With this conversion,you convert from 'local' characterset to nvarchar. If you have stored non-'local' characters in your varchar (so they don't make sence), and you convert to nvarchar, they will...