Don't mind Bob. He's got brain freeze from standing outside the office door too long looking for the sun

I'm not sure there's less infrastructure required, but it's an argument being made by salesforce.com, SAAS, and others since they do some help desk stuff for their software.

I do agree...

Event Viewer also shows. Not sure of the entry, but you can filter on the service and check on the #.

Do you mean you created an SSIS package?

http://msdn2.microsoft.com/en-us/library/ms141701.aspx

http://p2p.wrox.com/topic.asp?TOPIC_ID=39302

No difference. They are the same thing. Scheduling inside the plan adds a job to the server. With SP2 you'll be able to add multiple schedules.

I would agree with Colin. Answering these in an interview and getting the job lets you and the employer down. Especially if you cannot even find the answers in Books...

Have you checked these:

http://support.microsoft.com/kb/891719

http://support.microsoft.com/kb/907649

http://groups.google.com/group/microsoft.public.sqlserver.server/browse_thread/thread/822f0a40f9205c78/3e0e36ae06c87637%233e0e36ae06c87637

Third vote for app roles. Andy Warren has written about them and this is why he doesn't like Windows auth for anything other than login. Prefers to have them connect...

Brian,

Glad it's working, but can you tell us the ini file? Someone might run into this again and it would be nice if they saw your solution.

Thanks

No automatic way. I guess partitioned tables could work, but it's up to you.

One thing that might make sense is creating another database, duplicate the table and then copy the...

While it's a bad practice and could prevent you from selling the product in some cases, especially where Sarbanes Oxley is being taken seriously, you're right. Ultimately it's a management...

That seems like a bug if it's fragmentation related. I'd spend the $$ for a call to PSS and have them diagnose it. They're good and the money is refunded...

I believe you just "install" SQL 2000 and get the option to upgrade the existing version. I know if your OS support Enterprise, the products allow upgrades and installation of...

Great comments and some interesting points I hadn't thought of.

One thing I do like is giving employees a VM for their stuff if they need it. They could work at...

How are they running? If through SQL Agent, does that service account have permissions to do this?