When trying to open SQL File on the web through Internet Explore (IE) sometimes it will show the file right in IE because it thinks
Error 14274: Cannot add, update, or delete a job (or its steps or schedule) that originated from an MSX server.
You can get this error when trying to modify the properties of a Job after the SQL Server has been renamed or cloned into another
Schema Binding: Views
Schema Binding is there to stop the accidentally removal of required columns from a table. If SCHEMABINDING is in the create statement of an object
MCITP: Database Administrator
Just come from writing my 70-444 exam. I have to say I am glad I wrote the 70-443 first, because that test was ALOT of
Database Mirroring: Fully Quanlified Domain Name (FQDN) Error
If you are trying to setup Database Mirroring, it prefers to see a FQDN for the servers when entering partner information. If you don’t you’ll
Granting Execute Permissions
Following code can be used to Grant Execute Permissions to a Database Role, in a database. This is for SQL Server 2000; because in 2000