2003-04-28
2 reads
security
RE: EXCEPTION_ACCESS_VIOLATION
A follow-up: the CASE statement does not cause any errors when there is only 1 when clause: <cfif parameterexists(form.ziplist)> CASE len(OrganizationPostalCode) WHEN 6 THEN left(OrganizationPostalCode,3) ELSE left(OrganizationPostalCode,5) END IN (#preservesinglequotes(form.ziplist)#) AND </cfif> When I add in the second WHEN clause with the long list is when it crashes. <cfif parameterexists(form.ziplist)> CASE len(OrganizationPostalCode) WHEN 6 THEN […]
2003-04-28
1 reads
RE: "with sample xxx percent" is your friend ...
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-04-28
RE: sql server access internet
If you're still listening on the standard port (TCP 1433), this article should be all you need. Otherwise, modify the port # based on what you are using: http://support.microsoft.com/default.aspx?scid=kb;en-us;287932 K. Brian Kelley http://www.truthsolutions.com/ Author: Start to Finish Guide to SQL Server Performance Monitoring http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
2003-04-27
RE: View Taskpad Error in Enterprise Manager
Well it is nice to know that I am not the only one with this issue. Thanks for the advice. I will just live with it for now by clicking on another view and them back to the taskpad.
2003-04-26
1 reads
RE: How to manage data updated in different time zones
I'll experiment with it in the next few days. Thanks for the comments. Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-04-25
1 reads
RE: DTS Package to Change Object Owner for Excel Impor
You can use a command line to run a DTS package. The best way that I have found to run a DTS package on an as needed basis is to create a job to run it (i.e. right click on the package, schedule) and then leave the job disabled so that the job does not […]
2003-04-25
1 reads
RE: Error 266 after executing SP
Note that COMMIT statement will not execute if there is no data in @TableToBeCleaned satisfying the where clause. Change the fourth line as SET @STR = @STR + 'COMMIT ' + 'IF @@ROWCOUNT = 0 ' + 'BREAK ' + 'END ' + 'SET ROWCOUNT 0'
2003-04-25
1 reads
RE: how would You determine the fields in a PK?
now that's some good crap there. I forgot that you can spy on SQL Server to see how it does those sp_'s Thanks Antares.
2003-04-24
RE: View Taskpad Error in Enterprise Manager
No idea why this happens. But to resolve this, Click on view and choose anything but taskpad(e.g. icons etc.) and then change it back to taskpad. Will work fine.
2003-04-24
1 reads
Blogs
Simple Talks Episode 7
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
A New Word: the McFly effect
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
Key mappings in Visual Studio Code
At a recent conference I was asked how I executed code during my presentation....
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers