MS-SQL-Tips

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.
Microsoft SQL Server, Error: 916Jun 16 at 9:28am - admin
The server principal "DB name" is not able to access the database "Another DB Name"
Hits: 16713 

Tips for SQL Server DBAsJun 16 at 8:56am - admin
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.
Hits: 3452 

SQL Maintenance Cleanup Tasks does not workApr 28 at 6:24am - admin
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.
Hits: 2149 

Error SQL Server 2008: "Saving changes is not permitted"Apr 28 at 6:23am - admin
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.
Hits: 1769 

SQLNCLI Provider cannot be foundApr 24 at 9:19am - admin
I'm unable to get past this error message: The 'SQLNCLI' provider is not registered on the local machine.
Hits: 5343 

Truncate TableMar 15 at 5:44am - admin
How can I clear all the rows in a table quickly and easy?
Hits: 3223 

Backup SQL 2005 Express Dec 14 at 8:16am - admin
Backup SQL 2005 Express
Hits: 1216 

SQL Orphaned or Corrupt user Dec 14 at 7:49am - admin
How do I fix the problem of SQL Orphaned or Corrupt user?
Hits: 1174 

SQL 2005 ExpressDec 14 at 7:46am - admin
Attaching to SQL Express
Hits: 1533 

SQL LogonOct 07 at 4:55pm - admin
This demo shows logging on Enterprise Manager
Hits: 1289 

DTSOct 04 at 5:06pm - admin
This demo shows how to export data.
Hits: 1112