i actually keep the correct link to that script to generate insert statements in my signature on the hopes it gets someone to post their data in the forum:

http://vyaskn.tripod.com/code/generate_inserts_2005.txt

well it's not a fixed ratio; a database with lots of varbinary/image/blob type data will have a less effective compression ratio than one that is mostly just text and numbers.

you...

based on his latest description, i think the issue has nothing to do with formatting...it's the master data is on row 1 of the results, but he wants rows 2/3/etc...

just make it easier on yourself...

create 5 views, one for each group of statements you will need to gather....

yeah the view will have the 12 statements for each synonym, but...

i'm guessing permissions maybe? the job when run under the SQL Agent might not have permissions to some shared resource or not? what is the job doing?

don't forget that the Express edition does not include the SQL Agent;

you should spend the $49 dolalrs and get the Developer Edition, which includes the SQL Agentand so much...

i think synonyms might be a good fit for what you are trying to do.

a synonym can point to an object..table,view,procedure, etc.

so you could make a suite of 12 synonyms...

formatting shouldn't really be done in the SQL if at all possible, but you can still do it.

one easy way is to convert the results to the right CHAR size:

SELECT...

doh i should have tested that: wrapped the datediff evaluation with the convert first, sorry:

select ABS(CONVERT(BIGINT,(DateDiff(minute, getdate(), '1900-01-01'))) * 60),

ABS(CONVERT(BIGINT,(DateDiff(minute,...

WayneS (8/5/2010)

---

If it's a registered server, right-click server and select properties. Go to the connection properties tab. Check the "Use Custom Color" checkbox, and select the color.

If it's a server...

the error is related to the actual data being tested/datediffed. one instance has data that is out of range.

when you use datediff with seconds, there can only be something like...

basically you have to determine that if any high ascii character(>127) exists, you want to use DESC sort order on the example i provided, but if no high ascii exists,...

things to look for:

1. the user would lose his permissions every time the database is restored to a version that did not have his permissions previously.

2. if this is object...

glad i could help; there's a lot to do in there to make it report-presentable..convert to decimal a couple of times along with the division and case statement;

much easier...

this should help you visualize; you'll need a case statement:

/*--results

KB MB GB...