if the rows are delimited by CRLF all you have to do is COUNT the number of CRLF in the file and loop through all of them.

This is Fairly easy...

See my post on the Double posted thread

if the idea is to put information into the log only you may want to use xp_loginfo

quote:

---

... , AND maybe AS with WITH ENCRYPTION AS.

---

Be careful with THAT replacement...

DOCUMENTED IN BOL :

xp_logevent

One suggestion:

Can you create 4 columns that get populated at the Update or Insert time from the visit date column. With that you will get rid of MOST your converts!!

and...

Frank Kalis would recommend you read this

Frank are you there?

quote:

---

The only thing I'll say about alias is if you have to later drop the login, you may be tearing your hair...

quote:

---

Thank you very much! It is almost what I need.

I have approximately 2 million ID's, and I need the MAX(year) for each...

db_ddladmin as Brian said is the answer to the first problem

there are two things you can do to take care of the ownership

1. REPLACE OBJECT OWNER

at the end...

can you specify what kind of error are you trying to catch?

I can't wait for yukon structured exception handling

if the package owner has password protection and you don't know it, AFAIK you are out of luck

but if no owner password was assingned all you have...

SELECT LEFT(Manager_Name, CHARINDEX(' ', Manager_Name, 1) -1)

The Concern here is that cascade delete is a VERY destructive action.

Suppose you have a hierarchy of 3 tables and all are "cascade enabled on delete" and you delete...

You haven't show me any examples but I think

you can create 3 separated table-valued functions based on parameters.

with that in mind you can use those as Parameterized Views

and your...