what is...

please check this link out

http://msdn.microsoft.com/en-us/library/ms175840%28v=sql.90%29.aspx

anthony.green (2/21/2012)

---

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...

SQLKnowItAll (2/21/2012)

---

Yes, but this is a 2008 forum and we should still use the tools given to us for the time being. I...

yes that is correct

sp_msforeachdb will execute the query depending on the number of databases you have, so if you have 5 databases it runs the query 5 times.

strange how you...

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.