here's how i would do it.

I'm assuming that you are using US format for area codes..(800) xxx-yyyy ext.zzzz

some of your area code exampels started with 1, i.e. 109, which does...

here's how i do it:

FormattedDate SQL

20090320-09:33:49:700 SELECT CONVERT(VARCHAR,@date,112) + '-' + CONVERT(VARCHAR,@date,114)

20090320-093349700 ...

Brandi one of the best forum platforms out there for phpBB/MySQL stuff out there is phpBB http://www.phpbb.com/%5B/url%5D

free, open source,

full featured easy to use, huge deployment so you can find...

yeah, for event 12 SQL:BatchCompleted, even when everything is enabled, there is a lot of null columns, i can see that you want to capture just certain data depending on...

you need to add a different trace; a great example from Perry Wittle is found here:

http://www.sqlservercentral.com/Forums/Topic576752-146-1.aspx

AFTER that is in place, you will be able to determine who ran a SQL...

Perry your code example was very helpful for me today, as I wanted to create a DML trace to be a companion to the existing DDL default trace.

so I played...

here's my comparison snippet for SQL 2000:

create table #rowcount (tablename varchar(128), rowcnt int)

exec sp_MSforeachtable

'insert into #rowcount select ''?'', count(*) from ?'

--tablename is [dbo].[TBLNAME] instead of plain...

Maxim's right, unless...

Maxim's code will work, and would obviously only run for the tables that exist in your counting table...

but if you compare it to the set based solution, it'll be a...

simply run the script. it counts the table rows,even for tables with no indexes or primary keys (heap tables).

so you could potentially do something like this:

UPDATE MyDBCount

SET PrevRowCount...

Michael (3/19/2009)

---

There are a few hundred tables and I only need info on about 50.

Looping through an extra 150 tables (some of which are quite large) would take too long.

Also,...

SELECT INTO syntax is designed to create a table on the fly.

i believe a linked server only allows you to add/insert/update into existing objects....not CREATE objects on the fly like...

very easy, just plan it out.

1. take any of the scripts that count rows from sysindexes. no need to filter which tables at this point.

2. put the results in a...

Keep at it Krishna;

I'd like to see a default Data Manipulation Language (DML) trace automatically running all the time as well as the Data Definition Language(DDL) trace;

just to be...

default trace keeps track of when database objects, like tables/views/procs where created/modified or deleted.

it does not keep track of when they were executed or accessed.

you must create your own trace...