Yes, but the local management studio failed to expand the "object explorer" for this instance.

However, I can still see the...

Thanks Adiga, your method actually works!

Nope, running as 'sa' is...

If I use:

use model

go

exec sp_changedbowner 'sa'

go

error message is:

sjimmo (9/24/2010)

---

This is actually...

Hey mate

I've found an ultimate solution for all the non-standard executables to be run in xp_cmdshell.

The problem lies in that fact that xp_cmdshell does not recoginize lang windows paths but...

I can't run your exact queries, so I came up the same kind of query as you had.

You basically want the xp_cmdshell to do something like this:

EXEC master..xp_cmdshell '"C:\Program Files\Microsoft...

Shawn Melton (9/23/2010)

---

Trying to find something but I am pretty sure the only way to remove the dotted line is to not output the header.

sqlcmd -E -d pubs -h-1 -Q...

Here is the thing.

I actually don't want to get pure data out of a query, the query out will present a set of dos batch commands that can be put...

skrilla99 (9/20/2010)

---

All the same it is a good idea to verify that the account has rights.

Look at the permissions set for the AuditLevel value in the registry and verify that...

Hello Oliiii

The service account for this sql server instance is "local system...

I am the sysadmin.

@nick-2 Tran

Yes, i did use both lower cased and proper cased versions of this stored proc.

@homebrew01

Thanks for you reply. But my issue is that this system...

Thanks again to you two experts.

So I will treat this SP3 updates as seriously as major changes and communicate well with the testing team with a good testing plan.

Thanks Roy.

I am just wondering if this ever happened that a SQL sp patch went wrong.