spectacle

steve smith-401573 (3/21/2012)

---

MysteryJimbo (3/21/2012)

---

Its also possible to duplicate this error if the server has previously been renamed.

Are you accessing the server through a dns alias?

Make a connection to the server...

When you installed SQL server, did you ensure the replication components were selected as a component to be installed?

Named or default instance?

I like the idea of the master proc.

sp_executesql is the better way to go with dynamic sql as well.

I was thinking move the file and not just copy.

Sounds like an alias was created for this server or this server is clustered. Will you confirm the aliases in SQL Server configuration manager?

Try these tutorials

http://msdn.microsoft.com/en-us/library/bb522859.aspx

Possible causes:

AV has the file locked

The data file is not associated with the database that you detached.

You don't have modify permissions with your user account to the location where the...

Never used ANY or SOME like this and have learned something new.:w00t:

My experience has shown that TSQL is faster for that. It largely depends on how you write your queries.

omnivore

Backing what Lowell said. Sounds like parameter sniffing is possible.

An execution plan would be helpful.

Thanks Ron.

Then some data was removed.