This assumes that none of the above are installed. If they are remove them from your system if you are not sure they are working correctly. [Read More]

Assuming you have an open socket for doing the transfer (and without the correct try..catch error handling you require): [Read More]

You can get the name of the log file for your database by looking in the sysfiles table. [Read More]

You can use cursors in SQL Server stored procedures to process data already in the database and take action accordingly. These can be used just like recordsets within standard code - for example: [Read More]

For example, to change the owner of table MyTable to user MyUser, just run the predefined stored procedure sp_changeobjectowner: [Read More]