xp_cmdshell error return value
The error checking seems to work better than the @@error after exiting out of a xp_cmdshell DOS task concerning a failed or successfull attempt.
2003-09-26
525 reads
Edward Pochinski
2002-06-04
452 reads
sp_dba_checkblocked fix for sp_NotifyBlock
Problems with error 512 more than 1 result returned due to the operator outside of the query. Found this when tested with multiple blocks going on at once. It worked fine when there was only 1 block. Depending on the type of server there can be a "whole lot of blocking going on "Replaced with […]
2002-01-01
806 reads
Table Space for Each Table
This uses sp_MStablespace from an article on this site and a cursor to run against all tables in the context of the db it is called in. One catch is it does not like table names with spaces.
2001-12-30
743 reads
Determine Who Has SA Access
This simple view will return the name, loginname,hasaccess,dbname and create date and updatedate where sysadmin or serveradmin is set to 1 from the syslogin table. If the hasaccess column is set to 1 the access is granted.
2001-12-28
1,301 reads
OSQL Process Watcher
These 2 files plus sleep.exe (Resource kit) gives an administrator a good view of important blocking statistics in almost a real time fashion. You can use this with profiler to obtain some unique information very fast on a lead blocker if your gathering the right counters in profiler and dumping them in a table and […]
2001-12-10
520 reads
The Log Watcher
A fast way to get a quick look at all the log sizes and space used in a real time fashion.
2001-09-25
2,523 reads
DBCC SHOWCONTIG in all Tables
Use this script to see showcontig for all tables in the context of the database in which its called. Very handy to schedule during off peak hours prior to any re-indexing to see how bad things are and re-build certain indexes sooner than you thought for peak performance.
2001-08-20
4,080 reads
Script to Zip a Backup File
A handy dandy proc that can be used to zip up a backup file to location specified. Also called from a backup script to automate the compression of all backups using PKZip command line utility. Make sure pkzip is in the path and found by the shell prior to using this script.
2001-08-20
3,715 reads
Script to Search SQL Error Log For a String
This script(sproc)uses xp_cmdshell from sql and FINDSTR from DOS to search the current errorlog for a specific string such as kernel or failed login. Compile this in the master db and if you do not pass an input parameter a example usage will display for you. ex: sp_dba_sqlerrorlog kernel Edward J Pochinski III
2001-08-13
1,896 reads
Blogs
Unlock the Power of Your Data: From Basic to Advanced Data Analysis
Data isn't just about numbers and spreadsheets. It holds stories, patterns, and the answers...
Attacking the Weakest Link
By Brian Kelley
When I look at a system and think about its security model, the first...
Webinar – Microsoft Fabric for Dummies
On Wednesday May 15th 2024 I will give a free webinar on MSSQLTips.com about...
Forums
What is Carisol 350mg ?
Carisol 350mg is the main ingredient. Its powerful formulation, which includes the active ingredient...
The "ORDER BY" clause behavior
Comments posted to this topic are about the item The "ORDER BY" clause behavior
Are IT Certifications Still Relevant?
Comments posted to this topic are about the item Are IT Certifications Still Relevant?
Question of the Day
The "ORDER BY" clause behavior
Let’s consider the following script that can be executed without any error on both SQL Sever and PostgreSQL. We define the table t1 in which we insert three records:
create table t1 (id int primary key, city varchar(50)); insert into t1 values (1, 'Rome'), (2, 'New York'), (3, NULL);If we execute the following query, how will the records be sorted in both environments?
select city from t1 order by city;See possible answers