another obvious fix would be to simply copy all the files form 140 folders to a single folder, and use the example i gave against that one folder.

I presented an idea and example to get you part of the solution. I thought it would get you started...you really didn't provide anything concrete as far as true requirements.

it...

is your DNN instance local, on your network, or on some shared hosting server like ihostasp? I know my shared hsoting sometimes bogs down, but it's hard to diagnose a...

here's an example i like to post using BULK insert. you can do this via SSIs as well, but it's a different technique.

in my example below, i have 4 known...

note: thread is 4 months old.

ok, i've seen people knee jerk on things like that...

You could mask the CASE statement as a SELECT (or JOIN it to your other data) like this:

/*--Results

(No column name)StartParamEndParam

DailyNULL2011-04-13 14:44:10.230*/

DECLARE...

how about nslookup mail.yourserver.com to see what the DNS reverses to, or a ping mail.yourserver.com and see the address it's going to;

why do you need it's IP vs the DNS...

ok actually, I believe this shows you some of the info specific to a linked server:

SELECT *

FROM ::fn_dblog(NULL, NULL)

where [allocUnitName] IN('sys.sysxsrvs.cl','sys.syslnklgns.cl')

but without a way to tie it to a user,...

Remember the transaction log does not retain any information about WHO performed any operation.

I cannot see it pointing to the level of detail you are looking for, like object...

the destination mail server? like whatever mail.yourserver.com resolves to? or the ipaddress of the SQL Server Sending the mail to that server?

http://support.microsoft.com/kb/920093 (4/13/2011)

---

Trace flag 836: Use the max server memory option for the buffer pool

Trace flag 836 causes SQL Server to size the buffer pool at startup based on the value...

yes, exactly...but don't take my word for it; play with this example i just slapped together: you get multiple rows back IF your function returns multipel rows:

CREATE Function AvailSizes(@ObjectName varchar(30))

returns...

it's kind of confusing, yeah.

no common data is required between the two.

I try to think of an ITVF the way UPPER() or ROW_NUMBER() function works: it's going to return something...

I'm afraid you are out of luck, unless you have a separate DML trace running prior to the offense.

adding and dropping linked servers are not DDL operations, and do not...

Paul i poke around codeproject.com an awful lot for grabbing .NET examples to adapt to my idea at the time, but I don't have a vb.net oriented forum handy for...