I have never used one. When I need to understand a database I look at the metadata and trace with profiler.

Hi,

We use linked servers, is database chaining a more secure technique than using linked servers?

just a note to say that isolation level is set at the connection level and that the default is read committed and that if another isolation level is desired it...

I received a similiar error when the service running the data collector could not access the cache folder

I do row by row processing by using a do while loop for example:

declare @LoadedKey BIT

SET @LoadedKey = NULL

SET @LoadedKey =

(

SELECT

TOP 1 ColA

FROM

BusinessTable

WHERE

LOADED =

(

SELECT...

thank you all for your posts.  I'll let you know how it turns out.

Your view often leads to actions that harm share holder value.  Maximizing profits often leads to unintended cosequences.  These unintended consequences may be mitigated by viewing corporate responsibility through the...

dude, give it a rest.  On the home page there is weblink entitled Provided by RedGate that links directly to their site.

I hope the rest of your company isn't as...

Assumptions, my biggest bane as a developer...

I work in an environment where requirements gathering is not a very high priority.  The users really don't want to give you the time...

first, get specifics on login

EXEC xp_logininfo  'DOMAIN/WindowsGroupName', 'all'

then

EXEC sp_revokelogin  'login'

I work at a small place with limited resources and a user group that is not very well versed in desk top applications of any sort.  What I have learned...

This editorial is a red herring, the problem that women face in the work place is the problem, not the problems women have working in IT.  Women face almost insurmountable obstacles...

This may seem silly, but one of the featured professionals used the word holistic to describe the problem solving/planning culture of a work place.  I hate that word used in...

we only keep one backup on disk, the rest are on tape.  I find scheduled backups to a backup devices the way to go for this.

you can move packages from test to production using a script.

outlined here:

from http://www.dbazine.com/sql/sql-articles/larsen8

I had to tweak the code, but it works.  We have over 330 packages to load our...