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

sometimes less code is more readable, use the else-structure.

declare @bd datetime

declare @fd datetime

select @bd = '1976-2-2'

select @fd = '2004-2-1'

select case

when month(@bd) > month(@fd)

then datediff(year, @bd, @fd)-1

when month(@bd) =...

If you have restored on the clone machine, remember to update the jobs so they wil not be launched on the "dna"-server ;). (update msdb.dbo.sysjobs set originating_server = *** where...

I've had sqlmail running on my clustern, knowing it is not supported and knowing it needs a server-reboot evert +- 6 weeks. According to the users-responsable, this was no problem.......

probably someone can 🙂

this option is to be managed using cluster administrator - sqlserveragent resource - properties - advanced. Check its settings.

If your source-db is in simple-recovery-mode (yes, some vendors still recommend this for their apps), you can forget log-shipping and the only option left is backup/restore if you want the...

Check your sqlagent-settings in the cluster-administrator. On the "advanced"-tab you'll find the options.