Activity overview
Latest activity by dbaman6
Still no luck with any of the three options.
One thing I noticed though, the computer I am trying to connect to is part of a workgroup. In my enterprise manager, when I try to register a server, the database server I am trying to connect to shows up. In SQL Multi Script, the db server does not show up. Only the database servers in my domain show up in the selection list. Why wouldn't any database servers in the workgroup WORKGROUP show up in the selection list? / comments
Still no luck with any of the three options.
One thing I noticed though, the computer I am trying to connect to is part of a workgroup. In my enterprise manager, when I try to register a server, t...
problems registering servers using sql authentication
We use sql authentication with sql 2000 databases. I can remote desktop to a server using either the name or IP address to find a server. I can also use query analyzer with either the servername ...
single table compare from command line
I am having trouble comparing 1 single table from the command lineSQLCompare.exe /verbose /server1:HENRY /server2:HENRY
/username1:XX /username2:XX /database1:D11 /database2:RETAILDEV
/include:...
Different schemas - Compare aborts on first duplicate table
I have a database with 16,000 tables with 15,000 owned by dbo and 1,000 owned by an individual. 2 things:
1) Tablenames are identical between the two, only the owner differs.
2) SQL compare aborts...