Posts
Sort by recent activity
Local variable bug
on the sql below, try replacing the @... variable with another local variable. sql prompt does not show the local variables. however if you go to another location on the sql (probable outside of th...
new feature suggestion
on ants 4 please add the ability to view the MS .NET framework code when profiling. so when i click on a method that is part of the framework i will see the code. i know there is an option to debug...
new feature suggestion
on Ants profiler 4, on the event line (above the performance graphs), if an exception occurs in code a red line appears. my suggestion: allow me to click the red line and show me the code that thre...
new features suggestion
after comparing tables i need to insert about 400000 records to a table on a db i access on a remote server on a VPN. since the traffic out of our office is slow i have been looking on ways to impr...
Prompt bug
try typing this
declare @xx int,@yy int
if @xx<>@yy
on the if line, the @xx shows the list of vars whereas the @yy can not be auto completed.
New feature idea
from time to time i come across the need to compare my Dev DB to a DB on a production server i have very little access to. in some cases the Production server DB is huge and taking a backup to the ...
Create Snapshot utility
one some cases i need to sync a DB on development with a DB on my customers lan. since our networks are not connected the customer needs to create a backup (or i do it remotely) and restore that ba...
Auto Saving Sync Script
i think that SQL Compare should not auto save the sync script if the sync faild. i try running a sync from sql 2005 to sql 2000 and some times it fails because of competability problems. when that ...
INIT Option
I saw in the SQLBackup help file of V4 that the backup command has a INIT parameter but there is not explanation on what it does. can anyone please explain?
sqlbackupc.exe crashes
platform: windows 2003 server SP1 & all patches available
SQL 2000 standard SP3
i have a SQL agent job for backing up some DB's to another machine on the network the job is based on your sample on ...