Archives: November 2007
Traditionally, I will use
to get the source code and retrieve the column metadata of the result set, and then build a table based on the retrieve column information,…
EXEC sp_link_publication @publisher = 'Server1', @publication = 'PubUpdate1',@publisher_db = 'Pub_DB',@security_mode = 0,@login = 'sa',@password = 'sa_pwd'
on Server2, where the updatable subscribtion is…
So I create a quick VBScript to do this for me:
dim… Read more
As a DBA, most of us will also take care of test environment. However test servers usually cannot afford to be as powerful as the real production servers.
One of the issue I got in my test environment is I also need to do regular t-log backup for the testing… Read more