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

glad I could help a little bit; post your scalar function here if you need help converting it to an ILTV;

yes and no;

javascript in and of itself can't do it alone; it requires a postback to the server;

so you need to either use a form post (submitting the whole aspx...

Dan's right where whenever GUID's are generated with a newId() function, they are unique, but if the business process was using them for FK equivilents, you can find out easy...

a clustered index does not have to be unique. it just stores the data in the order of the index for the fastest retrieval of the data.

you are confusing a...

management expects you to use your professional expertise...

don't you have to set both the connection timeout and your command object's command timeout?

this works fo rme for example, waitng 45 seconds to make sure it lasts longer thna...

heck i'm throwing all sorts of numbers out there; i think i made my numbers extra huge to kick up some dirt so people would say "no! that's too much"

ok...

I think you are supposed to use SUSER_SNAME() in most situations.

i believe the difference is SUSER_SNAME() would return a domain\username for those people who are not explicitly on...