I use YetAnotherForum (YAF) for my Forums here. Like others, I get hundreds of spam users created each month. I wrote the following SQL to delete any user that hasn’t visited in the last day, never posted or emailed a message, isn’t the last user on a forum, and isn’t in the Active list. […]
Delete Spam Users from YetAnotherForum Read More »
A lot of times, you have something like a description column and you want to display it in a GridView. But since for some of the rows the description column can be very long, it doesn’t always work very well. One solution is where you set the TD’s attribute NOWRAP, then the column runs off
Displaying a Long Description Column in a GridView Read More »
Real quick I wanted to know what tables and stored procs were in my ReleaseManagerTest database and not in my ReleaseManager database. So here is the SQL for that. select min(DB) as DB, name, type from ( select ‘ReleaseManagerTest’ as DB, name, type from ReleaseManagerTest.sys.objects union all select ‘ReleaseManager’ as DB, name, type
Quickly Finding Missing Objects in Two SQL Server 2005 Databases Read More »
I kept writing the same SQL over and over while developing to find the names of stored procs or to see what objects I had recently added. So I created a quick stored proc that I now have in my toolbox. Copy Text Copied Use a different Browser create proc obj(@name varchar(50)=null, @type char(1)=null) as
Finding Objects in SQL Server During Development Read More »
A friend of mine brought over his laptop because he couldn’t remember his new Windows Vista login password. I said I would work on it and worst case I would have to clear everything and reinstall Vista. Googling around I found that there were tools for clearing the password. I downloaded and burned to a
Forgotten Windows Password Recovery and the “no tables found” error. Read More »
We were changing our linked server and needed to test every page in our website that used that linked server. None of the pages used it directly, but they did call stored procs that would use it or stored procs that would in turn, call other stored procs that use it. I need to find
Knowing What to Test When Changing a SQL Server Object Read More »
I have a page where the user can select which users are active (using check boxes), and also select one (only one) to be the administrator. I put together this sample to show how I did it. The sample uses technologies instead of the user. The picture below gives you an idea. I didn’t want
Select One Row From a GridView Read More »
The question came up asking how to change something in a GridView row based on something else in that row without doing a postback. So I created a simple example where if you check a CheckBox, then another column in that row would have its background color changed. I did this in a generic way
How to Work With a GridView Row in JavaScript Read More »
One of our applications features a page where users can report bugs. We wanted to allow them to “attach” one or more files to the bug record. The files could be screenshots, spreadsheets, etc. So the bug entry page would have the normal data entry part and have the following box at the bottom of
Attaching upload files to a record. Read More »
Another way to store your connection string in a way that it doesn’t get in the way when you promote your web site from Test to QA to Prod is the following: Have your web site under a given directory, say d:\WebSites\MyWebsite. And you also have another directory to hold your connection strings that isn’t
Another Place to Put the Connection String Read More »
