I am no database administrator. But, my job requires me to understand what is involved with setting up and securing Microsoft SQL Server 2005. Yes, one can argue that this should be left up to a database administrator, but as many in the IT field understand… we, as IT professional wear many hats. I’ve read [...]
Filed under: Microsoft, Security, SQL Server | Tagged: 2005, 2008, Microsoft, overview, security, server, sql | Leave a Comment »
USE [YOURDB] GO IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N’[dbo].[fn_ParseDelimString]‘) AND type in (N’FN’, N’IF’, N’TF’, N’FS’, N’FT’)) DROP FUNCTION [dbo].[fn_ParseDelimString] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO — ============================================= — Author: Michael A. Thompson | QCHRF0 — Create date: 12/13/2008 — Description: This function will take a comma — [...]
Filed under: Microsoft, SQL Server | Tagged: csv, function, parse, sql, sql parse string, string, substring | Leave a Comment »
