Extended Properties Introduction
Part one of a four part series intent on demystifying and making more accessible SQL Server extended properties
2013-09-27 (first published: 2011-03-17)
20,700 reads
extended properties
Using Extended Properties To Keep Everyone Informed
Use CMS and Extended Properties to store information about multiple servers, including the stakeholders who should know about any maintenance you are planning.
2014-01-01 (first published: 2010-11-30)
9,184 reads
Script to build a SQL Server Data Dictionary and report with Microsoft Excel
There is value in using the extended properties across some of the industry leading data modeling tools. What if I do not have access to any of those tools? Is it possible to build the extended properties and then be able to generate reports by using Excel or Reporting Services?
2008-12-09
4,930 reads
RE: Automating DTS Execution
Our requirements were very clear: - Make our DTS workflows available for CD distribution to new and existing clients This eliminates the ActiveX variant suggested by another reviewer; we cannot ssume that ClientX or ClientY, Z, etc - will allow us to install and run our controls. It's the reality out there... - Bring them in the DTS editor for running, no DTSRUN command line […]
2005-04-06
RE: Searching DTS Packages for a text string
Scott,DTS Packages are stored as COM structures, therefore you cannot search for texual entities in them. The Structured Storage File is a collection of COM Structures.. meaning it can contain multiple versions of COM Structures. Both are binary data.The only out of the box method of giving you a psudo representation of the textual aspects […]
2005-03-23
RE: Import/Export SQL Server database to Oracle.
Thanks for the replies. But I got the reply from the Microsoft Community and they gave the following link: http://support.microsoft.com/?id=247750 Go to this link to know more about the double quotes problem. Though the article says about SQL Server 7, but it persists with SQL Server 2000 too.
2005-02-24
Query error ?!!!
Hi every one...I execute this query : SELECT news_content.id_doc AS ID, news.publish_date, news.publish_time, news_content.title, news_content.abstract, news_content.lead, news.image_title, news.image_main, SUM(doc_view_stats.hour_00 + doc_view_stats.hour_01 + doc_view_stats.hour_02 + doc_view_stats.hour_03 + doc_view_stats.hour_04 + doc_view_stats.hour_05 + doc_view_stats.hour_06 + doc_view_stats.hour_07 + doc_view_stats.hour_08 + doc_view_stats.hour_09 + doc_view_stats.hour_10 + doc_view_stats.hour_11 + doc_view_stats.hour_12 + doc_view_stats.hour_13 + doc_view_stats.hour_14 + doc_view_stats.hour_15 + doc_view_stats.hour_16 […]
2004-12-06
4 reads
2004-12-03
How to ORDER BY using an @parameter
Is it possible to take in a parameter and use it as the column name or column number in the ORDER BY clause of a SQL statement? I've copied the SP_Columns stored procedure and created a new one from it. I want to specify a sort order as one of the parameters when I run the […]
2004-11-24
3,668 reads
DTS and 64-bit SQLServer
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-01-26
Blogs
Step Up Your Data Game: Learn Advanced SQL Techniques for Analysis
In the modern data-centric landscape, SQL stands out as the dominant tool. It's essential...
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers