I'm not sure I totally understand your situation based on the examples that you have given. Your table design(s) show PropertyTracked as an integer, but your examples appear to...

If they should have administrator access to everything then you can add them as an administrator at the top level and that should apply to all levels.

In reality, you should...

It looks like you are experiencing memory pressure as you are consistently seeing low PLE values. You should read, http://www.sqlservercentral.com/articles/Memory/74867/ as it gives a decent outline of how to...

That's a pretty important task to have completing. Can you go into the check database integrity task in the maintenance plan, click the View T-SQL button and post what...

It depends. The 300 number is not a hard threshold and in my experience, on most systems you'll be well above that the majority of the time. Some...

Okay, it looks like you have ReturnMessage as an output parameter in the stored procedure. You need to specify that in the call to the stored procedure. Something...

Are you sure that the JET driver is installed on the server running SQL Server 2005? Are you running 64-bit or 32-bit? There isn't a 64-bit JET driver.

The WHERE clause is applied to each row in a set, so while a set of rows may contain individual rows with ItemTypeID of 1 and 3, there is not...

Lynn Pettis (2/24/2012)

---

Quite an interesting day. I gave my two weeks notice and was basicly told that I would not need to come back. Not that I don't...

rsrinivasan-1006867 (2/25/2012)

---

Sir,

I need your help recommendation. I have a database in SQL 2008 and size of the database is around 400gb and the transaction log around 120gb (growing very heavily)....

Stefan Krzywicki (2/22/2012)

---

Brandie Tarvin (2/22/2012)

---

Stefan Krzywicki (2/22/2012)

---

I have multiple WordPress blogs (which I haven't updated in awhile). I just set up multiple instances and use each for a different topic....

Brandie Tarvin (2/22/2012)

---

Two things.

1) Anyone here besides me using Google+?

2) WordPress gurus, I'm recreating my website with the WordPress content manager and wondering if I can separate my writing blog...

fahey.jonathan (2/22/2012)

---

It seems that if users are using their own SQL Server credentials to access the database inside an application, they would be able to do so outside the application...

GilaMonster (2/22/2012)

---

Question for those of you who have organised SQLSaturdays

Would you have been irritated if your regional mentor or an organiser of another SQL Sat in the same area had...

fahey.jonathan (2/22/2012)

---

Jack, I disagree that the best bet...