All Questions
Tagged with sql-server-2005 ssms
159
questions
0
votes
0
answers
889
views
Cannot connect to server - An existing connection was forcibly closed by the remote host
I have updated my PC to Windows 11 Pro ver 22H2, Os build 22621.1
After this update, I cannot connect to SQL Server 2005 from SSMS v.18.4
Client OS: Windows 11 Pro ver 22H2, Os build 22621.1
Client ...
- 12.7k
0
votes
1
answer
129
views
I need to get top 5 record from SQL Server query but count of all record which satisfy the where clause condition
select count(1)
from chatmessage
where ChatThreadId in ('A84B95F5-10E7-483C-A4C7-73EF4CBF48EC',
'85DAFD40-697C-486C-BB3B-86357CFF6A36',
'85DAFD40-697C-...
- 129
-1
votes
2
answers
380
views
How to compare two date values in SQL Server?
I have a table with the date 2018 and date 2019 and here is my data.
select amount, date
from TABLE1
where date in (2018, 2019) and empid = 21120
It didn't work for me as the query says case when ...
- 17
1
vote
1
answer
145
views
SQL Server : designer incompatible generate script
We have a SQL Server 2012 for our test box, and a SQL Server 2005 for our production box. Recently, we moved to automated deployment scripts which execute SQL scripts as part of our deployment process....
0
votes
2
answers
80
views
SQL Server : how to do mathematical computation for the values in one column
I have written this query:
SELECT
'APRIL _DATA_PASSED Only' AS 'ONE MONTH Audit_name',
SUM(count2) AS Audit_count
FROM
(SELECT
vCCSF.ClientName,
s.Name as SupplierName,...
- 67
-1
votes
1
answer
222
views
To remove the special character from the column using recursive CTE method [duplicate]
I have a table like this :
|----------------------------|
| CardCorporateName |
|----------------------------|
| ~$%/*dfgdggf/*( |
|--------------------- ...
- 192
0
votes
0
answers
111
views
When I try to create a new database in Management Studio I get this error message
When I try to create a new database in Management Studio, I get this error message
TITLE: Microsoft SQL Server Management Studio Express
Cannot show requested dialog.
ADDITIONAL ...
0
votes
1
answer
190
views
Test Connection for LinkedServer in SSMS failed on Client, not on the machine
we are runninng a MS SQL 2005 Server and installed the Oracle driver 'Oracle Provider for OLE DB'
With this driver we setup successfull a "Linked Server" to an 'Oracle 10g Enterprise Database'.
...
- 40
0
votes
1
answer
150
views
I am trying to backup a database and am getting MSG 3013
I have tried to backup in Microsoft SSMS with the GUI backup task, and it fails after a few seconds, so then I tried running this command:
BACKUP DATABASE databasename TO DISK = 'd:\databasename_full....
- 25
2
votes
1
answer
3k
views
Index GUI Issues with SSMS 2014 and 2016 when working with SQL Server 2005
We currently work with all versions of SQL Server from 2005 onwards. To save time I try to do everything in a single version of Management Studio. This also helps if running newer client operating ...
- 3,253
0
votes
0
answers
700
views
An Error Occurred Attempting To Delete Row 6 - SSMS 2014
No Rows were deleted.
A problem occurred attempting to delete row 6. Error Source:
Microsoft.sqlServer.Management.Data.Tools. Error Message: The
updated rows has changed or been deleted since ...
- 1,967
1
vote
2
answers
822
views
SSMS 2014 - Cannot insert multiple values into table variable
This is probably something really trivial I'm missing, but I can't seem to figure out why it's not working:
Basically, this works:
DECLARE @names TABLE (name NVARCHAR(100));
INSERT INTO @names
...
- 5,625
2
votes
2
answers
103
views
View executed sql from dynamic sql
I've inherited a complicated application that uses a lot of dynamic SQL. Many of the stored procedures construct and execute significantly different SQL statements depending on input parameters. Is ...
- 1,316
0
votes
0
answers
354
views
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 ...
- 3,900
5
votes
1
answer
13k
views
How to create a new SQL Database on different drive
I have installed SSMS 2014 recently on my new machine, installations are in C: but my C: is not having that much enough space, so I need to create the new database on D:. Please help me on how can I ...
- 103