They do work. They even work in the case where SP3 doesn't go on, such as with some MSDE installs. 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-07-15
1 reads
Have you considered working this out from your webserver logs? If your webserver is IIS, I seem to remember its just a few clicks to import your webserver logs straight into SQL Server. Write a few queries and off you go ...
2003-07-14
Hi Jigman, quote: Sorry, me again. I just did a quick error test by adding. if not rsADO.EOF then Response.Write rsADO("test") ' Response.Write rsADO("FieldName2") else Response.Write("EOF") and it now displays EOF to the page. I know this means that its the end of file but can someone please help me as to why it wouldnt […]
2003-07-13
1 reads
Hi shas3, Thanks for ur prompt reply.It was spot on. The db giving problems had 251 entries in sysindexes while other one had 7 for that table !! In my case i dropped and recreated the table. But in case that isnt possible i was wondering what could be the easiest way to put the […]
2003-07-10
quote: I think you've missed the point. There's a "feature" in ADO that struggles with text type. I did not mis the point of the question. But I think you've missed mine. My point is that you're application should not depend on the order of the columns of the table. You should never use select […]
2003-07-09
1 reads
Now that this thread has degenerated into My Own Evangelizing Space, I'd like to add SciTE to the mix. A free editor, very fast to load, and nice to configure. http://www.scintilla.org/SciTE.html Have a greater day, pals.
2003-07-09
If the SP works correctly when calling it from Query Analyzer, the reason that you don't get data back to ASP probably is that the SP also returns status info. Try adding SET NoCount ON in the top of the SP, and see if that helps. Hope this helps. Good luck!
2003-07-09
Thanks Guarddata. I'll fire up QA and see what type of results I can come up with.
2003-07-08
No, the only transfer that is made daily is performed by bcp against several tables, which doesn´t have any relation with the tables with missing keys
2003-07-08
You are cross posting - the site owners get cross about that kind of thang. This is one way to create break totals and running totals without cursors or temp tables. set nocount on create table #running (keyval int identity(1,1) not null , breakval int not null , runval int not null) insert into #running […]
2003-07-08
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