Viewing 15 posts - 24,571 through 24,585 (of 26,486 total)
Read about jobs in BOL. Yes, you want to run a job. A trigger needs to be quick. If you start a job using msdb.dbo.sp_start_job, it returns...
June 23, 2008 at 9:00 pm
Yes, the FTP server was (is) configured to log all activity to a SQL Server database. It logs everything. You would have to set a trigger to check...
June 23, 2008 at 8:38 pm
They have the experience, that isn't the issue. The issue is having the time to vet all the questions along with everything else they have to do to keep...
June 23, 2008 at 7:30 pm
Okay. I know the FTP is part of IIS. What I was asking is this setup on the Database Server or on a seperate dedicated FTP server, using...
June 23, 2008 at 7:27 pm
lreid (6/23/2008)
I have the following requirements. A client is to send a file via ftp to a directory on my server (same box as my database).
I need to import...
June 23, 2008 at 6:14 pm
Okay. We have only just begun (isn't that a song?) so I can't really help you there. It is certainly something we will need to look at as...
June 23, 2008 at 6:11 pm
max.morte (6/23/2008)
does anyone know why this case statement is not working, i keep getting an error
Server: Msg 156, Level 15, State 1, Line 3
Incorrect syntax near the keyword 'CASE'.
Declare...
June 23, 2008 at 5:19 pm
We have WSS setup in two seperate development environments where I work. Apparently, we also of a development server with MOSS 2007, but I haven't seen it nor do...
June 23, 2008 at 5:15 pm
Answer me this, what is the current recovery model of the Production Database? If it is full recovery, you will need some kind of log reading software to read...
June 23, 2008 at 5:13 pm
What I think was meant by that was in the select list: EmpName, DateOfLeaving. If you were to have more than 2 columns, you'd want the DateOfLeaving listed last....
June 23, 2008 at 4:23 pm
noeld (6/23/2008)
...
from pilot.dbo.CUSTOMERS
inner join pilot.dbo.COMPDATA on ( pilot.dbo.COMPDATA.COMP = - ( @P43 ) )
inner join pilot.dbo.CUSTTOPICS on ( pilot.dbo.CUSTTOPICS.TOPIC = - ( @P44 ) )...
June 23, 2008 at 4:18 pm
I'm not sure if there is much more that could be done to improve your query. As I was trying to reformat it into a more readable form I...
June 23, 2008 at 4:15 pm
And, if memory serves, this same topic has come up in other threads about "bad questions" and the reply I vaguely remember from Steve Jones was that there used to...
June 23, 2008 at 3:48 pm
A) The author has admitted the mistake and that option 2 is the only correct option.
B) I think enough people have hammered this point on this thread, and it would...
June 23, 2008 at 3:07 pm
HyperBac (from HyperBac) is $699 USD per server.
😎
June 20, 2008 at 11:20 am
Viewing 15 posts - 24,571 through 24,585 (of 26,486 total)