We found some article relating to the DTS Wizard which is a good tool to use for exporting and importing db structures. so far we have not found the toolkit for SQL 2008 and assume the 2005 version works with 2008. If you have confirmed this please feel free to contact me and correct this [...]
Error: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Try adding a Connect Timeout in the web.config The Connect Timeout attribute of a connection string determines how long a SqlConnection Object runs before it stops attempting to connect to a server. Reference
You can view the current connections by executing the system proc sp_who2 , if you wish to kill the connection type: kill and the pid number or use ALTER DATABASE ‘DATABASE_NAME’ SET SINGLE_USER WITH ROLLBACK_IMMEDIATE.
OMG : Error : The Save (Not Permitted) dialog box warns you that saving changes is not permitted because the changes you have made require the listed tables to be dropped and re-created. The following actions might require a table to be re-created: Adding a new column to the middle of the table Dropping a [...]
Microsoft SQL Server, Error: 916 Error: the server principal “” is not able to access the database “” under the current security context For those of you that connect to databases that are hosted by 3rd party providers, some of which are accustomed to leaving as many databases in auto-close mode as possible, you are [...]