Well you can alter all the current users by running below code...

USE master

SELECT 'ALTER LOGIN ' + '[' + name + ']'+ ' WITH

...

I am currently sitting with the same issue on a SQL 2008 R2 server running on a Server 2003 R2 SP2 OS, I had to install the setspn.exe from http://www.microsoft.com/en-us/download/details.aspx?id=4461

I...

Hi Guys,

Does anyone get a syntax issue on the below piece of code?

IF OBJECT_ID('tempdb..#tempSubscribedArticles') IS NOT NULL

DROP TABLE #tempSubscribedArticles

CREATE TABLE #tempSubscribedArticles

(

subscriber_srv VARCHAR(255),

subscriber_db VARCHAR(255),

destination_owner VARCHAR(255),

...

Hi Erwin,

There was big queries running, but they run everyday.

There was nothing new or changed on the server.

Hi Erwin,

The named pipes was enabled and the firewall settings are correct (the firewall is disabled on this server) this server have been running for quite some time.

But the sudden...

Thank you, I tried to google the error but did not get too far... 😉

I will build a test environment and have a look thanks...

Hi BT3,

I had a similar problem.

The distributor did not show any undistributed commands and the log reader as well as the subscription had no errors and was showing "Running". But...

Hi Mary,

Any other information in the Logs or Eventviewer?

Thanks Grant,

I rebooted the server and changed the reg-edit files then it worked.

One thing I noticed the 2008 upgrade adviser doesn't pick up the custom assemblies issue as the R2...

Thank you, I did refresh the report but still the same thing.

Hi Daniel,

Thank you for your advice.

There is no Filters in the Dataset properties.

I also double checked the parameters that I am executing the stored procedure with all of is in...

Hi There,

I am currently having a similar problem.

We scheduled time to rebuild the publications, that should resolve the issue.

Will keep you updated.

But let me know if you have found...

Hi There,

The SQL Upgrade Advisor doesn't work if I run it on my SQL 2008 instance.

It give the following error:

SQL Server version: 10.00.4000 is not supported by this release...

Hi Satnam,

Thanks for your input!

I created the trigger and it is working fine.