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
624 reads
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,085 reads
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
831 reads
Microsoft missed the code boat on this one. Use this function to find the true index of set of characters.
2002-04-18
638 reads
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
980 reads
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,551 reads
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
339 reads
Following script gives an example how to handle errors inside stored procedure with returning information about type of error occured
2002-04-17
1,748 reads
There are times you want to kill all the connections in a database. This would do that trick. This can be very useful when you replace a database regularly and some connections still exist so your automated restore fails. You can issue this command to kill all the connections before issuing a restore command.
2002-04-17
2,545 reads
During some maintenance task, you might not want any one to connect to a database. This script would help you do that. If you need to run this script, you might also need my other script to kill connections.
2002-04-17
809 reads
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Palantir is an American software platform that brings together business data from different sources...
While attending SQLCon and FabCon Europe in Barcelona, there were a lot of announcements...
Comments posted to this topic are about the item Pay for Performance, which is...
Comments posted to this topic are about the item Packing and Decoding Device Status...
Comments posted to this topic are about the item SQL Server Audit Failures
If I have a SQL Server Server Audit setup, what are my options for configuring the instance in the event it can't write to the audit log?
See possible answers