if you only need data from one database then you dont need to use sp_msforeachdb.

issue the following and post the results

sp_msforeachdb 'USE [?]; SELECT TOP 1 * FROM sysobjects'

if you do

select count(*) from sys.databases

does it return 23 rows?

what your seeing is that you have used sp_msforeachdb but telling it to go back to the chapter database so what...

The T-SQL in my first post used sp_msforeachdb and loops through to get all records from sys.tables in each DB

feeling helpful today

CREATE TABLE #TEMP

(CustomerID INT,

ServiceType VARCHAR(20),

StartDate DATE,

EndDate DATE)

INSERT INTO #TEMP VALUES (1234, 'ServiceA', '2010-05-25', '2011-07-15')

INSERT INTO #TEMP VALUES (1234, 'ServiceA', '2011-07-16', '2011-09-18')

INSERT INTO #TEMP VALUES (1234, 'ServiceB', '2011-09-19', NULL)

INSERT...

I take it you want all the tables from each database?

sp_MSForEachDB 'USE [?]; SELECT * FROM sys.tables'

this is...

seems like the smtp server is not accepting your IP as an SMTP client.

are you using Exchange? has the servers IP been granted the nessesary access on the SMTP...

Does it have to be done in T-SQL?

You could right a few lines of code in powershell which will loop through all the procedures and dump it out to a...

could also use SSIS with the transfer logins tasks

Please provide the full DDL and sample data along with your expceted results so we can assit you better.

Please see the first link in my signature for more info.

damn that was fast

create table #temp (x char(1), y char(1))

insert into #temp values ('a','b')

insert into #temp values ('a','b')

insert into #temp values ('a','c')

insert into #temp values ('a','c')

insert into #temp values ('a','c')

select row_number() over(partition by...

Nope, thankfully since I have moved on from the old position...

here is another link as well, this one is a bit more printer friendly

http://www.simple-talk.com/sql/sql-training/ssms-the-query-window-keyboard-shortcuts/

how do you determin that the session is closed?

are you sure its just not SQL reassigning the SPID to a different connection?