Yes, it sounds like it is being executed with parallel threads, which isn't necessarily a bad thing. If you have a similar set of the data for testing, you...

I believe that you have the option to either drop/create or truncate the subscriber table. The error may be related to having DDL triggers in the subscriber database and...

I'm not sure why you're using the 1 = 1, but here's how I see it. When you use 1 = 0, that never evaluates to true for any...

I tried this select cast('25-Apr-84' as datetime)

and it returned this - 1984-04-25 00:00:00.000

If you're trying this against the whole table, it could be that you have some data isn't a...

I was asking about what constitutes a visit because I've been a member since 2005 and , although I've only recently started to actually respond to posts, I visit the...

I found several posts when searching this error with Google. This may help.

[/url]

We've created VMWare SQL Servers from physical SQL Servers without any issues.

What's a visit?

If you find that you have to enable the profile under SQL Agent, Alert System, you'll have to bounce SQL Agent for the change to take effect.

I used a VBScript and WMI in my last job. Responsibiities are more segregated where I am now and that would be an IT function. They use SCOM,...

What's the current status of the job in the activity monitor?

I did this once and it worked fine. I found these links.hich are basically the same thing.

[/url]

I wonder if the timeouts are because the service account doesn't have Perform Maintenance Tasks rights.

Read through the link that I added earlier. I believe there are some instructions in there.

How about this? I scripted it from SSMS after checking the Drop Connections checkbox on the Detach Database screen.

USE [master]

GO

ALTER DATABASE [XXX] SET SINGLE_USER WITH ROLLBACK IMMEDIATE

GO

USE [master]

GO

EXEC...