Browse by Tags

All Tags » SQL Server (RSS)

Querying Active Directory from SQL Server 2005 by bunbun

Querying Active Directory from .NET code is pretty easy and straightforward. Doing the same from SQL Server is not too difficult but there is one glaring issue in my opinion - your result set is limited to 1,000 records. For a small company this may be...
Filed under: ,

Using a linked server in a stored proc job by bunbun

Working on a new stored proc, I encountered an error when trying to run a job that called the stored proc. The error message was: Executed as user: NT AUTHORITY\SYSTEM. The OLE DB provider "SQLNCLI" for linked server "costpoint_rw" reported an error....
Filed under: ,

Malformed URL when sitemap node points to SSRS folder by bunbun

Needed to create a menu item linked to a folder on our SQL Server Reporting Services site. After putting the URL in my sitemap, I got error messages about a malformed URL even though I new the URL was good (I could copy and paste it into a web browser...
Filed under: , ,

Parameters for SSIS package when running as a job by bunbun

I was playing around with SQL Server Integration Services to create a parameterized package to copy the latest production backup file to a dev server and then restore the backup to the dev server. It's not that hard to do manually but thought it would...
Filed under: ,

Multi-valued parameters in SSRS 2005 by bunbun

Found a great article on how to handle multi-valued parameters in SQL Server Reporting Services 2005. This article shows how to create a common SQL function that will take the multi-valued parameter passed from SSRS and split it out into a tables of values...

SQL Server Reporting Services in web apps with sub reports by bunbun

I've started using SQL Server Reporting Services in more web applications recently. Using sub reports for the first time was a little tricky but once you do one, you're set. Here's a sample using a simple report based on a SQL datasource. Define the report...

Deploying RDLC files in local mode for ASP.NET applications by bunbun

Ran into problems trying to deploy my first web application to use a SQL Server Reporting Services report. I created a RDLC file and bound my report viewer control to an object data source. Worked fine on my local machine but as often happens stopped...
Filed under: ,

Fix for SQL Server 2005 Performance Dashboard Reports by bunbun

Got the performance reports up and running and everything seemed good. Then I started getting " Difference of two datetime columns caused overflow at runtime ." errors when trying to run the reports. Turns out it's a known issue. Found the answer on the...
Filed under:

SQL Server 2005 Performance Dashboard Reports by bunbun

Found a niffy little tool for some basic SQL Server reporting. Microsoft has some dashboard reports that work with SQL Server 2005 SP2. You can download it here: http://www.microsoft.com/downloads/details.aspx?FamilyId=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang...
Filed under:

Configure SQL Server Agent to use database mail by bunbun

Found out that my database maintenance plan had failed the past several days and wondered why I had not received email that the job failed. When I checked the database error log I found the following error: An attempt was made to send an email when no...
Filed under:
More Posts Next page »