Viewing 15 posts - 16 through 30 (of 52 total)
Mister Magoo...your solution worked for my simple select statement..thank you !
..BUT, when I add a case statement to the select statement, it stops working...any idea why ?
or any other solutions...
April 20, 2010 at 11:31 am
..thank you for the tip..I've done an exhaustive search on the Internet for this type of script, but have not found an example...I would think that this type of script...
March 29, 2010 at 12:18 pm
No, thats the big mystery...Im not running it from my PC....I have remote desktopped into the SQL Server, build my SSIS package there...run it successfully within SSIS on the server,...
April 8, 2009 at 2:02 pm
Regarding 2005 components, I have Analysis, Integration, Notification, and workstation....so Im missing the database engine, right ?
It would be crazy to think that all was installed except the database engine,...
October 28, 2008 at 12:16 pm
GilaMonster,
I went to Add/Remove Progs. and saw that SQL Server 2005 (and 2000) was installed.
Lynn, I have a 2000 standard environment, so that is not the issue.
Maybe I did not...
October 28, 2008 at 11:51 am
Steve,
How can I choose, NOT to upgrade ?...I have 2000 as my default instance, then run the 2005 standard install...it SHOULD automatically upgrade my 2000 default environment, should it not...
October 28, 2008 at 10:35 am
Sorry if I was unclear, forget about the my 90 compatibility sentence. I know what you mean about changing that, once the upgrade is complete.
No my problem is that my...
October 28, 2008 at 10:21 am
Excellent short, to the point, answer my question response Wilfred....thank you
September 5, 2008 at 9:22 am
thanks Adam...about SP2...do I need to be concerned with that for users that only have 2005 Client tools (not database) on their machines ?
September 4, 2008 at 2:12 pm
Thank you...we have the SQL 2005 DVD contents on the network, and I hate to copy the whole thing to a users desktop, only to install Management studio...is there some...
September 3, 2008 at 1:42 pm
Please see my reply posted at 8:47 pm...that solution works one time, but the next time I use the Access database, I get the same prompt.
To recap the question: how...
July 22, 2008 at 3:29 pm
Sorry, I dont have that option of 'connection' under File.
BTW, Im using Access 2003
July 22, 2008 at 2:22 pm
How do i use a trusted connection ?
Because when the SQL Server login prompt pops up, I check 'trusted connection' and Im able to run my query...but the next time...
July 22, 2008 at 1:47 pm
Look for me at the next PASS conference, as primary speaker on 'icons'
😉
May 9, 2008 at 9:10 am
Thank you.
Do you know if there is some sort of explanation for other graphic icons in SQL Server 2005....I would think somewhere in BOL, but havent found anything yet
May 9, 2008 at 8:54 am
Viewing 15 posts - 16 through 30 (of 52 total)