permission problem. check for regidtry, folder and system permissions for the service account.

you can't change collation at server level. but you can change the collation on particular columns. also changing collation on the database only makes the collation effective for columns to...

Any recent changes to your server. Did you read the error log of sql and the eventviewer to find the errors of the service.

DBCC SQLPERF(logspace) will give u only the details of the log file. u can check it using sp_helpdb and check the size parameter. most likely you need to truncate the...

you can use redgate tools to do that. tools like sqlcompare can do that for u which checks for data changed and then change only those rows

Do you need to delete that from the source server or the destination server.

check if there is any program like AV tat is blocking you to send attachments from slq server.

could you post ur delete stmt here. if you don't want to make it public then you can write a private message too.

check if the table is heavily indexed. if so try updating stats. then do the delete. i think the table would be heavily frgmented check for that too. it shld...

Did u find any locks in the table. Then is the table having any triggers in that. if so disable them and then try running against the table.

It all depends on your servers hardware strength and performance. mostly running them in single machine will be no problem unless something is messed up.

What is the job trying to do. From the error message i see that you are tryig to access a fie that is not there. Also are yu trying to...

Can yu post us the error that you get. it would be helpful for us to give any suggestions.

Ramesh,

You can also use opendatasource to query remote servers. try that if u need it only for the hour else go for linked servers for permanent solution.

You can use th script named database detais available in the site http://www.sql-articles.com