We have ours logged in with the same domain account as SQL Server & the agent.

John

I created a user DSN.  Here are the steps I followed to create the DSN:

1.  Open up ODBC Data Source Administrator and click on Add.

2.  Scroll down to the Microsoft...

We just went through this same thing.  When you set up your VFP DSN, you need to select the option of Database Type: Free table directory.  Also make sure you...

Thanks for all the good info guys.  So the main reason not to scan the data files is because of data corruption?  How does it corrupt the files?

Thanks,

John

Thanks for all of the suggestions.  I already had used the datepart(week,@date) to get the calendar week but I also wanted the week in month. 

Thank you for the responses.  You have confirmed what we were thinking.  The server is physically secure so I don't think we will use the encryption.  We are going to...

I do not currently have a return statement in my SP. I am just raising an error. I will try putting in a return statement to see if it...

Sorry, I didn't mean to hit the submit button again. Can an administrator delete this extra post?

Thanks,

John

I figured out how to do this. I ended up creating a stored procedure with an input parameter and called it within the DTS. I said exec proc...

Can anyone verify whether the following is correct:

Full backups are restored completely. So you can restore your 10/8/2003 full backup which will restore EVERYTHING up to 2:23AM. Then you...

Thanks for the info. Whenever I try to run the xp_eventlog sp, I get the following error:

Server: Msg 22005, Level 15, State 1, Line 0

Error executing extended...

I came across a sp named sp_eventlog. It is undocumented. It may be what I am looking for but I can't find what parameters I need to pass...

Ok, here is some more info. I reran the installation and it goes through all 17 of the scripts. It then brings up a window saying setup is...

No, I have not tried that. I have never done that before. Do you have any instructions on how I would do that?

It sounds like there could possibly be a lot of disk contention occurring. We just set up our new data warehouse server with Raid 0+1 (mirrored then striped) instead...