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.

"It actually is like this: Begin Tran, Insert into Table1 (on connection1), Select max() from table1 (on connection1) then insert into table2 (on connection2)." Because your Insert is still uncommitted,...

try saving a trace to table and then

look for eventclass = 17 or (eventclass = 12 and textdata like '%isolation%')