Some starting points you might find here

http://www.sqlservercentral.com/columnists/dpoole/sqlandiisonthesamebox.asp

and on the discussion on this article.

Can you post what you have so far?

Another approach might be, to use MsQuery (comes along with Office, but isn't installed by default) to query SQL Server. I use this...

if object_id('myvarchar') is not null

drop table myvarchar

go

create table myvarchar(col1 varchar(8000), col2 varchar(8000))

go

insert into myvarchar(col1, col2) values(replicate('A', 8000), replicate('B', 8000))

select * from myvarchar

Achtung: myvarchar-Tabelle wurde erstellt, maximale Zeilenlänge (16025) übersteigt jedoch...

Looks like an Access design

http://www.sqlservercentral.com/columnists/sjones/pagesize.asp

You should try to stay within the limit mentioned in the article or rethink your design.

Hm,  change the smilie to a closing bracket

if object_id(N'[dbo].[MyIndex]') is not null

drop table [dbo].[MyIndex]

GO

create table [dbo].[MyIndex] (

 [id] [char] (10) not null,

 [col1] [char] (20) not null

) on [PRIMARY]

go

alter table [dbo].[MyIndex] with nocheck add

 constraint [PK_MyIndex] primary key 

 (

  [id],

  [col1]

&nbsp

Same here

Saving the scripts and applying it to your databases like Jonathan suggested, sounds pretty obvious to me.

If you have several databases with the same structure, I would create my own...

If this is for production code, I think it is not a good idea to allow connections with sysadmin privileges for normal users. Imagine anyone connecting to SQL Server can...

Would this help

SELECT COALESCE(t.Region,d.CoTeam) AS Team, c.CustomerName,

c.MasterFileComment AS [Brock ID], i.Comment AS [Reference Number],

i.InvoiceNumber, i.InvoiceDate, i.InvoiceDueDate, i.Balance,

DATEDIFF(d,InvoiceDueDate,GETDATE()) AS [Days Past Due]

FROM AR4_OpenInvoice i INNER JOIN AR1_CustomerMaster...

That's more than I can bear, Jonathan.

You got me going home now.

I'm out of my head right now.

CONGRATS, BRIAN KNIGHT !!! 

Man, I should check the page you've mentioned more frequently. It seems to get longer and longer each day.

Since when is Brian a MVP?

Hey, I'm married!

My wife has some very efficient methods to bring me back to reality. ....

Hm...where is the blackeye emoticon...

• Because some b*stards hacked the server last weekend.
• I don't have a current backup of the content
•