Rodrigo Acosta


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

547 reads

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

664 reads

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

582 reads

Blogs

The First Data Saturday is Tomorrow

By

Data Saturday #2 – Guatemala is tomorrow. This is the first event on the...

Daily Coping 22 Jan 2021

By

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

Daily Coping 21 Jan 2021

By

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

Read the latest Blogs

Forums

Grant user access to view database only

By sql_Reporter

Hi I need to grant a user access to a DB on the server...

Need to strip off the beginning of a field in SELECT statement

By tim8w

I have this table that unfortunately has spaces in the field, which I am...

Aliasing an instance name for remote connections

By Brandie Tarvin

It's been a long time since I set up a 2012 server. We have...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Amend a Commit

See possible answers