Hi thanks for that I didn't know a no tick meant revoke. 

He is a member of other databases, in the same way he was on the old server.  He belongs...

I used 128KB clustersize, might that be detrimental to performance or means lots of waster space?

aaah, see what you mean by the execution plans.. they're the same, and the same for my own variations in code too.

I sort of like a bit of both, keeping...

Thanks Jonathon,

I thought it might be something like that I was just wondering if you could respond to an @@error or something.  Do you think you could use a table...

you may have to rebuild them to be the same collation and stuff with rebuildm?

Rob

I have had similar problems, in the end I have determined that SQL Server has problems with Copying very large files over networks. I tend to backup local and...

Thanks very much for the reply. I suppose the backups will have to be made locally and then copied accross in another step. Its a shame maintenance plans...

if you ran dbcc errorlog you would have to increase the number of logs you saved otherwise you could soon lose all ability to trace problems.

Don't worry too much about it Crispin I was just wondering if it was my compiler that was failing. I prefer to use the source code so you can...

I have tried compiling the xp_file but it fails, this may well be bcause I am using VC++, must it be compiled in C only?

Thanks very much for the interesting script finding non ascii chars, I modified it a little for easier viewing:

Set @i=1

While @i<=DataLength(@Tmp)

Begin

If Not ((SubString(@Tmp,@i,1)>='A' And SubString(@Tmp,@i,1)<='Z') Or

(SubString(@Tmp,@i,1)>='a' And...

I have 2 tables with companyNames in, both should match but in some cases the 1 tables companyName has some trailing blanks and so an inner join fails. I...

it's nvarchar , which is why I don't understand it.

I thought you'd just use: select srvname from master.dbo.sysservers

Thanks for the query. I don't understand how you use the trace flag mind. I have discovered that I can restore another msdb over the current one to...