Viewing 15 posts - 2,341 through 2,355 (of 2,905 total)
I've not had luck with the debugger either. I always get errors about DCOM and possible firewall issues when I try to run the debugger. Which makes sense as I...
August 22, 2017 at 10:07 am
As much as I hate to suggest it, this sounds like a job for a cursor.
Do you have xp_cmdshell enabled or access to use it? You will need that...
August 22, 2017 at 9:00 am
Thanks for posting the solution!
I have not worked with using XML Name Spaces inside SQL Server, but now I do know how to do it.
August 21, 2017 at 3:37 pm
Geeze, I seem to be bad at offering advice today, eh?
I apologize for the misinformation I provided.
That being said, and back to the OP, I don't...
August 21, 2017 at 10:42 am
Right... forgot that developer only went free with future versions.
With express, does that let you do SSIS? I can't remember and it has been a very long time...
August 21, 2017 at 9:10 am
I think that you need to use Visual Studio 2008 (with the SQL Server Data Tools installed) and that should allow you to create SSIS pacakges to run against a...
August 21, 2017 at 8:33 am
Pretty sure Express doesn't include the advanced things like SSIS. It should be part of the install (Integration Services). I actually thought that SQL Server Agent didn't work with express...
August 18, 2017 at 3:25 pm
Not sure if I'm helping or not, but I know where I work, we have a separate job for cleaning up the history. My preference is to have a maintenance...
August 17, 2017 at 10:25 am
OH... you could likely sum it over a partition then, no?
It is the t.MktDiff column that you are trying to sum up... what if you change the line:
August 16, 2017 at 11:20 am
August 16, 2017 at 9:21 am
After it is...
August 16, 2017 at 8:34 am
Do all of your parameters need to be unique? That is, is could you reduce the number of parameters by reusing some?
If not, could update the parameters as...
August 15, 2017 at 4:24 pm
Can you post DDL and sample data for TRValue and TRProp?
We'll need more info in order to help. But best guess is that it isn't actually skipping it, it...
August 15, 2017 at 4:18 pm
I'm sure there are some free tools, but I recommend RedGate's SQL Compare for that task.
I used it when we were upgrading a system recently and found it...
August 15, 2017 at 11:12 am
My personal preference is to not fill the disk. Start the database out at a reasonable size.
Filling the disk means you may get a surprise one day when it...
August 14, 2017 at 4:41 pm
Viewing 15 posts - 2,341 through 2,355 (of 2,905 total)