Viewing 15 posts - 24,571 through 24,585 (of 26,490 total)
It could be less. If you are looking at the size of the mdf/ldf's, then you are seeing how much physical space the files are taking on the OS....
June 23, 2008 at 10:30 pm
TheSQLGuru (6/19/2008)
June 23, 2008 at 10:28 pm
You are almost there. Just need some sample data (in the form of insert statements so we can cut, paste, and execute), and what the expected output would be...
June 23, 2008 at 10:10 pm
Not sure. I never had a reason to log HTTP (Web requests). You'll have to research that one on your own.
😎
June 23, 2008 at 9:45 pm
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
Viewing 15 posts - 24,571 through 24,585 (of 26,490 total)