New answers tagged sql-server
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 ...
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, ...
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 ...
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 ...
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 ...
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 ...
Top 50 recent answers are included
Related Tags
sql-server × 4801sql-server-2008 × 708
sql-server-2005 × 518
sql × 372
windows × 262
windows-server-2008 × 227
backup × 220
database × 217
sql-server-2008-r2 × 140
windows-server-2003 × 132
performance × 130
replication × 128
iis × 125
azure × 125
security × 122
sql-server-2012 × 114
ssms × 107
active-directory × 97
mysql × 94
ssrs × 88
networking × 73
cluster × 69
migration × 69
database-administration × 67
permissions × 65