0
votes
0answers
89 views

SQL Server Management Studio array size out of bounds & sqldattime overflow errors

The situation I have is we have devs working from outside the network. So they access the network via cisco vpn software. Then connect to the sql server via the management studio. We have 1 dev that ...
0
votes
2answers
3k views

Why Intellisense doesn't work in SQL Server Management Studio 2008 R2? [closed]

I have SQL Server Management Studio 2008 R2. I have tried these: Tools->Options->Query Execution->SQL Server->General, make sure “By default, open new queries in SQLCMD mode” is unchecked Go to ...
1
vote
1answer
2k views

SQL Server 2008 Management Studio - Edit Rows with Where clause

There is an option to edit rows in a grid - first 200 by default. In Tools -> Options -> Sql Server Object Explorer, you can set the value for "Edit Top N rows". I have a table with 200000 ...
4
votes
3answers
2k views

Can I install Microsoft SQL Management Studio by itself?

I installed Visual Studio 2010 on my machine and it installed along with it SQL Server Express 2008. Now I'd like to use the Management Studio, but I can't seem to find it so I assume it doesn't ...
5
votes
5answers
9k views

try to attach to a database file but can't browse folder which contains the file

I am trying to attach to database file (*.mdf, *.ldf) that I placed in the same folder as all my other SQL Server databases. I begin the attach by attempting to browse to the folder which contains the ...
9
votes
2answers
13k views

SQL Server Management Studio Color Schemes?

Is there a way to apply color schemes and themes to SQL Server Management Studio? I really enjoy the ones for Visual Studio 2005/2008/2010 and would love to have something like that. Color Schemes ...
16
votes
5answers
11k views

Is it possible to open a sqlite database from within microsoft sql management studio?

Is there a way to open a .db file (sqlite database file) from within microsoft sql management studio? Right now we have a process that will grab the data from a microsoft sql server database and put ...