Skip to content Skip to sidebar Skip to footer
Showing posts with the label Sql Server 2008 R2
Trigger Error: The Current Transaction Cannot Be Committed And Cannot Support Operations That Write To The Log File

Trigger Error: The Current Transaction Cannot Be Committed And Cannot Support Operations That Write To The Log File

Post a Comment
So I am getting the following error message from SQL Server when sp_SomeProc tries to execute an in… Read more Trigger Error: The Current Transaction Cannot Be Committed And Cannot Support Operations That Write To The Log File
What Is Best Approach For Opening/closing Sqlconnection In C#

What Is Best Approach For Opening/closing Sqlconnection In C#

Post a Comment
I would like to know what could be best approach to open a SqlConnection with Sql Server 2008R2 Exp… Read more What Is Best Approach For Opening/closing Sqlconnection In C#
Create Scheduler Task To Invoke Sqlcmd

Create Scheduler Task To Invoke Sqlcmd

Post a Comment
I have a Requirement where i have to run a SQL Script in SQL server on a weekly basis .Result of th… Read more Create Scheduler Task To Invoke Sqlcmd
Lock A Table In Sql Server 2008 After Select

Lock A Table In Sql Server 2008 After Select

Post a Comment
I have a main currency table. Which has two fields, one currency Type and currency value. User can … Read more Lock A Table In Sql Server 2008 After Select
Comparison Query Taking Ages

Comparison Query Taking Ages

Post a Comment
My query is quite simple: select a.ID, a.adres, a.place, a.postalcode from COMPANIES a, COMPAN… Read more Comparison Query Taking Ages
Open Xml Document And Return For Every Row, Based On Row's Path To Xml File

Open Xml Document And Return For Every Row, Based On Row's Path To Xml File

Post a Comment
I'm pretty new to using XML with TSQL, and recently ran into an issue that I can't think ar… Read more Open Xml Document And Return For Every Row, Based On Row's Path To Xml File