i've used Process Explorer from sysinternals in the past

, as well as OpenedFilesView

http://technet.microsoft.com/en-us/sysinternals/bb795533.aspx

http://www.portablefreeware.com/?id=1030

it depends on what you want to monitor, of course.

so general tools i'm aware of are like this one...

Dell's Spotlight Freemium is pretty good for free, i kind of like...

and the issue is often not really related to the number of rows, but if it can be accessed effectively and with reasonable speed.

that starts bringing in things like design,...

you probably want to cleanup line2 as well;

i think it's something like this:

CREATE TABLE #address(AddressID int, Line1 varchar(100), Line2 varchar(100) )

INSERT INTO #address

SELECT '1234','123 Main St.','Suite 2000' UNION ALL

SELECT '6596','2400...

looks like you posted before you did anything more than pasting some sample data.

what is the question?

since your new, i've reformatted your paste into consumable format...then anyone can grab your...

could it be because the SSMS settings is defaulting to a 256char display limit for a column length, in order to conserve resources?

on both the Results to Grid and Results...

how can another procedure consume the data of a dynamic procedure, if it doesn't know what columns would be included?

typically, you create a temp table and insert into it, ie:

CREATE...

Perry Whittle posted a nice script for scripting all database permissions in this thread;

I've adapted that one to my own needs:

the important part there is probably the nested roles, plus...

according to this msdn, it seems like the range you are choosing for your LSN start and end are invalid, and it raises that exact error:

could it be that your...

you've got to differentiate between LOGIN and ACCESS

a login occurs once, and might have a reference a database in it's connection string, but it never "logs into" a database.

After...

does your query use the NOLOCK hint?

onixsoft (10/1/2014)

---

Lowell (10/1/2014)

---

you are overthinking this if you think you need an app for that.

no "app" is needed for this, as the data entry for any app that tried to...

you are overthinking this if you think you need an app for that.

no "app" is needed for this, as the data entry for any app that tried to do this...

either drop the table once at the very top, don't use two different statements.

also, you could modify the query to be a single one with a case statement:

CREATE PROCEDURE MyProc...

writing to disk requires either an external application, like somethign written in .NET , or using bcp or a CLR object to help you do it.

there's no native way ...