Who is responsible for good database design and documentation when programmers are using these ORM tools that trivialize creation of the DAL? Very clever programmers with not much understanding...

I write to make the point that development standards differ depending on whether an application is being written for sale as a software product or for use within the company...

Thank you.  I never thought of doing this.

>>>

I work for a large-ish company where SQL Servers exist but are not recognized.

A company that has millions of $$ wrapped up in MS products but yet still does...

I have supported SQL Server databases for different types of companies-- a vendor of an ERP application written on platforms Ingres and  SQL Server 6.5; a manufacturing company that purchased...

This trick eliminates loop as well as cursor. 

1) generate a script

select 'insert into #t exec sp_dba_spaceused ' + name

from sysobjects where type = 'u'

order by 1

2) run the...

Thanks for including discussion of your methodical development and validation of this DBA utility you present.  It's my opinion that writing and using scripts built on sp_msforeachdb is the mark of a true...

I posted on this last spring---

Thanks for mentioning that the xp_execresultset is missing from SQL Server 2005.

Yikes!  Before retiring your SQL Server 2000 servers, do this--

1) Copy proc sp_execresultset...

Thanks for mentioning that the xp_execresultset is missing from SQL Server 2005.  Yikes!  Before retiring your SQL Server 2000 servers, do this--

1) Copy proc sp_execresultset from the master database of...

Wow.  Google is everything.  Thank you.

Excel is a source for DTS.  No need for openrowset either.  Just edit the worksheet to make (only) row A the column headers, point to the file after choosing the...

Consider that SQL Server runs only on top of Windows, so we assume copy and paste between windows.  I edit complex scripts in one window, using the editor I use...

I use Epsilon programmer's editor (little E for PC, evolved from Emacs) which I learned at Carnegie Mellon almost 20 years ago.  Notepad/Wordpad and application development environments with built-in editors...

Our company uses Great Plains accounting, one of the Microsoft Business Solutions, on SQL Server database. As the sa and dbo, I see all the tables and procedures. ...

If you think some real data owners are going to allow a SQL Server installation for which they don't have the sa password, you are living on planet dinky Access.