"What do you mean by this"

Disallow Enterprise features in SQL Server Developer Edition.

Short answer.. Can't do that

SUCCESS 🙂

The offender was on an XP box. The situation was Windows 2008 / SQL 2008 had a linked server to an XP box / MDSE 2000. ...

Fixed it:

Changed service account to Local System.

Works fine now

🙂

Anyone find a solution for this other than work around?

Have SQL2014 Express installed trying to link server to a SQL 2008 Std. Both on 64-bit machines (SQL2014 Exp is...

No what happened was the dba thought they were on another box and that the snapshot agent had just not started, so started it. Replication was working...

More info.

Running this BCP from inside xp_cmdshell (has to do with validation issues)

SQL Server default packet size is set to 4096 ....

so think that perhaps there is...

Yes lots of queries that use temp table. The problem is the INITIAL size in changing.

Thanks for the link. Any way to get around this via hints or ?

Thanks for the article. We have a very robust physical VM environment with about 300 VM servers. Oracle has been very negative towards the whole VM...

Nathan Campoli

Thanks so much for the post. Made life less interesting. It's a script I'll keep - hopefully I will have forgotten why I needed it but won't...

Yipieee!!!!

I just got it. On the drop proc had to have the [] around both the schema AND the proc name.

drop proc [Domain\Username].[by_LSN]

Thanks all for your time...

It returns:

schemaName = Domain\Username

Objectname =by_LSN

PotentialCommand =

EXEC sp_changeobjectowner '[Domain\Username].[by_LSN]'

Also tried

Drop proc [Domain\Username].by_LSN

Again get not exist or permission error: Logged onto SQL as sa and then tried my...

Tried the suggestion still does not work because it's based on NAME not object_id

Here's a better synopsis of the issue:

Have a database SQL 2008 compatibility level SQL 2000

Have a...

Humm would lose my $1.

Now I'm really lost.

If I do a very basic query

begin

select * from linkeddatabase.tablename

end

it runs fine

If I select and run

begin

declare @cMachineNetworkName as varchar(255);

set @cMachineNetworkName = 'LinkedServerNN'

-- Get...

Yup... I guess I better schedule some down time for the linked server so I can see the settings; Run DTCPing etc...

Now that I've written this all down I...