Thank you, but what I need is how Veritas SQL Agent do when backing up to disk. We do all you mentioned in your comment. Is just a matter of...

Quick question, what WUMS stand for? Is a generic name? I used this script in the past, but I stated the Log name.

Another quick one, can youo shrink your log...

Thanks, I set a different database for my replication test and the tables were created all right. Replication is working fine now. I just dropped the publication for the database...

So far what I have gather is that transactional replication (is the one I am using) needs the snapshot regardless of the option to create the publication and not run...

I got it runing fine again. Thank you I use the utility to restore Windows back in time. I did restore from Sunday night and everything is working fine now....

I will agree on the backup and restore. Is the easiest way and more secure. One thing you need to be aware, the users might not be migrated. there is...

Thank you guys! With your input I figured out the problem. I did create te folder as TestTempDB. When I created the query, I wrote TestTempDB.MDF and LDF!!! My father...

I appreciate all your assitance. The main problem at this time is that SQL Server does not start. So, I cannot see the master or anything to check the path....

Lisa try using sp_who2 which can give you more information on the activity and who can be blocking the process timing out. Could be the same, but maybe there is...

Steve,

I used a query you posted back in 2004 and it is exactly as the one I found in Microsoft/Support.

Maybe is a permissions issue, but I am the administrator of...

Thanks for your input. We decided to go with transactional from the beginning and avoid any issues using DTS

Sophie,

What type of replication are you setting up? Regardless of the PKs, Replciation adds that key which is used by the agent to identify which record to replicate after the...

Michael,

Are you going to import all tables from Access into your SQL Server database? or your imprt tables will reside in a different database?

In any event, go to the database...

Just an idea, what if you use syscolumns to set those column variables? Could this help?

Becasue at the time the declare statement is being created, you are right on...

Thanks, I will try that. Sorry for the top 100, I took the main statement and copy what I needed.  The order by goes in a different place and not...