Learncado
Learncado

Learncado brings together a vast collection of questions and answers. Expand your knowledge, learn new skills, and find solutions to your queries effortlessly. Enhance your learning experience and save valuable time by exploring our website today.

Resources

  • Questions
  • Question By Tags

Help and support

  • Contact
  • About
  • Geniecourse
  • Jetsodeals
  • Rentcado
  • Dealcado
© 2021-2023 Learncado All Rights Reserved.

Search Results (10)

Results for ssms

November 19th, 2023
Can't use SSMS to access (localdb)\\mssqllocaldb setup by Blazor application

Background: I created a Blazor application with Authentication Type "Individual Accounts". This leads to a local msSql database to be created. The app...

ssmssql-serverblazor
Read more
September 2nd, 2023
Spatial SQL (in SSMS - using T-SQL) - STIntersect and STContains doesn't return the correct result

Trying to find: All the routes that pass through a buffer of 5km around a random point. Background: I have multiple routes stored as linestring of ...

sqltsqlgeospatialspatialspatial-query
Read more
August 31st, 2023
Scaffolding a database in SSMS within Visual Studio to deploy on Azure

I have created a database in Azure and connected it in SSMS, but when I try to scaffold it in Visual Studio I always get the same error which says: l...

sql-serverazurevisual-studioasp.net-core-scaffoldingazure-deployment
Read more
September 13th, 2023
How can i check Data sync group from SSMS?

I have seen some Azure DataSync tables and procedures in my Database.I'm not sure from where which database they are loaded. Is there any way to chec...

azureazure-data-factoryazure-web-app-serviceazure-sql-databaseazure-data-sync
Read more
September 6th, 2023
Edit a dtsx through SSMS

I created and executed a dtsx with SSMS corresponding wizard: This was to import a flat file in an existing table. At the end I saved the "package"...

ssmssql-serverssissql-server-2016etl
Read more
November 2nd, 2023
Import Flat File via SSMS to SQL Server fails

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 appe...

ssmsimport
Read more
November 9th, 2023
How do you view ALL text from an ntext or nvarchar(max) in SSMS?

How do you view ALL text from an NTEXT or NVARCHAR(max) in SQL Server Management Studio? By default, it only seems to return the first few hundred ch...

ssmssql-serversql-server-2008t-sql
Read more
November 28th, 2023
Query times out when executed from web, but super-fast when executed from SSMS

I'm trying to debug the source of a SQL timeout in a web application that I maintain. I have the source code of the C# code behind, so I know exactly...

ssmssql-serversql-server-2008query-performancearithabort
Read more
September 30th, 2023
Permissions issue in SSMS: "The SELECT permission was denied on the object 'extended_properties', database 'mssqlsystem_resource', ... Error 229)"

Here’s the simplest repro case possible. Create a brand new database. (I'm using SQL 2005.) Create a login, a SQL user, and a table in the new datab...

ssmssql-serversecuritypermissionst-sql
Read more
September 10th, 2023
sql server invalid object name - but tables are listed in SSMS tables list

I am attempting to create a Stored Procedure for a newly created database. However the SSMS intellisense does not recognize more than half of the tabl...

ssmssql-server
Read more

Hot Topic

  • 25881

    How do I undo the most recent local commits in Git?

  • 11618

    How can I remove a specific item from an array in JavaScript?

  • 20343

    How do I delete a Git branch locally and remotely?

  • 7387

    How can I find all files containing a specific text (string) on Linux?

  • 7330

    How to find all files containing specific text (string) on Linux?

  • 7611

    How do I revert a Git repository to a previous commit?

  • 2671

    How do I create an HTML button that acts like a link?

  • 8481

    How do I check out a remote Git branch?