Hi,

Would the results in a pivot be in a more readible/printable format?

my bad,

the shrinkfile will not help for this.

it will reduce size if the log is full.

Hi,

how about shrinking the log file with dbcc_shrinkfile, since the log is 99% free?

I personally found it to be better assigning the limit on what sql can use.

Leaving everything available to sql can cause the OS to stop responding, as was my...

do you have the query your app is running?

sorry not sure what you are asking

hi,

in asp your app is using an odbc connection.

when you migrated u, need to modify the odbc to look at the new server/instance

with triggering you have 3 options.

insert

delete

update

in case 2 above in writes data to a 'deleted' table.

option 1 and 3 writes to 'inserted'. in essence an update is an insert...

if you go to properties of the report, u can specify default parameters.

optionally u can set todate= startdate+5

start > control panel > administrative tools > data source

u should see the connection ur app is using. double click and click the test connection button at the end of...

try

select count(*) from inserted

no,

i had this issue on a custom app. but ur problem sounds the same.

try testing the ODBC connection.

if this works, then its ur app.

sorry thats all i got

i did have this some time ago, it was the date settings on the server.

it didnt look at '/' as a seperator only a '-'.

yip, was a update trigger trying to update. this was on 2000,when i double clicked the sspid under the locks/objects, it showed the query locking.

hope this helps