Viewing 15 posts - 2,086 through 2,100 (of 6,486 total)
In addition to Steve's article on how to handle VSS integration - you can script the objects using SQL Server 2005's "Generate Scripts" option. If you look at the...
January 2, 2009 at 11:19 am
One of the regular posters on here did a presentation on a series of things that might be possible issues for that. His name is RbarryYoung.
His presentation is located...
January 2, 2009 at 10:57 am
Oh - I didn't understand your question under that light at all.
It's customary everywhere I've worked to maintain a single project per database, and to tag work items to specific...
January 2, 2009 at 10:40 am
Just like using source control elsewhere, if you modify the code outside of source control - there's not going to be any tie-in/history in the Source Control system. That's...
January 2, 2009 at 10:11 am
I didn't have nearly as many cell phone woes as you this year. Now - if you throw in BlueTooth headsets into the mix, now THAT's a different story...:)...
January 2, 2009 at 9:19 am
If you enable the identity property - why not just use DBCC CHECKIDENT to set the next value? That's the right way to do that, AND it's the supported...
January 2, 2009 at 9:03 am
GilaMonster (1/1/2009)
RBarryYoung (12/31/2008)
The irony of course is that if SUM(..) OVER(..) allowed ORDER BY, 2/3rds of the uses for it (the Update pseudo-cursor) would disappear.
Apparently (and this is not confirmed),...
January 2, 2009 at 8:52 am
Jeff Moden (12/31/2008)
RBarryYoung (12/31/2008)
The irony of course is that if SUM(..) OVER(..) allowed ORDER BY, 2/3rds of the uses for it (the Update pseudo-cursor) would disappear.
Heh... how very true... and...
January 2, 2009 at 8:48 am
Well the script looks reasonable to 2000, except that I don't have a clue what it is you're doing to Autoval. can't say I have had to play with...
December 31, 2008 at 1:12 pm
Are you in 2000 or 2005? You just asked the same question in the other forum.
What's important is the version # of your database engine. Whether you happen to...
December 31, 2008 at 12:54 pm
Bob Hovious (12/31/2008)
While you are doing your homework on FOR XML, be sure to look up nested queries in conjunction with PATH....
December 31, 2008 at 12:51 pm
Go simpler. I think you're giving it too much info (and specifying it in multiple places) so it's getting confused.
Set up the actual ODBC connection with everything needed, then...
December 31, 2008 at 12:48 pm
Aspet Golestanian Namagerdi (12/31/2008)
December 31, 2008 at 12:37 pm
Then you're back to writing a VB or VB.NET or script component that opens the Access application, and runs the queries from there. There's no way to execute those...
December 31, 2008 at 12:21 pm
Ninja's_RGR'us (12/2/2008)
Is this a valid option : create an ssis package that...
December 31, 2008 at 12:06 pm
Viewing 15 posts - 2,086 through 2,100 (of 6,486 total)