Have you ever wanted to retrieve a list of values from a table, storing the results in a string? Here is simple yet effective method without having to rely on cursors, while loops, or other complex structures. declare @string varchar(8000) select...
As you may notice, Microsoft SQL Server will gradually consume more and more memory after it starts…Most people (myself included) will wonder if this means that there are memory leaks or unclosed connections. While you should make sure...
There’s a lot of stuff out there about SQL injection attacks but there’s not much that will help you figure out how to stop these attacks from occurring. First, let’s talk about what a SQL Injection Attack really is. Some people...
Each application taht uses your SQL Server database creates a connection on the database and this connection continues unless the session is killed or terminated privately within the application. A similar connection is established even for each...
Error Message: Microsoft.Reporting.WinForms.ReportServerException: The Report Server Windows service ‘ReportServer$SCE’ is not running. The service must be running to use Report Server. (rsReportServerServiceUnavailable)at Microsoft...