Viewing 15 posts - 1 through 15 (of 44 total)
I have never used one. When I need to understand a database I look at the metadata and trace with profiler.
September 11, 2015 at 8:57 am
We use linked servers, is database chaining a more secure technique than using linked servers?
April 8, 2015 at 8:42 am
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...
May 1, 2013 at 2:52 pm
I received a similiar error when the service running the data collector could not access the cache folder
September 28, 2011 at 2:42 pm
I do row by row processing by using a do while loop for example:
declare @LoadedKey BIT
SET @LoadedKey = NULL
SET @LoadedKey =
TOP 1 ColA
December 28, 2007 at 10:51 am
thank you all for your posts. I'll let you know how it turns out.
June 8, 2007 at 9:18 am
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...
March 21, 2007 at 8:54 am
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...
February 28, 2007 at 10:27 am
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...
February 28, 2007 at 8:06 am
first, get specifics on login
EXEC xp_logininfo 'DOMAIN/WindowsGroupName', 'all'
EXEC sp_revokelogin 'login'
February 21, 2007 at 2:46 pm
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...
February 21, 2007 at 2:34 pm
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...
February 20, 2007 at 10:11 am
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...
January 29, 2007 at 11:18 am
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.
January 25, 2007 at 11:36 am
you can move packages from test to production using a script.
I had to tweak the code, but it works. We have over 330 packages to load our...
January 23, 2007 at 9:48 am