Thanks a lot, Satya.
Folks, I am wanting to know what permissions I should grant to my DTS developers in order to let them have all DTS/SSIS related permissions, also can...
I know in sql 2000, in order to grant 'Execute' permission on all sps, functions and etc to a DB role, we have to first create a cursor, and run the...
I am trying to automate the script calling, and may need to handle lots of SQL script layout. I just want to figure out the possible options my...
Yes, enabling SQLCMD scripting, this works. any other options? thanks.
Can someone provide me some idea on how to call the sql script files, I organized my scripts into smaller SQL files instead of putting everything in...
A stored procedure can be published only as a 'serializable proc exec' article, a 'proc exec' article, or a 'proc schema only' article. Can someone...
They are all related issues. During the DBCC DBReindex on the publishing DB, too much logging, and log size getting huge, 150GB. Backup log job is...
I just want to dig into this, DBReindex was create a new one, and then drop that old one, the whole process is atomic. Now it comes to create index:...
Gurus, just want to know what kind of locks was used on log file when backing up the T-log.. What kind of overhead generated for DB system when...
Just curious, where are SSIS / DTS packages are stored?
Will DBReindex process put locks on transactional log, I had problem when re-indexing publishing DB, the log reader agent connecting from dedicated...
Welcome back, I am really glad to see you here again.
Guys, please recommend me several good sites for SMO, RMO and WMI programming, thanks.
Why T-Log grows that large during DBCC DBReindex. What kind of activities are logged in the T-Log during the Reindex. thanks.
Satya, are there some definitive words from Microsoft regarding this error message OR KB, write paper on troubleshooting log reader agent... we know...
It is Microsoft SMS (systems management server), we used a 8 procs, 4GB RAM server as central publisher...dedicated distributor...SQL 2K EE with SP4...
Log shipping was set up between 2 SQL Serve 2K EE with SP4 on windows 2K3 servers...We utilized the maintenance plan to setup the log shipping....
I did a migration through backup - restore to new SQL Server 2005 SP2 server.... Customer complained the poor performance after the migration......
Thanks for your reply... Do I need to manually stop the LogReader Agent, and distribution Agent before shuting down the distributor? And restart the...
Separate names with a comma.
