Thanks, Gail.

Question: with Transactional Replication, the Users are able to access the Reporting Database continuously?

Thanks so much for that information, Gail!

This is all new to me, so I appreciate the help!

I shall try to write scripts to copy over the LOGS, DISCONNECT ALL...

"up to date" meaning that when the Primary Server does a Transaction Log backup every 15 minutes, then that LOG Backup should then be applied to the Report Server at...

Log Shipping is not an option due to internal management issues.

The Primary database is backed up every 15 minutes. I was hoping I could script a job to copy that...

Thanks for your replies, Gail and David.

SQL log shipping is not an option available to me. So I have to do this myself.

Yes, this will be a Reporting Server.

So for...

Thanks, Roy.

Thanks, Steve & Steve. I'm looking into Log Shipping and Database Mirroring now.

The database I'm supporting is a VENDOR Package database. I can not touch it (e.g., adding keys).

But there's a request to get a real-time copy of the database onto...

Thanks for the reply, jbuchan.

You hand me scared for a minute! :unsure:

Now all I have to do is figure out how to setup replication. 😀

Incorrect syntax near '?'.

Would it be possible to get a revised script posted with the errors above?

...thanks

Ok. Thanks for that information. Back to square one.

I found this:

http://www.sqlservercentral.com/Forums/Topic641210-359-1.aspx?Highlight=last+login

I know the User is a valid Domain User. I just need to know the last time they've accessed the SQL Server. I'd like to clean...

Fair enough. Thanks for your reply, Seth.

I was hoping to kill two birds with one stone. 🙂

Steve, you are awesome. I guess I'm making this too hard. 😀

thanks again!

The DOS command simply puts ONE filename into a DOS Variable.

Like I said, I'm very new to SSIS. When I learn further maybe I can combine the 2 processes.