New answers tagged ssms
I was able to make a copy of a database using SQL Express by choose Backup Database and then choose Restore from database.. quit simple
The problem is that you do not have any control on the contents of recent connections box in SSMS. I develop SSMSBoost add-in for SSMS and I have solved this problem by adding a manageable list of preferred connections. You can simply save frequently used connections and easily switch between them using special combo-box on the toolbar. Hope this helps.
It is still a bug (sql server 2008 - 2012) as highlighted below : SQL Server 2012 Management Studio spuriously forgets password, despite being set to remember it. You can vote up the connect item to get it HOPEFULLY fixed if you are experiencing the bug as well. %UserProfile%\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell\SqlStudio.bin ...
The Express version will not let you save Import and Export packages created through the wizard.
Just tested it on express with advanced services and worked fine! You create the destination table, set a null default on the column and after importing data with the dtsx you remove the default or set it to whatever you want. dtsx import will replace nulls with the default value of the column when you can't check the "keep nulls". create table dbo.test ( ...
Choose to save the package instead of running it right away. Then edit the dtsx file and on your copy task chek "keep nulls". Then run the dtsx. I didn't test it but think it will solve your case.
I saw an item on Pinal Dave's blog recently that may answer your question. He suggests adding the line 127.0.0.1 localhost to your hosts file The full article can be found here I do note, however, the situation he refers to is a machine that is not part of a domain - if your machine is, then this may not solve it
There is no way to "hide" a linked server or prevent unauthorized users from trying to use it. All you can control is whether they actually have access on the other side. A linked server in and of itself is not an actual object; like a synonym, you don't grant access to the alias, just to the thing(s) it references. Try it out, and you will see that some ...
Top 50 recent answers are included