george sibbald (3/6/2013)

---

I've not heard of anyone else changing server names and switching test and prod environments as part of an upgrade cycle. Keep prod as prod and test as...

Lowell (3/6/2013)

---

if the view "dbo.myview" references any objects in another database, a linked server or a schema different than dbo, then that's breaking the cross database chain.

i suspect it's a...

how can I find out the owner of a view or the owner of table,

I click view- property, I don't see anywhere says owner?

Thanks

If some user restore database from a copy of backup and give a new name, this is also considered as a new database, then the stored procedure won't notify that.

how...

Thanks all,

We have situation like this;

We have 3 servers, for example they are named as SQL1, (dev)and SQL2(test), SQL3(prod). test and prod are same hardware and RAM.

When doing upgrade...

As a DBA, I often have to rename server name when do the migration to a new server, or to do a Virtual to virtual clone.

By renaming server name,...

Thanks, I think to leave them as the...

george sibbald (3/5/2013)

---

these groups are used to manage security outside of SQL, so I cannot see a reason they cannot be renamed like any other windows group, but I have...

Thanks, that is good...

I checked there no jobs are running in her account start at 9:00 am.

So not sure.

Thanks,

Thanks,

So for this user it happened her password expired on Sunday, so does it mean even it is at sleeping status, it will try to connect itself again to the...

because we have that version downloaded from the volume license site, so I will not use this one.

I just wonder who else ever used it, how it works?

THanks

Yes, I am using the one...

Yes, you are right, it it there. Thanks much!

Thanks, yes, I tried those earlier and knew they all work, but just want to confirm my question on my previous post.