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...

Manoj

That sounds OK.

John

Manoj

You should start a new thread for this question since otherwise it will only be read by people who are watching the original topic.

John

Ron

Since Kathleen has Windows Server 2003, it is true that she can use the /3GB switch in her boot.ini file.  This will allow certain applications to access 3GB of RAM...

If I have understood your requirements correctly, you should still be able to script out the database creation (tables, SPs, constraints, views and so on) into one text file and...