- Details
- Written by: Stanko Milosev
- Category: SQL
- Hits: 7748
Install SSMS 2012 (not DB engine, only Management Studio) from:
Download BACPAC, it can be done using Visual Studio (View->Server explorer,…)
If you receive the error like:
Error SQL72014: .Net SqlClient Data Provider: Msg 468, Level 16, State 9, Procedure MyProc, Line "some number" Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.
(Microsoft.SqlServer.Dac)
Then unzip BacPac (bacpac is actually zip file), find file which has SQL_Latin1_General_CP1_CI_AS, then, best is just to rename bacpac to zip, and search and replace file directly from zip, or install new instance of MS SQL, because I couldn’t find a way to change collation of the server…
- Details
- Written by: Stanko Milosev
- Category: SQL
- Hits: 5452
SELECT so.name as TableName, ddps.row_count as [RowCount]
FROM sys.objects so
JOIN sys.indexes si ON si.OBJECT_ID = so.OBJECT_ID
JOIN sys.dm_db_partition_stats AS ddps
ON si.OBJECT_ID = ddps.OBJECT_ID AND si.index_id = ddps.index_id
WHERE si.index_id < 2 AND so.is_ms_shipped = 0
ORDER BY ddps.row_count DESC
Taken from here
- Details
- Written by: Stanko Milosev
- Category: SQL
- Hits: 6267
If you are receiving error like:
Failed to add rule 'xxx.xxx.xxx.xxx to xxx.xxx.xxx.xxx' to firewall. Please add it manually.
Then first go to SQL databases, like on the picture:
After go to servers, and click on the server which you want to configure:
Then click configure:
And here you can add your rule:
- Details
- Written by: Stanko Milosev
- Category: ASP.NET
- Hits: 2882
Set breakpoints and attach to process w3wp.exe:
If you don't see w3wp.exe then either refresh browser, or open your application in browser, and click refresh in "Attach to process" window.