-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
The “LEN” function cannot be used to find length of a column of datatype “TEXT” so using function “DATALENGTH” one… READ MORE
|
Run the following SQL to find permissions granted on individual objects on the database select case when p.protecttype = 205… READ MORE
|
— print usernames and the roles assigned to the user, it can be run against any database and it will… READ MORE
Using sysdatabases one can create script various scripts one of the useful is to create script to backup all databases.… READ MORE
By executing the store procedure sp_spaceused ‘<table>’ one can find the space used by a table. The store procedure returns… READ MORE
To change the logical name of the SQL Server databse one can follow the steps below to change the logical… READ MORE
In Query analyzer — prints job name, step name, start time and end time of each step in the job… READ MORE
|
In Oracle: SQL> ALTER SESSION SET nls_date_format = ‘YYYY-MON-DD HH24:MI:SS’; Session altered. SQL> SELECT TRUNC(sysdate) FROM DUAL; TRUNC(SYSDATE) ——————– 2009-MAY-10… READ MORE
The following article gives some background on how to stop the transaction log from growing Using the steps below one… READ MORE
|
DECLARE @role_name VARCHAR(100) DECLARE @member_name VARCHAR(100) DECLARE @rolescur CURSOR DECLARE @rolememberscur CURSOR DECLARE @loginname VARCHAR(100) DECLARE @username VARCHAR(100) DECLARE @logincur… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 