ssms Questions
4
Solved
I got a message from Microsoft in the last few days
Azure SQL Database 2014-04-01 APIs will be retired on 31 October 2025.
You're receiving this email because you use Azure SQL Database APIs.
To i...
Axum asked 2/11, 2022 at 16:12
10
Solved
When importing a seemingly valid flat file (csv, text etc) into a SQL Server database using the SSMS Import Flat File option, the following error appears:
Microsoft SQL Server Management Studio
...
5
Solved
Installing Microsoft® ODBC Driver 17 on windows 10.
During the install, Microsoft ODBC Driver 17 for SQL Server setup stops and shows "A previous installation required a reboot of the machine for c...
Madoc asked 8/6, 2020 at 11:51
1
Solved
I have a view in SQL Server that calls a function. When I show the actual execution plan for querying the view, what happens inside the function is completely opaque though.
As a small example, I m...
Peril asked 10/3, 2023 at 8:48
5
Solved
In SQL Server Management Studio, when I "View History" for a SQL Job, I'm only shown the last 50 executions of the Job.
How can I view a full log of every execution of a SQL Job since it was creat...
Rattlepate asked 13/10, 2011 at 12:49
3
I'm failing to connect to a SQL server SQLExpress. The connection worked fine a few days ago.
This is how I tried to connect (I'm using Microsoft SQL server management studio):
connection = pyodbc...
Metallo asked 6/5, 2016 at 11:53
6
Solved
I'm trying to login to my local SQL Server 2005 installed on Windows7 using SSMS using Windows authentication.
I tried using various server names like ., localhost, .\SQL, ANANTH-PC etc.
I get this...
Peccary asked 26/1, 2012 at 10:14
5
Solved
How could I execute a set of .SQL files (each does some data transformations) from within SQL Server Management Studio?
What other alternative are there for executing .SQL files in batch?
Grubbs asked 8/5, 2009 at 17:0
11
Solved
I created a SQL Server RDS Instance in AWS and it seems to be up and running, but if I try to connect to it using Management Studio I get this error:
Here is the text of the error:
A network-relat...
Connie asked 21/6, 2017 at 17:44
3
Solved
I have a SQL Server 2008 database with a .mdf file with 1 GB and a .ldf file (log) with 70 GB. I really don't know what took my log file to be so big in a week and to stop to increase, but my main ...
Flyover asked 30/9, 2014 at 0:11
3
Solved
I have a Report Services instance that creates hundreds of jobs. The jobs are in serial format (ie. xxxxxx-xxx-xxxxx-xxxx-xxxx) and clutter up the jobs section view in SSMS. Is there any way to hid...
Hyde asked 30/7, 2012 at 14:56
4
I have a query that returns a large 'ntext' result. I want to copy this over to a plain text editor (Notepad), but only a part gets copied over.
I tried increasing Query Options -> Results -> Text...
Dodder asked 21/4, 2010 at 9:34
5
Solved
I have updated SSMS to v18.5 and then uninstall SQL Search, downloaded the latest one and installed.
SSMS started, I click button "SQL Search" - no any errors/exceptions but SQL Search does not st...
3
Solved
I've just installed SSMS v18.6 and surprisingly I noticed that there's no debug menu anymore! I'm very dependent on debugging my SQL scripts like stored procs. Can anyone explain how I can achieve ...
Notorious asked 12/10, 2020 at 6:13
7
Solved
I have the below master script which creates tables, and inserts some data and then creates the stored procedures.
--todo_master.sql
use master
go
:r todo_create_ddl.sql
:r todo_create_dml.sql
:...
Handgun asked 6/1, 2012 at 4:54
14
Solved
SQL Server Management Studio always inserts a GO command when I create a query using the right click "Script As" menu. Why? What does GO actually do?
Kohl asked 19/2, 2010 at 20:12
3
Solved
I want to delete the saved usernames and passwords displayed in the "Connect to Server" screen.
In the internet (for example here) I've read that I should delete the file %APPDATA%\Microsoft\Micros...
Otoole asked 26/7, 2012 at 17:41
8
The I-beam has disappeared. It's starting to make it exponentially harder to type not knowing where I am in the query. If someone knows a fix that would be awesome.
4
Solved
I am trying to insert an image into a VARBINARY(MAX) column. I get this error:
You do not have permission to use the bulk load statement.
Here is my code:
INSERT INTO Stickers (Name, Categor...
Mechanism asked 5/9, 2015 at 21:19
3
Solved
I'm wondering if there's a keyboard shortcut in SSMS to surround a selected column name (or an uninterupted sequence of characters for the given cursor position) with the [ and ] chars.
So if I ha...
Outspan asked 25/3, 2015 at 8:34
18
Solved
I'm trying to write a script that will completely empty a SQL Server database. This is what I have so far:
USE [dbname]
GO
EXEC sp_msforeachtable 'ALTER TABLE ? NOCHECK CONSTRAINT all'
EXEC sp_msf...
Fasces asked 9/12, 2011 at 0:30
2
When I generate scripts in SQL Server 2008 Management Studio, it seems to insert the date/time in the script also.
For example:
USE [AdventureWorks]
GO
/****** Object: View [dbo].[vw_test] Scrip...
Cosper asked 28/7, 2009 at 21:42
6
I get this error when I try to run Microsoft SQL Server Management Studio:
The application has failed to start because its side-by-side configuration is incorrect. Please see the application ev...
Change asked 6/5, 2020 at 8:41
6
Solved
I have downloaded the SQL Server Management Studio (SSMS) 2016 to recover a huge .bak file which is an old backup of a database. But first of all I need to connect to a DB Server.
After install, I...
Linea asked 6/4, 2017 at 13:50
5
In Visual Studio & other IDEs, you can easily auto format your code with a keyboard shortcut, through the menu, or automatically as you type.
I was wondering if there is yet a way to enable th...
Formal asked 31/12, 2008 at 0:28
1 Next >
© 2022 - 2024 — McMap. All rights reserved.