I've been in this business for over 20 years - way back to the days of punch cards and paper tapes. We've always measured uptime as the availability of the system to our users. We always log ANY activity that prevents users from accessing the system, no matter what the cause. We even break this […]
2004-01-26
2 reads
Thanks for the tip. I'm getting close.I changed it to this and it was still returning Null even thought the record is in there. What I did was remove the ELSE statment and everything after and it worked. What am I missing that it still executes the second part of the statment?Thanks.CREATE PROCEDURE dbo.procAddContactAddress ( @Contact int, […]
2004-01-19
Hi there,How are new usernames actually checked? It might lead to irritations when you allowJonathan andjonathan
2004-01-19
3 reads
Invisible stored procedreHi Use the object search in your SQL Query Analyser and right click on the sp name ,press edit ,and do your modifications thereregards john
2004-01-11
Well, not that magical. Seems more exciting to say it is. Glad you like it. Hopefully everyone will be patient with us for a day or two while we sort things out. The old forums were truly horrible to maintain, classic ASP spaghetti code, no stored procs, etc.
2004-01-04
1 reads
Unlike SQL Server 7, SQL 2000 does not offer per-server licensing. SQL Server (2000) has 3 licensing modes. - Per Processor: Any number of clients/devices can connect WITHOUT the need for each client to have a CAL. Each CPU on the server would need to be licensed. - Server plus device CAL - Requires a […]
2003-12-13
1 reads
quote: http://www.scintilla.org/SciTE.html There are countless (free) editors around, such as http://www.jedit.org , which I prefer for linux development and.... For those of you who can't find an editor which can do everything you want, why not make your own one using this fantastic free control? I've tried this from VB and VC. Easy to use, […]
2003-07-09
Idea 1: add WITH RECOMPILE to the proc. Idea 2: turn the query into dynamic SQL using exec('...'), with the values of the parameters inserted into the query string.
2003-07-02
1 reads
I know that is why I used sp_addscriptexec. This is almost the same as re applying the snapshot, but much easier. I just add the new version of the sp, and it applies to all the subscribers. I also realized, that I can skip the error, re creating the directory and the fyle name. But […]
2003-07-01
Yes, Updates, deletes, selects etc. need to be performed at both sites! Is it still the best way? quote: Do you need to have all the changes made at the subscriber to be replicated to your publisher? With merge replication, you will have the same db in both servers, even when both are making changes […]
2003-07-01
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers