sure.

on the 7zip web site:

http://www.7-zip.org/download.html

the fifth Download link explicitly says

"7-Zip Command Line Version"

download that, the syntax is inside.

to zip a file based on your previous example, the command...

it's by design.

access to base objects is not ownership chained to views/proc/functions that access that object. so when accessing the view, permissions to the objects that view access is not...

via tsql, those custom attributes are not exposed, i think.

the application name and the host name are...if you do not provide it explicitly, the driver populates it for you automatically,...

i think if you create the CSV, it would have ALL the records...it's just earlier versions of excel would only DISPLAY 65536 rows.

open the file up in an enhanced ...

ningaraju.n (11/17/2010)

---

Hi Lowell,

When i executed the query which was mentioned by you,I got the list of files hence I hope the problem is not due to the path.

Regarding the winzip150.exe...

looks like the dates were simply converted to decimal to me:

/*--results

(No column name)(No column name)(No column name)

2010-11-17 16:50:38.717404982010-08-17 00:00:00.000

2010-11-17 16:50:38.717404982010-08-17 00:00:00.000

2010-11-17 16:50:38.717404982010-08-17 00:00:00.000

2010-11-17 16:50:38.717404982010-08-17 08:30:51.263

2010-11-17 16:50:38.717404982010-08-17 00:00:00.000

2010-11-17 16:50:38.717404982010-08-17 00:00:00.000

2010-11-17 16:50:38.717404982010-08-17...

just a basic double check....after clearing cache, the FIRST time a proc gets run, it's slower, as a new execution plan gets created, adn that takes time...but subsequent calls after...

is winzip150.exe a GUI? that might be an issue, especially if it is raising that nag screen about registering...you know...you've been using Winzip for 483 days....

you need to use an...

ok, run this to find the current recovery interval setting:

USE master;

GO

EXEC sp_configure 'show advanced option', '1';

RECONFIGURE;

EXEC sp_configure;

USE master;

GO

if needed, lets set the interval to a shorter time

--The following example sets...

I doubt very much the issue is CHECKPOINT not running.

I'll bet your database is set to Recovery Mode = FULL, and you are not taking regular transaction log backups, so...

don't you just need to compare the convert of the column to itself to see if they are not equal to find items that are not in range?

something like

select...

there is a project on codeplex to help do this kind of thing in either direction; i downloaded it but did not test it yet, but it might help you...

so, do the calulation from stratchpad2 every time, but items in sp4 are only sometimes there...

like this?: (new calculation for "specminutes")

SELECT

name,

employeenumber,

summinutes,

sum(summinutes/60) as...

I *think* the OP is...

there's an inner join in your query, which would limit the data to only the employee's that exist in BOTH tables...is that what the problem is?

...

inner join scratchpad4

on scratchpad2.employeenumber =...