If you have added entire table to the replication and your DDL replication is set to on(which is by default), it will be added to subscriber...
Service side traces are the best for this.
You can do this in , Registered Server option in SSMS
No and cannot be.
Any reason for asking
you can use apex debug
In SQL Server 2008, you have a feature called, Management Data Warehjouse from which you can collecte data for database growth. From that you can...
You can implemen Transactional Replication and where have to stop the replication when you are doing the data load.
You might have change recovery model to simple from full. In that case, log size will not truncate.
But, in a production server, your recovery model...
sounds like the data volume issue. Check whether you are having correct indexes
it depends on the fequency of the backup job. if you are having backing up job for say for every 15 mins it is better disable it and enable another...
You won't be able to access Table B data from Trigger in Table A. Why you can't wrie two triggers to two tables.
Did you install SP4
For your information, Microsoft has stoped support for SQL Server 2000
1. File path
3. System Date
4. More imporatntanly, permission on the drive for sql server agent.
I think 1=1 will be ignored by the query engine.
If you want to have a table structure of HumanResources.Employee table into a new table (NewTable)...
Use Maintenance Cleanup Task in Maintainance Plan
I have partially written two articles,
1. Copy Only Database Backup
2. Data Analysing with Excel (Too large , I might break this to two articles)...
Separate names with a comma.