How to check date of last change in stored procedure or function in SQL server
I need to check when function was changed last time. I know how to check creation date (it is in function properties window … Read more
sql-server-2008
How to connect to local instance of SQL Server 2008 Express
I just installed SQL Server 2008 Express on my Vista SP1 machine. I previously had 2005 on here and used it just fine … Read more
How to restore to a different database in SQL Server?
I have a backup of Database1 from a week ago. The backup is done weekly in the scheduler and I get a .bak … Read more
SQL Server principal “dbo” does not exist,
I am getting the following error Cannot execute as the database principal because the principal “dbo” does not exist, this type of principal … Read more
Sql Server ‘Saving changes is not permitted’ error ► Prevent saving changes that require table re-creation
When I create a table in SQL Server and save it, if I try to edit the table design, like change a column … Read more