check the share permissions as well as the NTFS permissions. A share defaults to Everyone - Read!

check out my 3 part guide on this site at this...

tell them its not preaching its fact!

don't know how many times it's been said but "Don't order by in a view" 🙂

A view is essentially...

i pasted but it did nuttink. have corrected it now 😉

Rod at work (10/24/2011)

---

OK, simple question here, but I need to ask it. I was under what must be a mistaken thought that traces could run only against 1...

are you saying the view definition is created upon a select statement...

don't forget to set the rollover option too, by default it scripts out to zero which means no file rollover. This puppy catches a lot of people out. Also be...

if you're unsure, use a server side trace for a week or so to monitor user connections before decommissioning

dajonx (10/21/2011)

---

we also have an asynchronous database mirror to the backup site. The reason I would like to have full backups on-hand is for DBCCs, archive certain data, and...

Brandie i have seen similar to this before, what is the recovery model of the database, if full do you take transaction log backups of this database?

PhilipC (10/23/2011)

---

I'm getting this message on some of my newly built SQL 2008 R2 servers and I'm just wondering, is it a good idea to grant this permission or not?

I...

If you're having troubles with other external connections you may use the following to start sql server single user mode and only accept a connection from SQLCMD

sqlservr -c -m "SQLCMD"...

database user permissions are held in the database itself. You only need to ensure that the server login SID matches the database user and this si what sp_helprevlogin does

vino5786 (10/23/2011)

---

Hi Friends,

I have configured the Logshipping -Copy Job (Which copies tran logs from Primary Server) to copy all the...