Is he part of an NT group? If so, this is a known problem and according to M$ it is by design ...

http://social.msdn.microsoft.com/forums/en-US/sqlsecurity/thread/7d46a024-7ed5-4c9b-b091-3640dc04f5a1/%5B/url%5D

http://lmgtfy.com/?q=how+to+use+AWE

On a more serious note, you need to be a little more specific ... What is it you're looking to do and why? What hardware are you running? What version...

Well, they would all be named instances ... to my understanding installing multiple instances in a clustered environment requires the usage of instances regardless, but this really isn't of concern...

Ok after understanding the data a little more ... the whole unicode thing doesn't really matter ... as the user can exceed 8000 when passing in this multi-value parameter.

So now...

So after reviewing this again, I think SSRS is converting the data source to ntext because it's so large, and then obviously when passing into the procedure, it blows up.

Even...

Any thoughts on this? I really need to use VARCHAR as I need greater than a 4000 limit ...

Thanks

The cell phone provider ... ie Verizon = @vtext.com

Alrighty, well ... looks like restarting the agent resolved it.

I can in fact notify operators just fine:

EXECUTE msdb.dbo.sp_notify_operator @name=N'operator name',@body=N'test message'

Still not sure what my issue is here ... All other instances working just fine. Just wish I had...

parth83.rawal (5/4/2009)

I am agree what you are trying to say, i am trying to send SMSs using database,

basically i am able to send the data using an SMS Gateway, but...

You can indeed write something rather easily to accomplish this, but if you're looking for a well priced tool that is very well built and will handle this and much...

Anyone using any tools such as Idera's password checker to audit your logins? Basically a purposeful brute force attack using many passwords to discover what has weak/blank/or same as login...

Can't say I've ever heard of "SendPage" ... you could use database mail (sp_send_dbmail). If you're on SQL2000, you'll need to use SQL Mail and/or a custom extended stored procedure...

SELECT

[name]AS [DBName]

,SUSER_SNAME([sid])AS [DBOwner]

FROM [master].[dbo].[sysdatabases]

ORDER BY 1

As David has stated, sp_msforeachdb is a quick and dirty way ... but you will find it lacking pending on what you're attempting to do. Might want to look into...