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

536 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

655 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

571 reads

Blogs

Information Measurement with SQL Server Part 4.5: The Squared L2 Family of Distances

By

By Steve Bolton …………In the last two installments of this series of amateur self-tutorials...

Security Learning Pathway at PASS Summit.

By

This year PASS is trying something new at PASS Summit. There are going to...

Pathways to Progress

By

One of the most significant and hardest challenges we face as data professionals (or...

Read the latest Blogs

Forums

error Output File cleanup does not delete files script d'olla

By abdalah.mehdoini

Hello everyone, I use olla scripts in my backup and maintenance operations there is...

Help with a stored procedure

By sridharkannan7

I have a table "Mytable" containing a list of IDs. There is a web...

Need to perform leaf level aggregation

By morbius82000

So I have a DW with  a table with some pre-aggregated scores (not my...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers