Recent Posts

0
Comments

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: ,
2
Comments

Keeping ASP.NET sessions alive by bunbun

I had an application where users would routinely start working, then stop to do something else and then keep the web page open for hours on end. This would inevitably lead to some ASP.NET Session has expired messages. To combat this, there is a simple...
Filed under:
0
Comments

Separate gridview column alignment with CSS Friendly Control Adapter by bunbun

When using the CSS Friendly Control Adapters, you get an easy to modify the look and feel of all your controls through one style sheet. With the gridview style, you can set the text alignment for your columns: .PrettyGridView .AspNet-GridView table tbody...
Filed under:
3
Comments

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: ,
0
Comments

Convert SQLDataSource to DataTable by bunbun

Sometimes I find the need to convert a SQLDataSource to a DataTable. Here's how to do it: Dim dv As DataView = New DataView() Dim dt As New DataTable dv = Me .sqldsData.Select(DataSourceSelectArguments.Empty) dt = dv.ToTable()
Filed under:
1
Comments

Padding in SQL (Replicate Command) by bunbun

In .NET there are nice functions for padding like PadLeft and PadRight. Found out SQL has its own: the replicate command. You pass a string (the value you want to pad) and then an integer value for how many occurences you want. Combine that command with...
Filed under:
0
Comments

Open menu item in new window by bunbun

By default when you open a menu item based on your application's sitemap, it opens in the current window. To have items open in a new window, it's just a simple two step process. First add the "target" property to the sitemapnode you want to be opened...
Filed under:
3
Comments

Disable/Enable export format in SSRS and ASP.NET by bunbun

When using the SSRS ReportViewer control in ASP.NET, by default you have the option to export to Excel or PDF. Recently I had an application where the users wanted to limit the export options to PDF only. Thanks to this blog post , I found it was very...
0
Comments

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: , ,
0
Comments

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: ,
More Posts Next page »