Rodrigo Acosta


Technical Article

Function to encript password

If you need to save password for you application in tables, with this function you can save them encripted. And with another published function (check the page to find the script) you can desencript it. The function receives the password,  modifies every character and returns the encripted password.

2004-03-18

556 reads

Technical Article

Sp to enable, disable or list all Triggers in  DB

This one is For SQL 2000.This SP enable,disable or list all the Triggers in the given database.If enable or disable are specified, finds all the triggers of all the tablesand enable or disable them, After that, it list all the triggers with it´s current state.If List is specified, then it only list the triggers with […]

2002-09-19

666 reads

Technical Article

Sp to enable, disable or list all Triggers in a DB (SQL 7)

This SP enable,disable or list all the Triggers in the given database.If enable or disable are specified, finds all the triggers of all the tablesand enable or disable them, After that, it list all the triggers with it´s current state.If List is specified, then it only list the triggers with it current state. I didn't […]

2002-09-16

584 reads

Blogs

A New Form of Address: Mx

By

When I was presenting at the dataMinds Connect conference, I called on someone in...

Group By Starting Characters

By

I was chatting with Jeff (b|t) on my team yesterday and the context escapes...

Daily Coping 22 Oct 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Maybe It Is DNS

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Maybe It Is DNS

Finding all logins that can alter DDL

By webrunner

Hello experts, Is there a ready-made query out there that I could run on...

Insert records with a where

By saintor1

I want to insert record job allocations only for selected jobs I know the...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers