If you are going to use maple syrup please at least make it REAL maple syrup, not Mrs. Butterworth's or something else like that.

Real Maple Syrup and bacon.....two...

I've got his book. It's...

Sorry, I forgot we were talking about Report Model. I'm not very experienced with Report Models so I don't know if there is a way to force that to...

harry79 (8/6/2010)

---

Thanks all for your reply.

But i do have quick question, how can i start at 12:00 everynight and finish at 6:00 AM with some delay so it wont overwhelm...

In order to limit the users that way you need to know what State they are in. A simple example would be:

CREATE TABLE dbo.users

(

userid NVARCHAR(128),

state_code CHAR(2),

CONSTRAINT PK_users PRIMARY KEY...

GilaMonster (8/6/2010)

---

There's nothing wrong with Access when used appropriately. The problem is it's seldom used appropriately.[/q

I agree that there is a place...

The error is telling you that the stored procedure expects 2 parameters to be passed in to it when you call it and you aren't passing the parameters when...

Here you go:

SELECT

SSM.definition

FROM

sys.server_triggers AS ST JOIN

sys.server_sql_modules AS SSM

ON ST.object_id =...

How would you determine what state the user is in?

It looks correct to me.

A user without a login can be used to grant access for other users to do things that they don't have permissions for. For example, if you use stored...

Good luck, I'm sure you'll do great at the new job.

Lynn Pettis (8/5/2010)

---

Good luck!! And don't worry,...

This is a duplicate of this post http://www.sqlservercentral.com/Forums/Topic964054-391-1.aspx, which is where I answered the question. I'm not going to duplicate my post here, but I am going to edit...

Stefan Krzywicki (8/5/2010)

---

I once inherited a program (VB6) where the original programmer had 7 or 8 or 9 indexes on every table in an Access database. If that wasn't bad...