Viewing 15 posts - 91 through 105 (of 192 total)
bump?
January 11, 2008 at 10:48 am
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...
December 7, 2007 at 4:50 pm
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....
December 7, 2007 at 4:44 pm
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...
November 9, 2007 at 4:18 pm
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...
November 8, 2007 at 11:59 am
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...
September 22, 2007 at 1:28 pm
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...
September 21, 2007 at 4:01 pm
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...
September 21, 2007 at 2:25 pm
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...
August 23, 2007 at 10:55 am
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.
August 23, 2007 at 10:44 am
"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...
August 23, 2007 at 10:41 am
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...
August 22, 2007 at 8:02 pm
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...
August 22, 2007 at 4:14 pm
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...
August 22, 2007 at 2:19 pm
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...
July 13, 2007 at 10:06 am
Viewing 15 posts - 91 through 105 (of 192 total)