Yep, this would be my issue. Well, sort of. I looked in master and I don't see the tables there, either. But, I added a "using thedatabaseIreallywanted;" clause at the top of the script and voila, that worked. *sigh*
It's the stupid stuff that no one tells you because they just think you should KNOW because it's so obvious that really gets you when you're learning something new. I beat my head against a wall for DAYS trying to figure out how to get the public key token to reference a strongly named dll before realizing that when you put it in the GAC it shows you the token RIGHT THERE. Argh. I will persist. I will persist. (Actually, despite all the frustration, learning new stuff is LOADS of fun, too.) -d On 7/30/07, Jim Davis wrote: > > -----Original Message----- > > From: Deanna Schneider > > Sent: Monday, July 30, 2007 2:28 PM > > To: CF-Community > > Subject: Stupid sql server question > > > > So, I have a sql script that creates some tables. I'm using sql server > > management studio express. How do I run the darn sql script? > > > > I tried clicking the database engine query icon, opening the file and > > doing an execute, but it's not actually creating the tables, even > > though it says it ran. WTF? > > Are you sure that you're in the right database when you run this? The > default is "Master" - I suspect that you've got some extra tables in there > now... > > Jim Davis > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:239291 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
