New answers tagged

0 votes

How do I create a new login on an Azure SQL Database?

I have a serverless database on that logical server shown below: When you connect to that server on management studio, make a click on Options. Make sure you connect to the Master database and make ...
Alberto Morillo's user avatar
1 vote
Accepted

Insufficient disk space when restoring or resizing db on SQL Server 2019 dev ed

It's very unusual for MSSQL and the file system to disagree on disk sizes. There was a while, a long time ago, where programs would not understand about disks bigger than some value (2G? 4G? 8G? Yes, ...
tsc_chazz's user avatar
  • 1,744
0 votes

How do I get something like the INFORMATION_SCHEMA.COLUMNS metadata view of the INFORMATION_SCHEMA.COLUMNS view itself?

Here is a list of some more ways to get the column property information. The other answers and this one together can build a sort of INFORMATION_SCHEMA.COLUMNS of the INFORMATION_SCHEMA.COLUMNS. The ...
questionto42's user avatar
1 vote

How do I get something like the INFORMATION_SCHEMA.COLUMNS metadata view of the INFORMATION_SCHEMA.COLUMNS view itself?

I think I've got what you're looking for by going to the native mssql DMVs. Note - I had to use the "all_" versions of them (which include system objects); I think this is why ...
Ben Thul's user avatar
  • 3,044
1 vote
Accepted

How do I get something like the INFORMATION_SCHEMA.COLUMNS metadata view of the INFORMATION_SCHEMA.COLUMNS view itself?

C# in Visual Studio You can run this C# code for example from Visual Studio with a Visual C# "ConsoleApp (.Net Framework)" project: Which gives you a standard empty project code from where ...
Olivier Jacot-Descombes's user avatar
0 votes

System.EnterpriseServices Error when trying to connect Excel or PowerBI to a SQL Server

I had the same error in Power BI Desktop, connecting to SQL Server. The answer here worked for me, which was to delete all my existing credentials to the SQL Server. In the File menu, click on ...
Mike's user avatar
  • 741

Top 50 recent answers are included