Hi GSquared,

Thanks for the hint - i'll give it a try.. though ultimately I can't change the sql itself (the sql generated via reportbuilder - and I cant change the...

thanks willywonka, but as original post states, they weren't willing to pay for any 3rd party software.

i put powershell script together and got it done that way..

thanks anyway 🙂

permissions can certainly cause you some problems early on when developing locally -

local machine

dev server

prod server

is my normal approach, so if i have problems, i can fix em in...

thats what i figured from the slowness of the report.. was hoping otherwise of course

thanks for the reply jack 🙂

I would certainly agree with matt - I think you'll be much better off buying the developer license and installing directly on your own pc - you can create apps...

Thanks Roy - appreciate the suggestion,...

Bru Medishetty (2/8/2010)

---

I usually start with the log file size set to 1/4 of the Data file size and most important, I would never have the autogrowth set in %,...

Right or wrong, I've always started out at 1/3 my datafile size..

so a 100mb database would have a 33mb log file.. of course, this changes fairly quickly as I...

I found this a couple of weeks ago when I was looking at getting the size of my tables (my data file got very large and i didn't know why)...

tell them its a $20 fine per object created in master database.. should see that drop off fairly quickly.. or.. you have a lot of spare beer money which should...

Msg 22049, Level 16, State 1, Line 0

xp_delete_file() returned error 2, 'The system cannot find the file specified.'

is what I get if I run it outside of my script

Its not an individual step, its part of a larger script

CREATE PROCEDURE myProc AS

-- do stuff

xp_delete_file

-- do some more stuff

GO

then the job step is

EXEC myProc

Well,

I know WHY it was failing.. i was sending a path that doesn't exist to the job.. but still pretty bummed out that the failure kills my whole job.

when you say all the databases are on a centralized server.. you mean on the same sql instance?

If they are.. then I don't see the point in multiple databases assuming...

why would you even want sql server to execute a webpage, or do you mean to have sql server provide the url? or have sql server send the email?