naga.rohitkumar (10/5/2012)

---

ya i too agree with u ALTER TRACE

but if we use default master the user can able to have access on all databases know

i mean it for...

naga.rohitkumar (10/5/2012)

---

HI jack

other than giving sysadmin or using this script

-------------------------------------

Use master

Go

Grant Alter Trace to Login

-------------------------------------

1.if we give bulkadmin and public in server role and ddladmin,db_datareader,db_datawriter in database...

Shon,

In my experience, I have gotten the error message generated by SQL Server back when using this. It's why I wrote the code. The errors I was experiencing...

How would you get a...

WayneS (8/22/2012)

---

Hey Jack - why are you dissing all of your Threadizen buddies?:-D:-D:-D

http://wiseman-wiseguy.blogspot.com/2012/08/im-speaking-at-sqlsaturday-156providence.html

4 Threadizens doing 8 presentations, and you're not seeing any of them?:w00t:

And what's up with only seeing presentations...

I haven't checked in here in quite awhile and had a couple hundred posts to read through. Not much I'll comment on so I don't stir anything up again.

I...

I over thought this one, and knew I was doing it, but still did it anyway. My thinking was that, while you do not have to define a clustered...

Seems like you should talking to your hosting provider and/or the uddeIM people. IT is unlikely that SQL Server professionals will be able to troubleshoot these errors as they...

I think you'll need to use a script component and .NET RegEx functionalisty to get this to work.

What is the restore code on the secondary server? Sounds like the code is setup to filter on a file name and would need to be changed to restore...

Have you checked the firewall on your desktop? Perhaps it is blocking responses from that port? Outside my area of expertise now, but I'd definitely start by temporarily...

Can you connect to the named instance from the server itself?

What are you entering for a server name? Are you sure you are typing the name correctly?

Is the SQL Browser service running? Without the browser service running you need to know and specify the port that the named instance is running on as well.

Or you could write it this way:

UPDATE ob_problem_list_

SET datefield = (CONVERT([varchar](10),getdate(),(112)))

FROM

inserted i

WHERE

i.person_id = ob_problem_list_.person_id and...

That certainly looks like a KERBEROS error message to me. I'd double-check all my SPN's and work with the network/windows admin to ensure that delegation is setup correctly on...