We don't have any datawarehouses but have datamarts (corner shop variety). I use procs, dts, scheduler for whole process from data extraction to cube build. It works for me

SELECT

'Name : '+[Name]+CHAR(13)+CHAR(10)+

'Address : '+Address+CHAR(13)+CHAR(10)+

'Country : '+Country+CHAR(13)+CHAR(10)

FROM tablea

 

I'm on SQL7 SP4 and it works fine for me.

What are you using to check column alignment (proportional font!)

In addition to SQLBill's observation you are also grouping by mor columns than you are selecting. Try this

SELECT fname, mhlka, sog, COUNT([id]) AS Count_id

FROM dbo.searchall

WHERE...

Good article Andy. My apps use common code for connection strings so adding this would be easy for me. As I do not have a large user base for my...

ISQL & OSQL are the DOS batch file equivalent of ISQL (aka QA Query Analyser)

use

ISQL -S servername -U username -P password -d database -b -m-1 -i scriptfilename

if ERRORLEVEL 1 pause

-b...

I put all my procs in separate files and use ISQL on the file I want to update my database(s). You can put several ISQL commands in a batch file...

This might be near

as you mentioned create table of database sysobjects

CREATE TABLE #obj (dbid int,dbname varchar(128),objid int,objname varchar(128))

insert sysobject details

EXEC sp_MSforeachdb @command1 = "INSERT INTO #obj SELECT d.dbid,d.name,s.id,s.name FROM...