I guess I should just stick to Admin work eh, It took a little bit, but I figure it out yesterday. BOL doesn't exactly give you those type of examples. Thanks Paul and mlwang for your examples. cheers John Zacharkan
2003-06-11
Thanks folks, I bet you're glad everyone's not as stupid as me 🙂 cheers, yogi
2003-06-06
1 reads
2003-06-04
1 reads
As a developer, I was pretty exicted with the version of SQL Server that allowed me to create an 8000 byte field instead of using a text field. Little did I know that I could only have one 8000 byte field per table. Maybe your developers aren't aware of the 8060 record limit. Educate them! […]
2003-06-03
1 reads
Have you consider using log shipping instead of transactional replication?
2003-06-03
Hi amelvin, quote: Perhaps the site owners could make a feature of favourite books, when I'm buying from Amazon (or almost anywhere online) I always check out reviews and pick out the most recommended things. Perhaps a place like this could develop such a facility rather than a simple, occasional review. take a look at […]
2003-06-03
Ok, I am new to SQL Server and DBs and I tried the following INSERT INTO db2..mytext (Spanish) SELECT Spanish FROM db1..mytext However, I get the following error message: Cannot insert the value NULL into column 'ID', table 'db2.dbo.mytext'; column does not allow nulls. INSERT fails. The statement has been terminated. ID is the primary […]
2003-06-02
Hi Rolf, after reading what php fopen() does, I think the FileSystemObject might be equivalent to it. I'm not sure if this will work on a remote site, but you can use an ActiveX Script Task with this script. I've found this in MSDN '********************************************************************** ' Visual Basic ActiveX Script '************************************************************************ Function Main() Const ForReading […]
2003-06-02
quote: What are you trying to work around? If you post the Jet code, we can translate it to T-SQL... It's alright, I've tried using Min & Max and it all appears to work fine. Thanks fellas.
2003-05-29
Usually it is to add an extra layer of security. However, if you are using in SPs then I would write the code directly to the SP as there is less of a chance changes in the table can cause issues with the SP that way. A view remembers items ordinal position and if you […]
2003-05-27
1 reads
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