Stack Overflow
Stack Overflow

Questions tagged [ssms-2005]

13 questions
35
votes
13 answers

cannot connect to pc-name\SQLEXPRESS

While trying to connect to SQL Server 2005 Standard Edition through SQL Server Management Studio 2005 I get the following error: I put all my effort to solve this problem but there is no solution. On stack overflow in the following post I found…
Waleed Ehsan
  • 365
  • 1
  • 3
  • 8
25
votes
2 answers

How to get DOMAIN name from SQL Server?

I tried using EXEC sp_who2; to find the server's domain name, but it gives host, users, etc. I need to know my SQL Server's domain name, so I can install a plugin to the SQL Server Management Studio.
Fandango68
  • 4,461
  • 4
  • 39
  • 74
2
votes
2 answers

SQL Server Management Studio equivalent for CTR+L keyboard Shortcut from Visual Studio

I have not been able to find the equivalent shortcut key to Ctrl+L used in Visual Studio (to cut and copy a line) in SQL Server 2005/2008. I find Ctrl+L to be very handy. Does anyone know a keyboard shortcut to cut and copy a line in SQL Server…
NewUnhandledException
  • 733
  • 2
  • 10
  • 34
1
vote
1 answer

Regex find not working in SSMS query window?

I'm trying to find the next BEGIN or END without missing any, so I want to search with a regex in the find. I want to find the next BEGIN or END. For some reason it's not working. What's wrong with what I am doing?
richard
  • 12,263
  • 23
  • 95
  • 151
1
vote
0 answers

SQL Managing Database copies at change of year

Microsoft SQL Server 2005. I have quite a lot of experience with day to day writing of SQL scripts, but am less familiar with SQL Admin tasks. I have inherited a couple of 3rd party systems that require databases to be copied at the end of financial…
MiguelH
  • 1,415
  • 1
  • 18
  • 32
1
vote
1 answer

SQL Server Compact Edition and SQL Server 2008 Management Studio

I've been googling for hours now. I installed: SQL Server Compact Edition version 4.0 SQL Server 2005 Management Studio I could connect to SQL Server CE with 2005, but had no Data Import Wizard to get my Access 2007 DB into SQL Server CE. So - I…
cb seo
  • 103
  • 12
1
vote
1 answer

Integrating CVS with SSMS 2005?

Currently, I produce various .sql scripts (sprocs mainly) and have to copy them to another location where I had originally checked out a CVS project before I can add/update/remove the CVS repository accordingly (using TortoiseCVS). It's tedious, so…
OMG Ponies
  • 325,700
  • 82
  • 523
  • 502
0
votes
2 answers

Error while connecting to external SQL Server with an IP using SQL Management Studio 2005

Error while connecting to external SQL Server IP using SQL Management Studio 2005 address TITLE: Connect to Server Cannot connect to 1.2.3.4\SQLEXPRESS. ADDITIONAL INFORMATION: A network-related or instance-specific error occurred while …
D Infosystems
  • 514
  • 1
  • 12
  • 44
0
votes
0 answers

SSMS: Bit column defaults to Expression when Group By is desired

(Tested in SSMS 2005 & 2014) When I have a table or view open in Query and View Designer and I turn the Group By feature on, any bit columns defaults to Expression. Is there any way to change this (by options/settings, registry tweak, or other) to…
InigoMontoya
  • 49
  • 5
0
votes
0 answers

SSMS Run a specific Query in SQL Query Editor Based on Highlighted Table / View

When writing SQL, I constantly find myself checking the structure of a table / view or selecting the top 100 rows to get a preview of the data. For instance, when I have something like this (and I have forgotten the structure of…
JoeFletch
  • 3,820
  • 1
  • 27
  • 36
0
votes
1 answer

Relationship Diagram / Schema with selected tables

I am wondering how on Microsoft SQL Server Management Studio 2005 can i create a relationship schema with selected tables i am using on a certain part of a website i have built. I want to see what fields they have and how they are connected.
Paul Kirkason
  • 227
  • 2
  • 4
  • 20
0
votes
0 answers

SQL Server 2005: Arithmetic overflow error converting int to data type numeric

I have to filter a column called [Order] (data type = decimal(3,1)) in my final view for 1.0. List of unique values for [Order] are: 1.0 2.0 3.0 4.0 5.0 7.0 8.0 9.0 11.0 12.0 13.0 My SQL Statement is as follows: SELECT [Order] FROM …
InigoMontoya
  • 49
  • 5
0
votes
1 answer

Cannot connect to Reporting Services 2005 Server from SSMS

We have SQL Server Reporting Services 2005 (SSRS) installed and running just fine. I can connect via SQL Server Management Studio 2005 using "Connect -> Reporting Services" and "Windows Authentication". When I am connected, I can bring up the server…
Tod Birdsall
  • 17,877
  • 4
  • 38
  • 40