They were fully qualified, and they are going into the correct database. They were meant to be stored in master per the company standard policy, and they were. ...

Well, I stand corrected in 2K at least. I have only used 2K5 for a while now, but always good to learn things I didn't know before.

Can you provide more detail? Its hard to say much based on this so far.

Ah, of course, you have to love all of the new features. 😉

That it is....

I know what sp_ms_marksystemobject does. Maybe it would have been more clear if I had said I only use create procedure and that is all. Some of...

No, I always use create stored procedure Name

Assuming all your harddisks have that much free space available, I don't see any reason not to stay with what you have.

TaffyLewis (12/14/2007)

---

select t1.A, t1.C, t2.C

from t1 inner join t2

on t1.A = t2.A

and t1.C = t2.C

t2.c is the date field

When I try to run the Max on this I generate...

If you are a stickler for avoiding error messages like I am you could add xp_fileexists to Jeff's piece to avoid...

TaffyLewis (12/14/2007)

---

I've been trying to get this query to work all afternoon.

I have 3 fields A, B and C in a table. Field C is a datetime...

The first big question is if the company has a policy regarding access to certain information. I have dealt with institutions that require certain people be notified any time...

I have seen similar issues and do not have a true solution, but a possible work around would be using xp_cmdshell with the script that is sending the mail to...

If you can add a column which differentiates which table is which in some fashion, something as simple as a column that directly lists a table name or perhaps giving...

The first thing to do is create a stored procedure to actually accomplish the deletion for you and test it safely. IT could be something as simple as :

create...