RE: Forum Bug
I find that if I get the blank after submit that if I hit the back button and then submit it will work. I'm using Opera.Note that I at least copy it to the clipboard just in case. I've been burned on it too.
2005-03-17
Metadata
Really weird problem
Hi, i just notice that my query have a problem, I mean, I join tables into a temp tables, then i work with those temp tables and I join it again. Then in that join (inner) I do a count and the results are not right, I mean, in the result set appears values that […]
2005-02-02
RE: MySQL vs SQL server comparison
I like the idea of MySQL. I think PostgreSQL is a better product, more mature, but advances occur rapidly in both products, so that might not be the case. I haven't looked at MySQL in a few years and at that time it was a capable db for many needs, but lacked a few things […]
2005-01-02
RE: Logins
Hi,I had same problem about orphaned users, i just ran update query on the sysusers table for all the databases for orphaned users to update their sid to correct one, but it's not advisable to update system table directly until you know about it. so it is preferred to use sp_change_users_login. One problem i am […]
2004-12-15
RE: Trouble with Subscriptions
I posted my message a little too soon. I did a little more browsing through the forum and found that Reg Mayfield posted on 8-4-2004 a problem similar to mine. Reg Mayfield also discovered the proper FIX from microsoft for this problem. Thanks for the information.
2004-12-02
Sending mails using DTS
I have created a send mail task. It executes successfully. But how can configure the package such that it send a mail once the excution of the package is completed? Thanks & Regards,Vidya
2004-11-19
RE: error creating text file with dynamic properties in DTS pkg
I've had this and did not find a straightforward solution, so in the end I worked round it. But, as an alternative to having a dynamic filename, you might think about output to a fixed filename and then chaining to another task (VB script?) that does a file rename to whatever you want. Phil
2004-11-08
Article for adding a second SQL virtual server to an existing cluster?
I'm looking for some sound procedures on adding a new SQL virtual server to a two node cluster that already a SQL virtual server. I've been playing around with cluster manager, but it seems that I keep dead-ending on getting the new instance of SQL built. Do I have to re-run setup from the install […]
2004-11-08
RE: Security problem between SQL Server 2000 and Access XP
Hi Mr Mitchell, I tried what you have told me but I got the following error: "Invalid operation." on ".RefreshLink". However, I added to my code the following: .Attributes = dbAttachSavePWDit becomes like this: With tblLoc .Connect = sConnect .SourceTableName = sTable .Attributes = dbAttachSavePWD End WithIt worked the security […]
2004-10-29
RE: Stack Overflow ... Help!
hmm.. somehow I keep loosing posting..Anyway, that error usually comes from either database corruption or SQL bug. To confirm it, try the "DBCC CHECKDB" and make sure you have the latest sql server service pack (and I'd recommend to have latest windows service pack) If you have both latest service pack and don't see any […]
2004-09-28
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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