If you want to use a share, then the user that is doing the restore needs permission to access the files located at the share, which is what has already...

look up

fn_listextendedproperty

sys.extended_properties

for viewing extended properties

Yeah I would agree with that, as a starting point.

I suppose it depends on what you are trying to achieve, Are you working as a SQL DBA, or just doing dba duties. Is your experience and knowledge sufficient for...

GilaMonster (10/29/2009)

---

Some background first.

Project was started late last year, it was open to all MVPs (regardless of technical speciality) providing they...

run this

select [name],state_desc from sys.databases

maybe you need to refresh your view on the databases

Are you sure that the restore has completed successfully.

I dont see with recovery in your script.

What you could do is

restore database [databasename] with recovery

If you want to play around with permissions, wouldnt it be easier not to use any of the database roles, and just grant select permissions to the objects that are...

ok..

juts to confirm something for me. if you go into SSMS, navigate to the database in question, expand the tables, you should see, based on your query.

zs1.v107 in the table...

Can you...

This is a duplicate topic, I take it, the answers in your other topic didnt help?

Well funnily enough I had a pre-screening telephone call today, pretty much a first for me. twenty questions and the answer was true or false for each question. apart from...

Michael Valentine Jones (10/28/2009)

---

Even if you have concerns, what can you really do about it?

Are there any laws that restrict where a security camera can be pointed when it is...

@wes

hmm, interesting I have seen the link before but it isnt a 100% fix, it doesnt work in all scenarios.

neither does fixing the min and max....

Florian Reischl (10/28/2009)

---

I think, we can forget the hardware problems (spoke with our DBA). We just had a larger maintenance some weeks ago. Whenever we have a maintenance we switch...