Sign in Subscribe

Topic

SQL Server

A collection of 22 posts

A seriously elegant SQL Injection -how it was sorted

Doug Setzer posted this comment in response to my recent "A seriously elegant SQL Injection" post and I thought it may be of interest to others so have promoted it to a post... Well, I'll step up and say that I am the "mate"

A seriously elegant SQL Injection

Having been subject to a recent hack myself I can sympathise with one of my mates who had a SQL injection attack succeed on one of his sites earlier today. Admitadly mine was due to poor internal maintanence whereas this is almost a piece of art... This is an extract

Native client cannot be found while installing SQL Server 64

We're having fun and games with the new internal dev server. We've got for Windows Server 2008 x64 for a laugh and today was a corker, while trying to install SQL Server 2005 x64 onto the box we repeatedly got an error along the lines of

SQL Server Management Studio won't install over SQL Server Management Studio Express

Since re-installing my main development machine recently, I've had a real irritation -I had to resort to SQL Server Management Studio Express as I couldn't get the full version installed. This wasn't a problem until today when I had to re-create some full text

How to search every table and field in a SQL Server Database

Update: I have corrected the original issue with this script. Please see: Search every table and field in a SQL Server Database Updated. Today I had an issue with Umbraco and a copy of a deleted page appearing in the menu, I'll post how I fix it if

ASP.Net Membership SQL Roles access

We have recently moved over to SQL Server 2005 and as part of this transfer I decided to aggregate two separate ASP.Net Membership databases that were created purely out of error. For those of you who don’t already know, you can happily run more than application’s security

SQL Server Delete all data

I expect many people already know about this technique but I wanted to share it with those that don’t. The other day I needed to remove all data from a database before importing data from another database. I usually use DTS to copy the data across but knew that

SQL Server SP2 quirks

Ok, as sad as it sounds I've been looking forward to the latest SQL Server service pack since I heard about some of the issues it fixed as there was two "glitches" in particular that seriously bugged me, namely: * Loading a SQL file into the query

Making sense of database responses

We're nearing the end of a large system for the lovely people over at Consolidated Communications Management Ltd and we've just come across a nice idea to make sense of database responses. Typically in the past we've simply returned -1/0 for failure and

Stored Procedure to assign permissions

This is a useful stored procedure for assigning permissions to users quickly and easily. We tend to assign a new login to each application we develop, this way we limit the damage possible in the event of a username/password compromise. /*-------------------------------------------------------------------------- Automatically assign the role permissions --------------------------------------------------------------------------*/USE DatabaseNameSET