There's no way for the SQL Server to know what USERNAME is set to at the calling clients workstation, unless that host sends that info along to SQL Server.

When you...

The pros and cons of procedures can fill entire books, but in general, I'd say that the concensus is that stored procs are a 'good thing'.

However, it's a tool like...

There's nothing wrong to construct a query based on whatever the userinput is, then when the query is known and complete, just run it from the app.

There's no particular need...

A few 'big deals' that comes to mind:

- opens risk of injection (ie one needs to deal with it properly)

- violating security models/policies (ie is it kosher to grant access...

Seems like the confusion is about how to enter the date into the variable?

And also maybe combined with confusion on how a datetime is presented when retrieved from a variable...

If an order by in a view is 'sense' or 'nonsense', that's a theoretical question.

According to theory, if we want a table, then there is no order.

If we have order,...

A torned page detected is a sign of hardware malfunction or some other unexpected event preventing a write to the database to complete in a clean way.

If you depend on...

Don't know if this makes it any clearer...

In master you have the login, and the login has the password.

In the user db you have the user, and the user...

My personal favoite is xpsmtp

http://www.sqldev.net/xp/xpsmtp.htm

No, MAPI, no Exchange requirements, no funky stuff, just plain simple SMTP 😀

/Kenneth

Deadlocks is a 'bad design' issue, not a performance issue per se.

It's 'fixed' by re-designing the process that is found to be the cause.

What about disk-configuration?

Does the box have a...

Could be a number of different reasons...

Go to Google, type in 'SQL Server error 17803 Insufficient Memory Available' and see if any of the results apply to your situation.

/Kenneth

This is a severe error, and indicates that the db is likely in an incosistent state (suspect/corrupt)

-- quote BOL --

If a torn page is detected, an I/O error is raised...

bledu (10/1/2007)

---

why?? I have never seen a case... being used in an Order by.

if you want to do that stuff the way you want i think you are better...

My guess is the errormessage in this case would be 'screaming developers' or similar 😀

Could you please post the DDL for these two tables?

(and perhaps also with a few sample rows that shows what the actual data look like)

I'm not quite getting how they...