have a look at http://www.informit.com/guides/content.asp?g=sqlserver&SeqNum=31

Yes you can, you can tell the difference by opening up books online. sp3a updates books online and I believe it tells you it is the updated version. With regard...

Without seeing your schema I am just guesing, but try and create a physical table and run the code. It could be the sp is recompiling because of the temp...

After banging my head against the wall I have the good luck to look at this post http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=213518 from bnye.home.att.net who gives me the last...

Thanks for the reply, I already have a job that does the after the fact analysis. What I am looking for is to find a job running over its usual...

what size is the model database, if its set to a large size all new bases will be this size on creation. I believe the temdb is also re-craeted using...

use replace, look it up in bol

what do you get if you comment out --exec sp_executesql @sql and

print @sql ?

have a look on sqldts.com on using ini files to make the connections, there was also an article on this site.

I don't think its a PK issue on the actual replicated tabeles but a bug that is described in this KB article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;813494

Do you have different collations on these databases? If so maybe its a case issue

there was a script posted http://www.databasejournal.com/features/mssql/article.php/3517766

that should give you what you want

If you query sysservers you should see an entry for your server, but it probably does not have a svrid of 0 so it wont show up as local server

if...

when you add the server remember to use the local paramater

sp_addserver 'yourserver', 'local'

without this you simply add a new server and you will still get null from @@servername, also is...

Have you thought about using log shipping?