This procedure will be useful for developers/ database designers / DBAs to find the rowlength instantly.
To find the row length of a user table, just copy this script into Query analyser and pass the table name for which you want to find the rowlength. @TabName is the table name parameter, if we donot provide this while execution the procedure returns table length for all the user tables in the logged in database.
View/Edit ASP Script from From SQL Server 7.0/2000
Ever want to display (and edit) ASP code from the original .asp file? (like PHP's PHPInfo() function).To setup: * Just create a .asp with SQL Server connectivity. * Change @IISHostNameWWWPath to match your servername -OR- if SQL Server is on the same machine, use the next line instead. (see […]
2002-04-22
529 reads