User Profile
olafhelper
Bronze Contributor
Joined Sep 14, 2020
User Widgets
Recent Discussions
Re: SSRS subscription
Docs on data driven subscriptions: Data-driven report subscription is only available in the Enterprise edition; the OP uses Standard Edition. SQL Server Reporting Services features supported by editions - SQL Server Reporting Services (SSRS) | Microsoft Learn Yes, it's possible to modify the SSRS job, but you should be carefully with it.60Views0likes0CommentsRe: Reading a non-rounded value from Excel cells using OPENDATASOURCE
Format of the cell is “# ##0,0;-# ##0,0”. Therefore, the value 10,45 is displayed in Excel as rounded value “10,5” The data provider ACE don't care about any Excel format information, it picks the value as it is. You have to round the value on your own, see ROUND (Transact-SQL) - SQL Server | Microsoft Learn115Views1like1CommentRe: Transaction was deadlocked on lock resources with another process ??
Rerun the transaction. Deadlocks can happen if two processes accesses resources in different order; that can happen. Deadlock (computer science) - Wikipedia Do what the message says: Rerun the transaction.157Views0likes0CommentsRe: Issue Truncating Table with Foreign Key Constraints in Microsoft SQL Server 2022
What's the point in having the functionality if you can't use it as its intended A TRUNCATE TABLE is not intended to break foreign key relations; it works as it should do and this mean respecting PK/FK relations.1.4KViews0likes0CommentsRe: How can I continue using SQL Server 2025 Preview with full features after the 180-day trial ends?
How can I continue using SQL Server 2025 Preview with full features after the 180-day trial ends? You simply can't. You also can not "upgrade" a CTP to a regular RTM edition, that's also not supported. You have to backup your databases, uninstall the CTP and make a new installation of the RTM version.120Views0likes0CommentsRe: How to communicate with Linked Server encryption
A linked server is a SQL Server connection like any other client connection, there is no magic behind. And so you can setup any connection property as you can do it for other clients. SQL Server connection strings - ConnectionStrings.com77Views1like0Comments
Recent Blog Articles
No content to show