I am not reindexing it daily, currently around every 2-3 weeks.

Thanks

PS, Still not sure if this is the best method to use.

It does work, but if anyone has another method which may be more efficient, then please post a reply.

thanks...

Sorry, I got it to work with a small change to the method I just said didnt work! :blush:

If anyone's interested;

Update a

Set Transferflag=1

From

EmployeeMasterHoldingArea a

Inner Join

[osp-sq1].cutover.dbo.cutovertransfer b On a.EmployeeMasterPayrollNumber=b.employee_ID

*(With...

I have a function which I use to split the address on a few databases (It is separated by a carriage return, so just amend the code to have a...

Apologies it should have read "set transferflag = '1' ", not empcode...

But yeah, I think I should be able to figure it out from that.

Thanks for your help 🙂

Ah yeah, Reporting Services is the easiest solution and is available for SQL Server 2000.

Visual Studio to define the Report, and Report Manager to configure a subscription to any email...

SELECT name, xtype

FROM dbo.sysobjects

WHERE uid = USER_ID('dbo')

Substitute dbo for whatever DOMAIN\USER you want to query on.

Run this in query analyser and select the DB from the dropdown list.

alternatively, add the...

Are you using an admin account when you RDP into the server, whilst using a different account when trying to run the package locally?

(Windows authentication?)

May be that the account you...

If you can ping the server when the error is being returned, then it is likely to be a security/credentials issue.

Is the error returning when you are just trying to...

Your best bet would be to create a DTS package, with your specified query, outputting to an excel file.

If the person receiving the data is an internal person, you could...

You'll have to make sure you choose an account with relevant permissions set up to access all the folders it needs to, with read/write access also.

Go to the local services on the server (Right Click on my Computer -> Manage -> Services) and then right click on the SQLSERVERAGENT service and go to the logon...

To quickly identify locks use Query Analyser and sp_who or sp_who2

If you have a couple of tables central to the transactions of a couple of users, then the chances are...

http://support.microsoft.com/default.aspx?scid=kb;en-us;304101

Check out this post:

http://www.sqlservercentral.com/Forums/Topic224573-5-2.aspx

It may provide some help.