ReplTalk
All about Microsoft SQL Replication

Update Statistics fails with Error Number:–1073548784 “Could not allocate space for object ‘dbo.SORT”

Chris Skorlinski [MSFT] Troubleshooting September 25, 2011

Error Number: -1073548784 Executing the query “UPDATE STATISTICS [dbo].[***********] WITH FULLSCAN ” failed with the following error: “Could not allocate space for object ‘dbo.SORT temporary run storage: 142101814116352’ in database ‘tempdb’ because the ‘PRIMARY’ filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup,
Read More »

Using Power Shell to script out Replication

ReplTalk Inside Replication, Try This September 25, 2011

While troubleshooting customer’s Replication scenarios we often ask for the “script” used to recreate their replication environment.  The BLOG posting below by Chad Miller provides a great example of using Power Shell and Replication Management Objects (RMO) to script out Replication. Click here for link to Quickly Script Out Replication Redux Written on August 2,
Read More »

How to reference a Folder as a Drive Letter

ReplTalk ReplTalk Blog June 27, 2011

While assisting a customer with a SQL 2000 Replication configuration on Windows 2003 we need to reference the \ReplData folder as a Driver Letter.  With help of Rick Rieser and Ryan Mangipano from Microsoft Windows Support team we had a simple elegant solution; Windows subst command. — Example below creates an alias V: drive to
Read More »