SQL Sever Management Studio for SQL Server 2000
We use mostly SQL Server 2005 but have a few SQL Server 2000 servers laying around. Is there a SQL Server Management Studio like application for SQL Server 2000? Thank you. ...
sql-server-management-stu
SQL Server 2005 Caching
It's my understanding that SQL Server 2005 does some sort of result or index caching. I'm currently profiling complex select statements which take several seconds to several minutes to complete. My problem is that a second run of a query never takes more than a second to run even if I don't alter it. I'm currently using SQL Server Manage...
Paste into SQL Server table via Management Studio 2005 and keep line endings
I cannot get this to work. I have opened a SQL Server Express table in SQL Server Management Studio 2005. When I try to paste a multiline text snippet into an NTEXT field it gets truncated to only include the first line. In Access these kind of things works, what should i do? ...
SQL Server Management Studio solution vs Visual Studio Projects
Almost all of our projects involve a web application or winforms application and a data access layer (class library) and stored procedures/database scripts. We are looking for a good way to organize the solutions, and found a few ways: 1)We could have a sql server management studio solution for all the db related things, then have a vi...
SQL Server Management Studio-- widen active files dropdown?
Hi everyone, I'm using SQL Server 2008's management studio and had a question about having multiple query windows etc open. If I have seven or eight going at once obviously their tabs won't all fit on the screen. But when I go to the "active files" drowpdown at the right often times the names are truncated with an ellipsis in the midd...
Hide/Filter tables in SQL Server Management Studio
I have a SQL database that has several hundred tables in it, but I only need to work with a few. Is there a way to hide most of the tables from view within SQL Server Management Studio 2008? Another option would be to create some sort of grouping that would only reference the tables I'm interested in. Filtering the tables works, but I...
"collapse all' or "toggle outline" in SQL Server Management Studio 2008
A new feature in SQL Server Management Studio 2008 is 'outlining' (the ability to collapse regions). It is awesome. However, by default all regions are expanded. I can't seem to find a way to 'collapse all' (also called 'toggle outline' in Visual Studio). Is anyone aware of a way to do this? I've been tasked with reviewing a 3,000 l...
Why is SQL Server Compact Edition missing from the list of server types in SQL Server Management Studio 2008?
I have both 'SQL Server Compact 3.5 Service Pack 1' and 'SQL Server Management Studio 2008' (SSMS) installed on my PC. In the past, I was able to select 'SQL Server Compact Edition' from the list of 'Server Types' in the 'Connect to Server' dialog within SSMS. This entry is now missing and I have not been able to restore it. ...
Copying a table from one SQL server and DB to another using SQL Server management studio
I have a website I have developed using a databse and I have created some security on the site. This ceates another DB called ASPNETDB.MDF. The main site database is on a server at the website host. At this time the aspnetdb is in the APP_DATA folder of my website. I want to copy the tables and their data from the aspnetdb to the main ...
View all ntext column text in SQL Server Management Studio for SQL CE database
I often want to do a "quick check" of the value of a large text column in SQL Server Management Studio (SSMS). The maximum number of characters that SSMS will let you view, in grid results mode, is 65535. (It is even less in text results mode.) Sometimes I need to see something beyond that range. Using SQL Server 2005 databases, I often ...
The quickest way to find the ForeignKey is related to what table in Management Studio?
Hi, I wonder if there is a quicker way for this: *"I have my Management Studio open and I have a Db table with manes of columns listed in front of me. I know FK_SomeTable field is a ForeignKey. But I do not know it is an FK on what table. And I need to learn that."* So, normally I open the "Relationships" of that table, go one by one...
what does Sql Server Management want to save into "Solution1"?
what is "solution1"? what is it for? When I exit ssms, it asks me to save something under Solution1 David ...
Any benefits to SQL Management Studio 2008 when only connecting to SQL Server 2005 databases?
We run SQL Server 2005 exclusively for databases that we use (I'm trying to push to get them upgraded, but alas!). On the client side with Management Studio, are there any benefits to upgrading to SSMS2008 when only connecting to SQL Server 2005 databases? I've seen that Intellisense won't work, so I'm curious if it's worth the hassle. ...
Saving changes after table edit in SQL Server Management Studio
If I want to save any changes in a table, previously saved in SQL Server Management Studio (no data in table present) I get an error message: "Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can't be re-created or enabled t...
SQL Server: enable remote connections without SSMS
I've got a SQL Server Express 2008 install on my web server, which by default does not allow remote connections (probably a good thing.) I opted not to install SQL Server Management Studio Express along with it for disk space and other reasons. I need to enable remote connections but any instructions I can find involve using SSMS to ch...
Marking persisted computed columns NOT NULL in SQL Server Management Studio
It is possible in SQL Server 2005 to create a computed column that is both persisted and is defined as NOT NULL (cannot contain a null value). The 2nd attribute is of importance when using libraries like Linq2Sql if we want to avoid a lot of manual work to assure our code that the column 'always' has a value. With straight SQL this is v...
Protecting system databases in Sql Server Management Studio?
For the five hundredth time, I ran a sql script in management studio to add some tables to a database and FORGOT TO CHANGE THE DATABASE IT RUNS AGAINST. Since it defaults to master, I had to go and drop all the new tables I just added. I practically never run sql scripts against the master database or other system databases, yet in Man...
Is it possible to auto-indent a query in Sql Server 2008 Management Studio Express?
I mean, something equivalent to Ctrl + K + D from Visual Studio that automatically indents code. Is there something in this sense? ...
Change the location of the Auto Recovery information in SQL Server Management Studio.
Our local IT has our My Documents folder on a network path. This causes a problem from MSQL Server management studio as it saves it auto recovery information every 10 min it will lock up as its doing its save. I found where VS2008 saved its setting but I can not find out how to change it out of My Documents for this. Does anyone know w...
Cannot Open table from SQL Server 2008 on SSMS 2005
I am using SSMS 2005 on my local workstation and have not yet installed SSMS2008 on it. When I connect to a SQL Server 2008 instance and try to "open" a table from SSMS2005 I cannot open. Instead I get an error (popup) that says: Unspecified Error (MS Visual Database Tools) I have tried this on 2 SQL Server 2008 Instances, I ...