This script will provide the first four values required for estimating the size of a database table. It will satisfy steps one and two in MS estimation process for the amount of space required to store the data in a MS SQL Server v7.0 or v2000 table:1 Specify the number of rows present in the […]
2002-07-19
501 reads
Copy and paste this script into Query Analyzer and run it.Use this script to generate a simple security string of 0's and 1's.
2002-07-19
379 reads
Lists objects from database. Similar to 'dir' command from DOS 🙂Typical usage sp_dir 't' 'order*', 1 - returns list of all tables whose name start with 'order' plus their columns and data typessp_dir 'p' 'custom*_sp' - returns list of all stored procedures whose name start with 'custom' and end up with '_sp'For list of […]
2002-07-19
490 reads
a Basic Example of how to use TEXTPTR and updatetext in T-SQL to MANIPULATE text columns
2002-07-18
916 reads
a Basic example of how to manipulate an IDENTITY COLUMN AN HOW TO STOP the automatic counting using SET IDETNTITY_INSERT
2002-07-18
706 reads
procedure is an extended xp called xp_getNetName to get the computer network identifcation name
2002-07-18
772 reads
a Procedure to get the SQL sid for a Login either SQL standard or WINDOWS authenticated
2002-07-18
1,010 reads
there are 2 extended STORED PROCEDURES xp_dirtree will get the directory name and nesting level from a given parameter root directory xp_subdirs will get the directories list in the first sub level from a given parameter root directory
2002-07-18
908 reads
THERE is an extended sp called xp_fileexists given a full path to a file Name information is a 3 Bit vector 0/1 if a file doesn't/does exist0/1 is given name is a directory0/1 if the parent directory exists
2002-07-18
1,082 reads
A function to enctypt a string good for hiding passwords in the database comparing password is done via the PWDCOMPARE function
2002-07-18
1,098 reads
By Chris Yates
I get asked a lot about why or how I began working with databases...
By Steve Jones
Earlier this year I visited a customer that was using the Redgate Monitor webhook...
By Zikato
TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree....
Choosing the right Ophthalmologist in Dubai starts with checking credentials, experience with children, and...
Comments posted to this topic are about the item SQL Server 2025 Unveiled: The...
Hi, we lost our sever sql2000 To restore database to a new one we...
I run this code:
create database experiment
go
use Experiment
go
select DATABASEPROPERTYEX('Experiment', 'LastGoodCheckDbTime')
What is returned? See possible answers