Drops a distribution Publisher. This stored procedure is executed at the Distributor on any database. If 0, replication verifies that the remote Publisher has uninstalled the local server as the ...

Tests the connection to a linked server. If the test is unsuccessful, the procedure raises an exception with the reason of the failure. :::image type="icon" source ...

Last time, we showed how to take advantage of a built-in stored to run a command against multiple tables. This time, we look at another for working against a bunch of databases. In my last post, I ...

Get the lowdown on SP-1's added features, including fully supported database mirroring, bug fixes, and add-ons for SQL Express. What's more, SP1 not only contains bug fixes, but also delivers ...

Microsoft has released the final version of Service Pack 3 for SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0, this one containing updates for database components and OLAP Services components.

O LocalDB é uma versão simples do Express que tem todos os recursos de programação, é executado no modo de usuário, tem uma instalação rápida sem configuração e uma lista curta de pré-requisitos. Use ...

Microsoft announced this week that it is having problems with ISO releases of SQL Server 2012 Service Pack 2. Service Pack 2 for SQL Server 2012 was released last month. However, there's a problem ...

Have you ever had to change the name of a server that has SQL Server installed on it? If you anwered yes, did you know that you also have to change the name in SQL Server? Here are the steps to ...