Norry

I think that's about the size of it.

John

Graeme

I see.  In that case I would get all users off before the daily update, then create the new subscription after the update.

John

Norry

When I say "on trust", I mean that Microsoft just trusts you to enter the right information in the licensing box.

I think I'm right in saying that if you want...

Graeme

Yes, that option is disabled on my publication as well.  Don't know whether that's because you can only enable that when you create the publication.

Have you tried restoring the database...

Norry

Go to Control Panel and open SQL Server 2000 Licensing Setup.  That will tell you what was entered during the installation process.  This will not necessarily correspond to reality since...

Mick

What does your query fail on?  Surely the following will not produce an error message?

SELECT COLUMN_NAME FROM  OtherDB.information_schema.columns

John

Foram

(1) If the remote server has SQL and Windows authentication then yes, you can create a user for yourself and use that to connect.  If it has Windows authentication only...

Norman

No need to cross-post.  Discussion continued here:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=92&messageid=280685

John

Norman

I assume you meant to post this in the Replication forum?

Any table that you wish to publish for replication must have a primary key constraint.  If it doesn't, you can't...

Ben

Can't see what's wrong with it just by looking, and I can't access your database on the web.  I'm sure someone will come to my rescue...

John

Ben

Will this work?  I haven't tested it.

John

select

 ThreadID,

 ThreadName,

 ThreadDescription,

 UserName as LastPoster,

 max(DateEntered) as LastPostDate

from Threads t join Posts p on t.ThreadID = p.ThreadID

 join Users u on p.UserID = u.UserID

group by ThreadID, ThreadName, ThreadDescription,...

Violeta

We have jobs that back up the transaction logs of our databases when they hit 80% full.  That way we don't need to shrink our logs (which can cause fragmentation...

Graham

Yes, it does mean that.

John

Shahid

It depends what edition of SQL Server you're using and how much more memory than 2GB you've got.  If you have SQL Server Standard Edition, then you can't use more...

Ashwin

The way I interpret it is that a Transfer is a Read or a Write.  To quote from the explanation given in the Performance application, "Avg. Disk Bytes/Transfer is the...