Hold on a sec... just had a thought... is there any chance that the service account SQL runs under might need to be a local admin on the box? ...

Unfortunately, I have no idea. UAC has always been such a royal pain that the only servers worth leaving it turned on would be those that are externally...

Any chance there are permissions on this object? I'm not very familiar with DTS or SSIS, but after seeing your post about sysadmin rights solving the problem, the...

Do you recall being provided the option to specify the administrator password for the SQL Server instance during the installation process? Had you not just done a...

Just a thought, but doesn't automating it kind of defeat the purpose? After all, if the automation fails to fix the underlying problem before the re-run occurs, it's...

I'm pretty sure there's a part of the following query that is probably in some way not going to scale up well, although it runs in my SQL 2008 R2...

Well, I finally got around to trying the install once again. Now that I've had opportunity to see a similar but slightly different problem with SQL 2008 (not...

Thanks for the analysis. It would be interesting to hear what sayeth Microsoft on this, given that Access 2007 displays the same behavior. The "hole" in...

With slightly more info from the company, I'm going to let the AD group go by the wayside, as that's just one more thing for them to maintain, and future...

Hello All,

This problem remains... I see 77 views and no one can offer any guidance ? Would "pretty please with sugar on top, whipped cream, and a cherry" help?...

First, make a copy of this database and import all the external data sources (as tables) that are NOT already on SQL Server. Then look to see if...

The last couple of posts even bring to mind the idea that the manager may have a different mental picture of exactly what constitutes a clone, as the term is...

Wow... 45 views and not even 1 response from anyone other than me? Does anyone have even any general guidance on this? Anyone?

Steve

(aka sgmunson)

You don't need any recursion for this. Start by thinking about the logical requirements for a time to qualify as a start time. For example, there...

I managed to dig out the SQL book that talks about the concept of identifying sequences and such, and was able to find a routine that identifies overlapping sessions from...