Sorry Rob; i thought it was a low hanging fruit question....

I assumed somethign i should not have.

oops i misread the question...no i do not know of a way to get the results of a procedure call into a dynamic table, oither than what you already asked...openrowset...

i think something like this would be better than sp_msForEachDB:

I prever to generate possible statements, review and prune,a nd then run them when I'm ready

/*

USE SandBox; create master key encryption...

ok 3 years ago i posted this forum answer on the same subject, along with vb6 source code and sample stuff to download a web page:

http://www.sqlservercentral.com/Forums/Topic453789-5-1.aspx

read the article and see...

built in it's not possible...anything outside of a sql database requires something special.

you can do it with sp_OACreate, and get the data back in 4000 byte chunks untiol you have...

i think this does what you wanted;

i grabbed a subquery of the items that would be marked as closed....everything else would still be open, right?

SELECT

#TestTable.ParentId,

#TestTable.ChildId,

#TestTable.RecordType,

CASE

WHEN MyCloseItems.ParentId...

@Name varchar(5000),

all your variables must be nvarchar, including the procs definition and the final resulting column;

otherwise you get an implicit converison, which changes it to quesiton marks...

that error says the table already exists in the hwdata schema.

do a quick

select * from hwdata.DesktopSoft_Master

select * from dbo.DesktopSoft_Master

decide which one to keep (say dbo was the "good one"

then...

sounds like security: remember in SQL 2008, or whenever installed on win7/server2003 and above, local admins on a box are no longer admins in SQL.

connect as sa, add your...

if the application is logging in with a SQL login, you cannot get the NT user information.

Going forward, you'd have to change the application to start passing thru the NT...

a server side trace typically has no performance impact, unless you create a trace that is logging everything; every column and every event would probably be a bad idea.

I'm in...

msdb has some tables which contain the errors and their details.

i create a view to make them eaiser to access, i think this might help you.

i get errors like this:

...

jamesnt (8/16/2011)

---

LOL!

We have an issue where after data entry, certain fields need to be verified. I was hoping to create a SSIS package that end users could...

a foreign key always prevents truncation.

to do the same thing it requires two separate steps.

instead you have to delete, and then maybe reseed the identity

DELETE FROM MyTable

DBCC CHECKIDENT( [MyTable],RESEED,1) --reset...

no...SELECT * FROM sys.objects selected from the current database.

sp_msForEachDB 'select

''?'' as DbName,

name

,object_id from ?.sys.objects

where object_id = 2073058421 '

would show you all the objects that , buy...