Showing posts with label SQL. Show all posts
Showing posts with label SQL. Show all posts

Saturday, January 23, 2016

SQL Decryptor (Optillect)

 

 SQL Decryptor is a practical, effective and comprehensive utility that comes in handy for users who need to decrypt encrypted stored-procedures, views, triggers, and functions


DOWNLOAD

Monday, November 30, 2015

SQL Server Query Analyzer Shortcuts

SQL Server Query Analyzer Shortcuts


ShortcutFunction
ShortcutFunction
ALT+BREAKCancel a query
CTRL+SHIFT+F2Clear all bookmarks
ALT+F1Database object information
CTRL+SHIFT+INSERTInsert a template
ALT+F4Exit
CTRL+SHIFT+LMake selection lowercase
CTRL+ASelect all
CTRL+SHIFT+MReplace template parameters
CTRL+BMove the splitter
CTRL+SHIFT+POpen
CTRL+CCopy
CTRL+SHIFT+RRemove comment
CTRL+DDisplay results in grid format
CTRL+SHIFT+SShow client statistics
CTRL+DeleteDelete through the end of the line
CTRL+SHIFT+TShow server trace
CTRL+EExecute query
CTRL+SHIFT+UMake selection uppercase
CTRL+FFind
CTRL+TDisplay results in text format
CTRL+F2Insert/remove bookmark
CTRL+UChange database
CTRL+F4Disconnect
CTRL+VPaste
CTRL+F5Parse query and check syntax
CTRL+WWindow selector
CTRL+GGo to line
CTRL+XDelete
CTRL+HReplace
CTRL+ZUndo
CTRL+IIndex Tuning Wizard
F1Help for Query Analyzer
CTRL+KDisplay/hide execution plan
F2Move to next bookmark
CTRL+LDisplay execution plan
F3Repeat last search
CTRL+NNew query window
F4Object Search
CTRL+OConnect
F5Execute a query
CTRL+PPrint
F6Switch between query and result panes
CTRL+RShow/Hide results pane
F8Show/hide Object Browser
CTRL+SSave
SHIFT+F1Transact-SQL help
CTRL+SHIFT+0Show options
SHIFT+F2Move to previous bookmark
CTRL+SHIFT+CComment out code
SHIFT+TABDecrease indent
CTRL+SHIFT+DELClear the active Editor pane
SHIFT+F6Switch panes
CTRL+SHIFT+FSave results to file
TABIncrease indent

SQL Server Management Studio Keyboard Shortcuts


Ctrl + A
select all
Ctrl + B
change list-box position
Ctrl + C
copy
Ctrl + D
clear text
Ctrl + E
Edit SQL using editor
Ctrl + F
find
Ctrl + G
show/hide data grid
Ctrl + H
view SQL history
Ctrl + I
go to line
Ctrl + L
lower case
Ctrl + M
capitalize text
Ctrl + N
open another SQL window
Ctrl + O
open query
Ctrl + P
print SQL
Ctrl + R
replace
Ctrl + S
save query
Ctrl + T
switch to another table
Ctrl + U
upper case
Ctrl + V
paste
Ctrl + X
cut
Ctrl + W
line wrap
Ctrl + Y
redo
Ctrl + Z
undo
Ctrl + F5
go to results window
Ctrl + F7
export to table
Ctrl + F11
comment text
Ctrl + F12
uncomment text
Ctrl + Shift + F5
search table
F1
help
F2
build column list for query table
F4
select current statement
F5
run SQL
F6
check syntax
F7
export data
F8
explain SQL
F9
display query table
F12
find matching bracket
Shift + F2
toggle bookmark
Shift + F3
next bookmark
Shift + F4
previous bookmark
Shift + F12
select to matching bracket
Shift + Delete
cut
Shift + Insertpaste

Sunday, November 29, 2015

Recover SQL Database using Software

Recover SQL Database using Software

Most of the Software's are available in market to recover SQL database. All those software available only for paid customer. 
How to Work our Software

