bump?

Eddie Wuerch (1/25/2007)

Check out the command-line tool RELOG. It allows you to take log files created by Windows SysMon/PerfMon and convert them to different formats, including exporting them to SQL...

This is similar to what I did. I have a table that stores all the servers. The SSIS grabs that recordset and puts it into an object variable....

You're looking for mySQL help, not Microsoft SQL server. You'd do well to find a PHP forum. They could inform you of some built in functionality that could...

We acutally found a reporting services query that was running against oracle and was pulling two tables - one with 15 rows, one with 500k. No joins...that was last...

I just thought it might come in handy, day to day, to get a quick return type instead of jumping to the manual. There is always some little trick...

Not exactly - a little more general.  I said a field in a select statement, not a column in a table - I guess I could have said 'item'.   Another example...

Thanks for the tip, but not exactly what I was looking for.

What about xp's?  Or If I say select @@servername?  I know that is a nvarchar...but is there an easy...

By space, do you mean memory?

Here is a procedure which will email alerts for sessions over a certain size and log others over another size you specify - I use...

This won't help you now, but you could have stored connection info in an .ini file and used the dynamic property task to set these values at runtime.

"This is where they will tweak their numbers and then want to overlay what they've done with the latest and greatest? or will they want to keep their various...

Yes, that's what I was referring to in the previous post - but they don't want to do that. This is for year end closing, so they want to...

I've put the option foward of having them save it manually to the share - where appworx(a job scheduler tool you may be familiar with) will be polling to pick...

Yes, reporting services will be used - the customer needs to look at the report which uses a stored proc and have a .txt file written to a server share where...

It looks to me like we are from the queries below.  Previously the lead developer on this system was granting permissions. We're moving to a new server and this...