This catagory is related to MS SQL Tips.
We will first show movies on how to connect to a remote server using some popular approaches. Our plans of course inlcude some more advanced duties but this support area is not for the advanced coders though we will offer some basic scripts for beginners to stimulate their desire to learn more.
|The server principal "DB name" is not able to access the database "Another DB Name"|
|Here are seven tips on how you might use some of the available tools and techniques to make your job as a SQL Server production DBA easier.|
|I added a maintenance CleanUp task pointing to the right folder|
I checked the include first-level subfolder box, and delete files based on the age of the file at task run time. But the cleanup task is not working, I have to manually go a delete the files myself.
|Saving changes is not permitted. The changes that you have made require the following tables to be dropped and re-created. You have either made changes to a table that can't be re-created or enabled the option Prevent saving changes that require the table to be re-created.|
|I'm unable to get past this error message: The 'SQLNCLI' provider is not registered on the local machine.|
|How can I clear all the rows in a table quickly and easy?|
|How do I fix the problem of SQL Orphaned or Corrupt user?|
|This demo shows logging on Enterprise Manager|
|DTS||Oct 04 at 5:06pm - admin|
|This demo shows how to export data.|