Viewing 15 posts - 16 through 30 (of 598 total)
What's the error?
Do you have any date time columns in the source table? Those can wreak all kinds of havoc when you bring them back to SQL Server.
March 12, 2012 at 12:20 pm
What do you mean by this:
If I can't use the Linked Server I can't perform a merge or an OUTER JOIN what combination of task could I use to accomplish...
March 12, 2012 at 11:49 am
The path is fine. It finds everything just fine. The only issue is that the one rollover file is blank.
January 26, 2012 at 12:09 pm
Bumping in case anyone who might have a solution missed it when it was posted...
January 26, 2012 at 9:27 am
The file is empty. Opening it up in Profiler reminds me of this. Opening a prior one in profiler then telling it to get the next (blank) one it doesn't...
January 16, 2012 at 1:05 pm
I'm using one of Michael's versions and I'm getting NULL values when there is a date and the time is 0.
i.e.:
last_run_datelast_run_timeLastRunDateTime
20081118 0 ...
January 9, 2012 at 2:16 pm
While it is generally a good idea to have tempdb spread across multiple files/drives, this would not directly address the poster's issue.
December 28, 2011 at 8:29 am
You have a query or queries that are requiring significant space in tempdb. Since tempdb is recreated each time you restart the server it will always start out at its...
December 27, 2011 at 1:04 pm
Howard: upper right hand corner of the code block is a set of icons. Second one in (the two pieces of paper) is "copy to clipboard". I just copied this...
December 27, 2011 at 8:55 am
Thanks everyone. I'll be taking bits and pieces of these for our diagnostics/reporting.
December 22, 2011 at 11:33 am
I'm the exception to the rule. We have processes that run monthly, quarterly and annually. We also have some mandated auditing. So we keep roughly one month of backup data...
December 12, 2011 at 1:09 pm
Lowell, what I do is pretty basic - on Tuesday start of day, off Thursday end of day (or thereabouts). Sometimes I'll turn users off towards the end of the...
December 12, 2011 at 8:58 am
I have a comparable scenario adn that's exactly what I'm doing. Job enables the login when I want them to have access, disables it otherwise. You may want to run...
December 9, 2011 at 2:24 pm
SQLRNNR (11/28/2011)
To get to parameters - select manage from the dropdown error for the report in question.
Yeah, I stumbled on that just before you posted (see above). That was indeed...
November 28, 2011 at 10:03 am
Urgh. Was poking around looking at a few things on the report server itself and noticed that there was a 'Parameters" tab. Looked there and it was holding on to...
November 28, 2011 at 9:33 am
Viewing 15 posts - 16 through 30 (of 598 total)