SysTool : SQL Recovery Tool

SQL Recovery Tool can recover the database having following error messages
  1. "Error 823: I/O error (torn page) detected during read at offset 0x00000027dc2000 in file."
  2. "Server can't find the requested database table"
  3. "Index '%ls' on '%ls' in database '%ls' may be corrupt because of expression evaluation changes in this release. Drop and re-create the index"
  4. "The process could not execute 'sp_replcmds' on Server"
  5. "The file *.mdf is missing and needs to restore"

Download Recovery Tool


Sunday, June 28, 2015

Suspect Query

Suspect Query for SQL 2005/2008

ALTER DATABASE yourDBname 
SET EMERGENCY DBCC checkdb('yourDBname') 
ALTER DATABASE yourDBname 
SET SINGLE_USER WITH ROLLBACK IMMEDIATE 
DBCC CheckDB ('yourDBname', REPAIR_ALLOW_DATA_LOSS) 
ALTER DATABASE yourDBname 
SET MULTI_USER 

FOR SQL 2000 

SP_DBOPTION 'yourDBName', 'SINGLE USER', 'TRUE' 
DBCC CHECKDB ('yourDBName', REPAIR_ALLOW_DATA_LOSS) 
SP_DBOPTION 'yourDBname', 'SINGLE USER', 'FALSE'

Sunday, June 07, 2015

SQL BACKUP SOFTWARE FULL VERSION DOWNLOAD

Creates MS SQL Server & Azure database backups,Zips, Encrypts and sends backups to a folder, FTP, Dropbox, Box, Google Drive, MS OneDrive, Amazon S3 or Windows Azure Storage.

  • Runs on a flexible Schedule, sends e-mail confirmations on job success or failure.
  • Makes full, differential or transaction log backups, runs custom scripts, backs up file folders, allows viewing of the results on the w

  •                                                             DOWNLOAD

    Monday, May 25, 2015

    RECOVERING A SQL SERVER 2000 DATABASE FROM A SUSPECT MODE



    RECOVERING A SQL SERVER 2000 DATABASE FROM A SUSPECT MODE
    Posted by Admin Labels: newupdate, SQL 2000 Suspect, sql error, usefulpost
    Error:
    ·         Database Suspect due to Not enough space.
    ·         Due to a sudden Reboot the Transactional Log file of the database named ABC got corrupted due to which the database went into SUSPECT mode.


    Solution:


    Here i take database name as "DBName"
    ·         First we have to find out physical location of ldf file by using T-SQL query
    Select * from sysaltfiles                                                                                


    ·         Database physical location path like as  D:\MSSQL\Data\DBName_log.LDF
    ·         Stop the SQL Server Services on the server using services.msc/SQL Server Service Manager.
    ·         Rename Physical database log file name. i.e DBName_log1.LDF
    ·         Execute Following query from query Analyzer

    EXEC sp_configure 'Allow updates', '1'
    Reconfigure with override


    ·         Set the database named DB_log to Emergency mode by executing the following query 
    UPDATE master.dbo.sysdatabases                                                                
    SET Status = -32768                                                                                    
    WHERE [Name] = ‘DBName’                                                                              
    GO                                                                                                              


    ·          Once the database is set to EMERGENCY mode it becomes a READ_ONLY copy and only members of sysadmin fixed server roles have privileges to access it.
    ·         Bring the database named DBName to Single User mode by using the below query
    EXEC sp_dboption 'DBName', 'Single User','TRUE'                                                     


    ·           Rebuild the Transactional Log file of the database using the below 
    DBCC REBUILD_LOG ('ABC','D:\MSSQL\Data\ABC.LDF')                                      


    ·          Run DBCC CHECKDB as follows to ensure that the database is free from any sort of corruption
    DBCC CHECKDB ('ABC')                                                                                  


    ·         If DBCC CHECKDB doesn't print any error message then it means that we are successful.
    ·         Go to Database Properties and Uncheck the DBO User OnlyRestricted Access option.