I have the following stored procedure. It extracts information from 2 tables, based on a provided date for a specified number of days. It then does some simple calculations and inserts the result into a memory table. The memory table is returned. When I call this from Enterprise Manager or the Query Analyzer it returns […]
2004-02-06
Steve,i don't have any timestamp...But if i use triggers, the thing is that these two table are in two different serverers physically located in different palce over an intranetI am trying with replication....
2004-01-23
For 6.5 run regedit - Go to HKEY_CURRENT_USER/Software/microsoft/MSSQLserver/SQLEW/Registered servers and then double click on the required one.THe SA will be on the right of the screen vertically.Don't tell anyone this came from me - And I never use it because I never, ever forget my SA password as they are stuck on my screen with […]
2004-01-16
8 reads
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-12-02
quote: Wrox went out of business in March. http://weblogs.asp.net/AKrowczyk/posts/3871.aspx J. Moseley Oops, I spoke too soon. Looks like Wiley Publishing picked them up. Found it for you at isbn.nu http://isbn.nu/0764543687 J. Moseley
2003-06-27
For some odd reason it seems the Wrox "SQL Server 2000 DTS" book is no longer available. I was looking for it a couple of weeks ago and couldn't find it new anywhere obvious, like amazon or barnesandnoble. Why would Wrox discontinue this book? Their website doesn't say anything about it. If you can find […]
2003-06-27
I agree with Shas3 -- sqldts.com is an excellent site. You might also want to look at the following article... http://www.asp101.com/articles/carvin/dts/default.asp Also, SQLServerCentral.com (this site) is the best resource. I've always gotten an answer here.
2003-06-27
2003-06-26
Are you ready to take your SQL skills from theoretical to tactical? If you've...
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
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