<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Scripts with tag
SQL Server
Search for
any
content tagged
sql server
Add a script
Items 1 to 13 of 13
Retrieve SQL Instance Connect Info
This script quickly returns Server Name, Cluster Node, Default Drive Letter for MSDB database, IP address and port
Read more...
By
Steven Whaley
2013/04/11
|
Source:
SQLServerCentral.com
|
Category:
sql server
|
SQL Scripts Manager Compatible
Rating:
|
Discuss
|
Briefcase
|
1,002 reads
Finding out whether you are using enterprise level feature
The query tells whether sql server enterprise edition is using any enterprise level features or not
Read more...
By
Rahul Singh
2013/01/21
|
Source:
SQLServerCentral.com
|
Category:
sql server
Rating:
|
Discuss
|
Briefcase
|
981 reads
Get an alert whenever SQL Server restarts
This script will create a job and it will send a mail whenever SQL server restarts.
Read more...
By
SAI TEJA
2012/11/05
|
Source:
SQLServerCentral.com
|
Category:
sql server
Rating:
|
Discuss
|
Briefcase
|
783 reads
Unattended Install with PowerShell
A PowerShell script which will guide you through an interview and produce the configuration file(s) necessary for an unattended installation of SQL Server 2008/2008R2.
Read more...
By
Derik Hammer
2012/08/15
|
Source:
SQLServerCentral.com
|
Category:
powershell
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
825 reads
Session complete status and estimated completion time
A small retake on the popular percent complete script which tell how much more time an executing command will take.
Read more...
By
Hemanth Damecharla
2012/03/21
|
Source:
SQLServerCentral.com
|
Category:
sql server
Rating:
|
Discuss
|
Briefcase
|
846 reads
Get SQL Server IP Address
To Get Server IP Address without having to log into box or RDP
Read more...
By
Shirley Noa
2011/08/02
|
Source:
SQLServerCentral.com
|
Category:
ip addresses
Rating:
|
Discuss
|
Briefcase
|
2,614 reads
NetApp Dynamic Backup Script
TSQL Script to backup selected databases. Use this to override the script generated by snapmanager for sql in a sql job which doesn't cater for new or deleted databases
Read more...
By
Chris Taylor
2011/08/09
|
Source:
SQLServerCentral.com
|
Category:
sql server
Rating:
|
Discuss
|
Briefcase
|
677 reads
Rateio do valor do Item na Nota - Totvs RM
Essa função calcula a porcentagem do Item em relação ao valor da nota. Aplicável a Totvs RM. Em especial RM Núcleus.
Read more...
By
wamj
2013/06/20
|
Source:
SQLServerCentral.com
|
Category:
totvs rm
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
90 reads
Changing Foreign key names to standard naming convention across the DB
Rename the Foreign keys to standard notation - FK_childTable_ParentTable
Read more...
By
Vidyadhar Pandekar
2010/02/24
|
Source:
SQLServerCentral.com
|
Category:
foreign keys (fk)
Rating:
|
Discuss
|
Briefcase
|
1,079 reads
Changing Primary key names to standard naming convention across the DB
This script will rename the Primary keys to standard notation - PK_TableName
Read more...
By
Vidyadhar Pandekar
2011/07/29
|
Source:
SQLServerCentral.com
|
Category:
rename primary key
Rating:
|
Discuss
|
Briefcase
|
1,609 reads
BCP command to export data to excel with column headers
This script export data into excel/CSV file using BCP comnand with column headers
Read more...
By
Samardeep Khera
2009/10/01
|
Source:
SQLServerCentral.com
|
Category:
bcp command
Rating:
|
Discuss
|
Briefcase
|
2,906 reads
Create INSERT statements from Excel
Excel files includes a very good functionality called Macro execution. And here we can use this functionality to write one macro that will generate INSERT statements.
Read more...
By
Arun Mallick
2011/05/02
|
Source:
SQLServerCentral.com
|
Category:
insert
Rating:
|
Discuss
|
Briefcase
|
4,895 reads
Backup all DBs of a SQL-Server Instance
Backup all DBs of a SQL-Server Instance depending on Environment Variable "DBBackupPath". The script also distinguishes between Instances
Read more...
By
hangg
2008/05/22
|
Source:
SQLServerCentral.com
|
Category:
sql server
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
2,163 reads
Items 1 to 13 of 13
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
