Charles Kincaid (12/1/2008)

---

Jeff Moden (11/29/2008)

---

Some folks store unknown or "open" dates as 99991231 so they don't have to check for null to see if an enddate has occurred in the...

To really help, we would need to see the structure for the table, view, and the code for the function(s) used in the view. Also some test data might...

After looking at the RESTORE DATABASE statement in BOL, I have to say no. You have to restore then shrink the database if you don't want the extra space.

I have to focus on the above, does this mean you don't have regular backups being taken...

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...