Reset Identity Column with sp_IdentReSeed
Getting tired of dropping tables just re-seed the identity column? Remember, TRUNCATE TABLE doesn't work with foreign keys on tables. --EXAMPLE:DELETE FROM MyTablesp_Reseed 'MyTable'
2002-04-22
1,081 reads
Scripts
Send True SMTP Mail using CDOSys instead of CDONTS
SQL Server 2000 and Windows 2000 Only.Microsoft suggest using CDOSys rather than CDONTS. CDOSys stands for Collaboration Data Objects for Windows 2000 Subsystems. Below is a script that allows you do do just that. NO EXCHANGE REQUIRED!! Sample sends the user HTML Mail!Be sure to change @ServerIPAddr to your SMTP server.
2002-04-22
1,915 reads
sp_CHARINDEX
Here's a stored procedure version of udf_CharIndex for SQL Server 7.Sample Usage: DECLARE @iPos INT DECLARE @nRet INT EXECUTE @nRet = sp_CharIndex 'W', 'Hello World', @nPos = @iPos OUTPUT IF @iPos > 0 PRINT 'found' ELSE Print 'not found' PRINT @iPos --Only uses on character.
2002-04-22
550 reads
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
543 reads
Change the User Defined Data type
User Defined Data Types (UDF) is one of the useful concepts in SQL Server. However UDF can't be modified after they are being used. You would have to remove your User Defined Data Type from each table before you can change it. This will be a big job under certain circumstances.This procedure changes all tables […]
2002-04-19
1,022 reads
Display columns information
This procedure will return useful columns information for VB developers. It shows column name, data type, size, vbtype, checktable (refferenced table) and flags: NoNull, IsIdentity, IsPK.Calling sample: mysp_columns 'customers'
2002-04-19
707 reads
Case sensitive CHARINDEX Function
Microsoft missed the code boat on this one. Use this function to find the true index of set of characters.
2002-04-18
586 reads
Script to list all user and roles
This script list all the users defined for each database on the server, it give the database name, the login name and the role defined.Its use full to have quick view of witch users are dbo on witch databaseEnsure that you have the result in grid in query analyzer, and just cut and paste the […]
2002-04-18
954 reads
Write Reports from SQL to Disk (Even HTML!)
Ever need to write reports out to a folder? I have found that creating output files are SA-WEET! (and easy too) The sample script uses BCP to create an HTML file.This process works well for reports that need to be generated nightly and take too long to run in real time. Use an SMTP mail […]
2002-04-18
4,406 reads
Decimal to Binary Conversion for event scheduling
This procedure was written to create an event schedule where the schedule may have non-consecutive days. The input for the procedure is START DATE, END DATE, and DAYMAP The DAYMAP input parameter is a decimal number whose binary representation describes the schedule days over potentially a 4 week period (read from right to left). […]
2002-04-17
306 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
How to change the FDLaunch Error log file location
The file FDLAUNCHERRORLOG gets created in the default <instance>\MSSQL\Log folder. So far, I've found...
what data type i should use for roversion col and can i use less than greater
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...
Question of the Day
A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers