|
Misc. Scripts |
| Generate Inserts From Table Data |
Table Rowcounts from Sysindexes
|
| sp_who_3 |
DTS Function to Retrieve Web Pages
|
| Search all columns for String |
Manually
Configure Logshipping
(Enterprise Edition not Needed) |
| Create CSV list from Table |
Example of Set Base Loop |
Dynamic SQL Pitfalls and
Workarounds |
XP_SMTP DLL
|
Reading
SQL Execution Plans |
The following Microsoft document talks about common log-shipping questions in
SQL Server. The point that I find most interesting about this document is the
requirement of Enterprise Edition or Developers Edition. This is a common
mis-conception. To AUTOMATICALLY configure logshipping through enterprise
manager, this is a requirement. HOWEVER, logshipping can be manually configured
on 7.0/2000. In fact, I find you have more control over logshipping if you do
it manually.
This is the Microsoft article
Logshipping MS
This is how you can manually configure logshipping
Manually Configure
|
|
MSDE/SQL Management Tools
|
Toad |
SQuirreL |
| My Little Admin |
MSDE.BIZ tools |
| Microsoft
Webdata Admin |
SQL Server WaitTypes |
WaitType List |
