— Here’s a little line of code I use a lot to find out what SQL stored procedures / functions use a particular table SELECT * FROM information_schema.routines WHERE routine_definition LIKE ‘%GetThemeColours%’ –&nnbsp;INFORMATION_SCHEMA.ROUTINES is similar to sys.routines but has all the text names instead of objectid’s with the added bonus the full stored procedure text is searchable (its in ROUTINE_DEFINITION column) – its like a super powered sp_helptext — Also check out these helpful views: — View all the columns in tables + views with full table/view name SELECT * FROM information_schema.columns — stored procedure / function parameters SELECT * FROM information_schema.parameters — output columns for table valued functions (NOT stored procedures) SELECT * FROM information_schema.routine_columns — list of tables SELECT * FROM information_schema.tables — list of views SELECT * FROM information_schema.tables — 195cac785d844883be7a61f2b54189c6
You are browsing archives for
Monitor Calibration for Better Colors
If you are a website designer or graphic artist, its important your monitor is calibrated to ensure the colors you are using will display and print the same for other people. Most monitors include an “auto-adjust” feature, but this isn’t enough. Most website designers and graphic designers will use special hardware that will calibrate a […]
Website Designers already on board for iPad compatable websites
Now that the iPad has been released and web designers know what iPad limitations there are, a number of websites are already underway with their iPad website redesigns. ABC has announced that they are going to create an iPad app / website design and Wired has a video preview of the site they are going to […]
iPad (TM) a no no?
With the release of the iPad, there’s been a lot of chatter about the iPad name, so it got me wondering – Who had the iPad name first? A search of the Internet Archive for ipad shows the earliest mention of "IPAD" was in an audio track and webpage from 2nd of April 1994 when […]
Will your website work with the Apple iPad ?
With all the hype that is surrounding the launch of the Apple iPad – the big question for website owners must be "Will my website work on the Apple iPad?". If the iPad gets the same massive uptake by Apple fans and the public – there could be a lot people surfing the web using […]
Business Catalyst – Bulk Opt-in of Contacts
Do you have an Adobe Business Catalyst website with a lot of customers you wish to Opt-In ? You can request Business Catalyst to set the master opt-in on your site, so all existing customers are "opt-in" to your marketing emails. [Forum thread here] Send a support ticket to Business Catalyst to have them turn […]
Adobe Business Catalyst Adds FTP Access to Customise Layouts
Following on from [story:business-catalyst-ftp-templates] – Business Catalyst now has access to all the custom layouts available via FTP. You can access the layouts in the /Layouts folder via FTP. You can now customise the layout via FTP for these modules: Affiliate Announcement Blog Booking Comments Customer Cases Customer Orders Faq Favourite Forum Literature Online Shop Outbound […]
Adobe Business Catalyst Adds FTP Access to Templates
There’s been many Business Catalyst customers looking to access their website templates via FTP. Up until now the only way to edit your website templates was the admin panel (Admin -> Templates) or using Triangle (the Adobe Dreamweaver plugin). As of today Business Catalyst has allowed access to edit and backup your templates via FTP. […]