Following on from PhilM99's answer. It sounds like the windows userid you authenticate with does not have access to the server (rsica) across the network. Check your windows security settings.

Peter

test test test

Copy your production database to a test database. Run the vendor supplied update scripts (automatic or manual) against the test database. Get your users to test the new...

It would help if you say what version of SQL you are working on and what database system this 'reference cursor' comes from (or even better, explain what it does).

By...

Try:

select * from tablename a inner join tablename b on a.RecID <> b.RecID and ((a.begin_date <= b.end_date and a.end_date >= b.end_date) or (a.end_date >= b.begin_date and a.begin_date <= b.begin_date))

assuming that 'tablename'...

View the job created for the backup by the maintenance plan. I had a problem with the maintenance plan sometimes not setting up the 'Delete old backups' parameter correctly. In...

It sounds like you can do a dbcc dbreindex for all the tables or a dbcc indexdefrag after loading data. In which case, you should optimise the keys for reading. But if...

Win,

It happens on some days so I copy my response to the clipboard now, everytime, before I press the Post Reply. It could be because the site is busy at...

The composite key is always stored in the index files as fixed length, as far as I know (someone please correct me if I am wrong). Variable length fields used...

If you are restoring the logs you shouldn't specify the mdf file or the MOVE command. The move is only done for the Full Backup restore. Also I have the...

It depends partly on the settings in access. I have access 2002 so it may be different on your version. But in Access go to Tools-Options-Advanced. Make sure youre default...

The 'delayed write error' does indicate that the server the backup was being written to became 'unavailable' during the backup process. You should check if the destination server was rebooted during...

you could also increase the growth factor for the transaction log, in the database properties, and change it to unrestricted growth. If it manages to grow large enough without causing a...

Yes, the network failure would have caused the network to route your access to the destination server along a different (possibly much slower) network route. The slower route will be...

You could also use:

replace(convert(char(5), getdate(),11), '/', '')

which would mean that a UDF isn't needed, unless you really want one. If you are using a UDF you could pass this as...

One straight forward approach is to load your data into a temporary table in SQL server, where the column in question is set up as varchar. Then move the data into your...