I hate to suggest it but ... trace?

You are executing the sql loged in as yourself with Windows authentication?

That would be my guess - can you update the workbook using Excel in it's remote loacation?

Possibly DTS, store proc in another database?

I think you can use a named range or a sheet - im not sure but if the name ends in a $ then it's a sheet if not it...

Hi Charles - a colleague of mine used the following to access a remote Excel workbook and it works fine.

SELECT *

FROM

OPENDATASOURCE ('Microsoft.Jet.OleDB.4.0', 'Data Source= \\MANMEA0007\Transfer\UPS3\Inbox\CampaignStamping.xls;extended Properties=''Excel 8.0;IMEX=1''')...CampaignStamping$

Hi Ilan,

SQL server 2k does not have the concept of a row number (unlike Oracle or Access). Sql 2005 has a ROW_NUMBER() function that outputs the row number of the...

Perhaps your question is not understood. I think you are trying to get a row number. Is that correct? If you post some sample data I'm sure someone will help.

Are you trying to get the row number or get a count?

This will get you a count - sql(2k) does not have the concept of rownumber. sql2k5 does have a...

You will probably get a few different views on this but for my servers.

Restricted file growth - I dont want the server going down because the os has run out...

AFAIK User defined functions have to be invoked with at least a two part name dbo.fnMyFunction

To the best of my knowledge droping a table will drop all associated objects.

Is the constraint DF_PartyAltID_DateCreated definately on the table PartyAltID?

I think contraint names have to be unique within...

On sql2k I think you are limited to using an IDENTITY - on 2005 you have a ROW_NUMBER() function.

I think the minimum you need is for your operators to be a member of db_ddladmin however this role probably has too many priveliges for your liking. You could put...

A good one I picked up was not to use plurals. E.G use Week not Weeks