The account has full rights on the SQL folder and subfolders (and tempdb.mdf) and relevant regostry keys so that's not the problem.

The Enterprise Manager advice sounded promising  so I changed the...

Thanks Shawn, I've had a quick look at the article and it sounds plausible. So it's down to my misunderstanding of the difference between   global and local Windows groups - a little knowledge...

No experience on 2005 but we have several Sybase Linked Servers on our SQL Server 2000 boxes. No XML Options but we can't get the 'Simple Provider' to work.

Instead...

I doubt there is anything wrong with sp_password or Change Password in EM so look more closely at what you are doing. Are other  people definitely connecting to this instance as...

Hi Pavan

No logs store this information I'm afraid. As it's a Development Server I guess several people have sysadmin access which makes your detective work harder.

2 suggestions though:

(i) Save time by...

It's not possible to change DTS package names - strange but true. Craig's Save As... suggestion is the best workaround that I know.

or even sloppy coding (sloppy message posting as well).

I would also advise caution with MS Access, even with 'expert' users, in fact, especially with expert users as they're the ones who write the complicated queries.

Take a look at MS Reporting...

Sorry to be blunt and I know you are new  but this 'policy' is REALLY DUMB. The data files won't back up unless the SQL Server is shut down, even...

I can only echo Gabor's comment - why are you doing this? 50 Mb a minute is 3 Gb an hour, 72 Gb a day, 2 Tb a month, 24 Tb a...

There must have been something in the air yesterday, I did exactly the same thing! Working quickly under pressure on a production system I ran an update but..... didn't highlight the last...

I value a 'relevant' college education (e.g. CompSci, Maths) very highly. I ended up in IT after a general social sciences degree and then, after several years, did a part...

That set of functions starting with CHARINDEX is clever! I've already cut & pasted it into my box of tricks.

Profiler is very useful but it produces a lot of output, you will have to experiment with the filters to produce useful results. Maybe do a few databases at a...

I would use the REPLACE function to remove blanks from the address and postcode:

REPLACE(address1, ' ', ''), REPLACE(postcode, ' ','')

but I can guarantee there will still be loads of duplicates...