I would like to use SQL Enterprise Manager to manage my SQL Azure Databa开发者_JAVA技巧ses. Everywhere I look everyone says that if you want to use the object browser then you need R2.
I\'m working with a SQL server and several databases. Each database may have many schema\'s, such as dbo., admin., other., and I\'m getting tired of scrolling around trying to find things.
Our Sys Admin just installed SSRS 2008 for me to play around with and see if I can get all our 2005 projects running on it. However, when I log onto the report server with SQL Management Studio 2008 t
The table contains a PRIMARY KEY column and another column which is FOREIGN KEY. This works fine. When I attempt t开发者_开发百科o add another column as a FOREIGN KEY I get the following message:
When I try to access a 2005 database in studio 2008 I receive the debugger does not support 2005 or earlier.
SQL Server Management Studio always inserts a GO command when I cr开发者_JS百科eate a query using the right click \"Script As\" menu.Why?What does GO actually do?It is a batch terminator, you can howe
All of my tables have certain audit columns (CreateDate,CreateBy,UpdateDate,UpdateBy) Since t开发者_运维知识库hey just take up visual space, is it possible to somehow hide these columns so they do no
Using the SQL Server Import and Export wizard in Management Studio 2005 I\'ve encountered a big problem. After selecting a set of tables whose data I want to copy (specifying Delete Rows in Existing T
I\'m trying to debug the source of a SQL timeout in a web a开发者_JS百科pplication that I maintain.I have the source code of the C# code behind, so I know exactly what code is running.I have debugged
On a per-object basis, SQL Server Management Studio has the option to script the object to clipboard, file, etc.Is there a way (at the database level) to do a \"1-cl开发者_StackOverflow社区ick\" expor
加载中,请稍侯......