Viewing 15 posts - 1,456 through 1,470 (of 7,429 total)
You know if you really want to know what I look like all you have to do is ask and I am more than happy to send to a coupla...
December 9, 2004 at 12:13 pm
Another way would be this and I only suggest it from a readability standpoint.
Also like Suresh I reversed the GetDate() and DUeDate in datediff from Remi's example.
The reason is you...
December 9, 2004 at 11:59 am
Sorry no. Unless the person is the dbo of the database not just marked as db_owner in the db it will use their username as the owner. This is assuming...
December 9, 2004 at 11:46 am
Could you post the entire query and is this in a stored procedure?
I assume you are trying to combine 2 queries based on the condition of @ID.
INNER JOIN dbo.Table_2 T2...
December 9, 2004 at 7:05 am
Ok going back to your first post you stated was dropped with 'Connection closed by remote host.'. If your FTP team logs there connections like they should be then see...
December 8, 2004 at 5:53 pm
When you log into the FTP server do a test thru command prompt are you using the same account as defined in the ftp connection of your scheduled process?
December 8, 2004 at 10:12 am
In your case as you are using a variable and not a col in a table you would not use the WHERE clause. The previous poster stated it was a...
December 8, 2004 at 8:03 am
Sounds like the FTP is setup to only except connecions from the address of the working node. And any other location that attempts to connect is automatically rejected. Check with...
December 8, 2004 at 7:56 am
Darn timeout got me again when I typing a long relavent statement.
Two questions still need to be answered with this and can be handled thru auditing.
1) What is the state...
December 7, 2004 at 5:07 pm
First off you have to consider the complexity of the transaction taking place versus the value they are trying to show. Sure I can put a record for a call...
December 7, 2004 at 4:55 pm
Hmmmm.
Me in the 70's I guess you would have to say I am about 250 pounds heavier, much taller, and a h@!! of a lot more hair. But wait I...
December 7, 2004 at 4:46 pm
Just doing the audit will suffice thou I do believe. Because you condition should be ON UPDATE for the table. Then you can compare changes over a period of time...
December 7, 2004 at 4:34 pm
The problem with IF UPDATE is that it cannot determine if the value actually changed only that the value was explicitly set.
Ex.
TableX
Col1
Col2
Col1 Col2
---- ----
A B
If I do and update with...
December 7, 2004 at 4:14 pm
Viewing 15 posts - 1,456 through 1,470 (of 7,429 total)