Good catch Gail. I didn't think of asking what compatibility mode the database was using.

I have to agree as well. Also, if you have the database using full recovery model, you should also be running regularly scheduled transaction log backups. That will...

Can you run the following code snippet in your database?

SELECT

object_id AS objectid,

index_id AS indexid,

partition_number AS partitionnum,

...

You should be able to find in the following location in the object browers in SSMS:

Databases\System Databases\master\Programmability\Functions\System Functions\Table-valued Functions

Simon Lidberg (12/1/2008)

---

MSDN licenses can be used for development, test, and demonstration purposes. However they are licensed on single-user basis only. This means that every user accessing the server has...

I have to get in on this. Are you actually going to look at hiring a consultant to rewrite this procedure? If so, I'd like to make a...

Application roles aren't assigned to users.

From Books Online:

An application role is a database principal that enables an application to run with its own, user-like privileges. You can use application roles...

torpkev (12/1/2008)

---

Hi all,

I have a database that I do transaction log backups every 4 hours on, and nightly full backups. My transaction log's are normally in the <200k range,...

As I said, the final authority on what licensing you need is really with Microsoft. I'd contact them and explain your environment, and determine the proper licensing requirements for...

See, I knew someone would have a better solution. I know, here's my excuse, it's early and the family is decorating the Christmas tree and the fights are just...

dubem1 (11/30/2008)

---

Hello all.

it's my first post here. I hope someone will help me

I have a trigger fireing on inserting in table1

I have this query to duplicate some rows...

I am definitely enjoying my 5 day weekend (except having to get up at 3:00 AM Friday morning!)!

Wouldn't it be great to get what we get paid and only have...

Sometimes even those of us with lots of points to left need help. Heck, I think I even have seen Jeff post a question or two here.

I was stumped...

Actually, I think she was saying that unless necessary, derived tables only exist in memory.

GilaMonster (11/29/2008)

---

rbarryyoung (11/29/2008)

---

I don't really have a problem with someone who has a bunch of certs asking questions on methodology or approach. IIRC, the certs don't really test for...