Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Evaluate Stored procedure parameter using case when else....
I always caution people against doing things like this in a stored procedure: @param1 is null You are trying to get SQL Server to base its execution plan on something that has noting to do with the database or data in it. This logic is better off in an IF statement than a WHERE clause. You...- ecobb
- Post #4
- Forum: Microsoft SQL Server: Programming
-
SQL Server 2016 Database Audit Specification
Looking at the MS Docs for that audit group, it says that this audit "Indicates that a principal successfully logged in to a contained database." I'm not sure if it's referring to a true Contained Database or not, but if it is that may be your problem (unless you actually are using a Contained...- ecobb
- Post #2
- Forum: Microsoft SQL Server: Setup and Administration
-
script users
Unfortunately SQL Server doesn't provide an easy way to do this. There are some third party software products that you can buy that handle this for you. I actually wound up writing my own code to do it. I put it out on GitHub if you're interested, feel free to use it...- ecobb
- Post #2
- Forum: Microsoft SQL Server: Setup and Administration
-
database connection errors on my site, hosting company is no help!
This was the #1 Result on Google when searching for "No buffer space available (maximum connections reached?)" http://kb2.adobe.com/cps/400/kb400700.html Hope This Helps! ECAR ECAR Technologies www.ecartech.com www.cfgears.com "My work is a game, a very serious game." - M.C. Escher -
CF8: Standard v. Enterprise
I think what your salesperson was referring to was the use of www.mycompanyhere.com, subdomain1.mycompany.com, etc. By "domain going down", he most likely meant that if your DNS record screws up for mycompany.com, then it shuts down all of your websites, whereas if they each had their own name... -
CF8: Standard v. Enterprise
He's right. I used to work at a hosting company that had over 100 sites running on CF Standard. Hope This Helps! ECAR ECAR Technologies www.ecartech.com "My work is a game, a very serious game." - M.C. Escher -
Arguments for Cold Fusion over PHP
Not that this is an actual answer to your question, but here's a list of the top 100 ColdFusion websites according to Alexa and Google. There are some pretty impressive names in there... http://www.coldfusiondeveloper.com.au/go/top100/ Hope This Helps! ECAR ECAR Technologies... -
format a number with leading zeroes
Check out NumberFormat() http://www.cfquickdocs.com/#NumberFormat Hope This Helps! ECAR ECAR Technologies www.ecartech.com "My work is a game, a very serious game." - M.C. Escher -
CF 8 Released this morning!
Woo-Hoo! CF 8 is out! And it is packed with new features! Actually, this release has more new features added to it than any other release in CF history. Here's a good article by Ben Forta that touches on just a few of the new features... -
Day of the week (Number)
DayOfWeek() returns the ordinal for the day of the week, as an integer in the range 1 (Sunday) to 7 (Saturday). http://livedocs.adobe.com/coldfusion/7/htmldocs/00000444.htm Hope This Helps! ECAR ECAR Technologies www.ecartech.com "My work is a game, a very serious game." - M.C. Escher -
ColdFusion Comics
These are good for a chuckle. Some of them are a tad vulgar, but it's all done in humor. I like the way they bash .Net and PHP, so that makes it worth it. [wink] Lenny And Bo, ColdFusion Programmers (Vol. 27) http://www.bennadel.com/blog/818-Lenny-And-Bo-ColdFusion-Programmers-Vol-25-.htm... -
Call SQL Server Job From CF
Not sure about calling a Job directly. You may can do it via cfobject, but I wouldn't think so (though I've never tried). I would suggest you ask the folks over at the SQL Server Forum (forum183) if there's a way to call a Job from a Stored Procedure. If so, just create the Procedure to call... -
Detecting URL Data
You'll need to use a CGI Environment Variable: http://livedocs.adobe.com/coldfusion/6/CFML_Reference/Expressions5.htm I know that cgi.query_string gives you everything after the "?" in a url, but I don't think that's what you need. Maybe cgi.script_name? Not sure... Anyway, all you have to... -
custom tag to show the right icon for a file extension
If you have the graphic you want displayed, you could easily do this with a few lines of code. Hope This Helps! ECAR ECAR Technologies www.ecartech.com "My work is a game, a very serious game." - M.C. Escher -
simple encrypt
CF has built in encryption and decryption functions. I use them all of the time when passing url vars. MX 7 has some new features in the encryption function, and it makes it a little trickier to use, but once you figure it out it's pretty easy... -
CFform validation not working in IE!
Did you by chance turn off JavaScript in IE? Hope This Helps! ECAR ECAR Technologies www.ecartech.com "My work is a game, a very serious game." - M.C. Escher -
Conditional jump from form
Did this thread not fix your problem? thread232-1379130 Hope This Helps! ECAR ECAR Technologies www.ecartech.com "My work is a game, a very serious game." - M.C. Escher -
session queries?
If the query results don't change much, just cache the queries. <cfquery name="" cachedwithin="whatever"> Hope This Helps! ECAR ECAR Technologies www.ecartech.com "My work is a game, a very serious game." - M.C. Escher -
Where is configuration info stored?
If all you need is the SQL Server database, and you have access to the hard drive it's on, then it should be just a matter of looking in the right directory. By default, SQL Server creates a database in 'C:\Program Files\Microsoft SQL Server\MSSQL\Data'. Unless you changed the directory when... -
Brainbench
At one company I worked at Brainbench certifications were considered a joke. Applicants resumes with Brainbench listed on them were laughed at and thrown in the trash, and those people were never even called for an interview. I never personally had any dealings with this, as it was all done by...- ecobb
- Post #4
- Forum: My own development as a professional
