All the servers are 2k3, my local is XP.

Unfortunately no ... nothing has changed. My openquery does not work against a destination server, unless...

Jim Mace (2/28/2008)

---

The last time I tried a backup/restore a ran into some incompatibility issues between the two versions of SQL Server and my database. Is there a way...

This is a little something I've been working on ... you might find it handy. It is not yet finished, but it does the job.

One is a proc that uses...

Depending on whether or not you want to be able to roll back for any particular reason, I'd recommend doing a backup/restore. If you detach/reattach, there is no going back...

Sugesh Kumar (2/28/2008)

---

OK you mean to say there is a server which runs on local adminstrator account and yes exactly these cause the problem. you need to cahnge them to...

Steve Jones - Editor (2/28/2008)

---

First, you know you shouldn't use shrinkdatabase except in rare instances. So I'd say this should be done rarely and then just use the select...

Sugesh Kumar (2/28/2008)

---

THis is a HOP problem. You need to run your sql services in a domain account to access the network resources. Else this will fail as the local...

tosscrosby (2/27/2008)

---

I copy/pasted this directly into QA (SQL2000 sp3) and it will not compile. Errors as follows:

Server: Msg 170, Level 15, State 1, Procedure sp_who5, Line 38

Line 38: Incorrect syntax...

Joseph (2/27/2008)

---

actually we are audience.. we do Development, operations, monitoring etc.

Actually A to Z things which are going on server or database ;)...just kidding..

Basically we need to monitor server health...

Anyone have any additional input on this topic?

Thanks

Make a custom role in the database, grant execute to the role, and then give the user access to that role.

Being a DBA, there wasn't much value for me in terms of "how does the server currently look" as that responsibility was usually held by the operations folks. It was...

So, basically you're trying to restore a database?

Have you tried restoring a database from another location (different location, different backup)?

It sounds like the account running SQL server does not have...

See attached.