When you decide on a connection string and add a Data Connection, each Data Connection also displays a tree of information about the database objects (like tables, views, and stored procedures) visible directly through the connection. But where does this information come from? Read this article from MSDN on the new features of ADO.NET.
2004-09-06
853 reads
Modification of DR_Script_Logins.sql by Bruce Canady.Puts out a script to add new logins or change the password of existing logins.I insert the output into a table in my production-db. insert database.dbo.login_table exec master.dbo.dr_script_loginsThat way its backed up with the data, and the logins can be restored anywhere by the script i added at the […]
2004-09-03 (first published: 2004-05-26)
2,532 reads
A Q&A look at the new Web Services configurations in SQL Server 2005.
2004-09-02
3,099 reads
From SQLTeam's Bill Granazio, a look at how he ensures his database scripts are always working.
2004-09-01
806 reads
A short tutorial on building database back-ended applications with SQL Server and CE. If you're looking to build mobile apps, this is a good place to start.
2004-08-31
541 reads
This script will search for text within stored procedures and udf's. As a bonus, it will also diplay a user-configurable number of lines from each stored proc to show the search text "in context" so you can tell if it is something you need to deal with without having to open every proc manually.
2004-08-30 (first published: 2004-05-25)
252 reads
This sp convert SQL Server data into any file format.eg xsl,txt,doc etc.
2004-08-27 (first published: 2004-05-15)
372 reads
In this article, we will examine "rolling average" aggregations, a common business requirement. "Rolling," or "moving," averages, involve a measure, the average under consideration, that is aggregated over a progressively moving window of time periods.
2004-08-27
1,555 reads
This SP can be used for bulk inserting data from an ascii text file onto a table. You have to change the structure, of the temporary table (ITEM_MASTER_TEMP) and the actual table onto which data is inserted, to suit ur needs . I wish you people workout this SP and try to optimize it as […]
2004-08-26 (first published: 2004-05-24)
203 reads
In this article, we began with a discussion of general business needs as related to the concept of relative time. We then undertook a practical, multi-step exercise, based upon a hypothetical business need, to illustrate a potential solution for a stated requirement.
2004-08-26
992 reads
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
By Brian Kelley
Every year, the South Carolina State Internal Auditors Association and the South Carolina Midlands...
Data Céilí 2026 Call for Speakers is now live! Data Céilí (pronounced kay-lee), is...
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Comments posted to this topic are about the item Your Value from a Conference
Comments posted to this topic are about the item UNISTR Basics
What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)
SELECT UNISTR('Hello 4E16754C') AS 'A Classic';
A: 
B: 
See possible answers