You may want to check out the File Properties Task custom component created by PragmaticWorks:

http://www.pragmaticworks.com/FilePropertiesTask.htm

You can use the default trace that is running on SQL Server 2005, it Audits logins and logouts so you can use the Audit Login event to see the logins...

This line:

field2 like '%some other value%'

Using a leading wildcard means an index normally will not be used.

You can only use a trigger for Insert\Update\Delete queries not Select and I don't think you can get the query text then either.

You can use SQL Server Profiler to set...

Sure. In SSMS go to SQL Server Agent -> Right Click -> Select Properties -> Select History and you can set the number of history rows total and per...

I don't know anywhere where the user name is stored. You can create a DDL trigger that can track that event. You also can check the default trace...

IF you are really running on SQL 7, 2000 then you are out of luck if you application/database does no auditing and you don't have a trace already running.

If you...

Hey I typed faster this time.:D

This will work:

create table #MaxCal ( Col1 int ,Col2 int ,Col3 int)

insert into #MaxCal select 12 ,53,65

insert into #MaxCal select 54,67,43

insert into #MaxCal select 12,67,35

Select

Case...

Try this:

Where

Case

When @PageSize = 0 Then 1

When RowNum Between...

Greg Charles (9/2/2008)

---

If this is a DTS package, Jack's BIDS suggestion won't work and, unfortunately, there isn't a way to copy a Data Transformation task in DTS Designer. Lot's...

Jeff Moden (1/2/2008)

---

The real point here is that you should not be using any form of RBAR in a trigger... no matter how you do it, calling a RBAR proc...

I have always used oledb connections and the "?" is the parameter placeholder in oledb. For the ADO.NET connections to SQL Server maybe you need to provide the parameter...

Try localhost without the parentheses.

A key point here is to make sure the events you are tracking include the TextData column. One way to get this working is to start a trace filtering...