Yes, the DBA/DB development market in NYC is tough, and majority of openings are consulting/contractors/temp. But the good news is that pay is usually higher than in most of other...

1. sys.databases

2,3. msdb..backupset

4. fileproperty(name, 'spaceused')/128 from sys.database_files -- MB

That's funny, I never knew about such trick, thanks Lowell. But why Microsoft allows to change them at all? It can be really misleading.

the host is from where you are running this sp_who2. You can find it by select @@servernamee

Publisher database (I guess you call it General) must be in full recovery model, so txn log will always grow until you will back it up.

Subscriber database must be in...

You should have created attach script BEFORE detaching databases. If you still have backup of master database, restore it somewhere under different name, and create "ATTACH" script by joining sys.databases...

Queryout is not a keyword in sqlcmd. You should use -Q "select * from table".

-c (batch terminator) and -t (timeout) are not necessary.

But what is necessary is -S (server name),...

bcp is not supposed to show column headers. Try sqlcmd instead.

There is good Stairway to Replication right on this site:

http://www.sqlservercentral.com/stairway/72401/

Check with sys.sql_modules whether your new S.P. code indeed in your database, not in master or any other databases. Sometimes during deployment people tend to omit USE...

It sounds like your home PC. And apparently not SQL Server experiences the issue with memory, but your other apps running on same machine.

SQL Server will grab nearly all...

It also could happen as a result of blockings. Check if application's S.P. are blocked during their execution.

It sounds like your shop may have build some custom error-hadling log - which simply a table - where all errors from begin catch / end catch blocks are being...

It returns in 8k pages. To get it in MB, devide by 128.

I see that number of pages are dirrefent. It is possible that one of them has tables, indexes...

Try to experiment by choosing different coulmn(s) for that clustered index.