Shawn's memory is ok, you cannot use Enterprise Manager from SQL Server 7 or 2000 to administer databases in SQL Server 6.5 instances.

There is some information in this article...

No idea. Does not any of them work in Jet?

One question, even after Reindex usually the external fragmentation still remains.. will disk defragmentation solve this?

No. External fragmentation means that the logical chain of pages requires unnecessary extent switches.

Does disk...

Like I said, in general the user who owns the objects in your database should be dbo. Do you have a specific reason for needing to change it?

What tool are...

Are you sure that you are currently working in the correct database? Issue a USE databasename first.

I know this is not the correct syntax. Basically, how do I reference a field in the main query, from within the subquery?

UPDATE Contacts AS C

Set fkClientLocationID =

(SELECT...

The permissions window shows which users and roles in the database that have rights to the trigger.

To change the owner of an object you use the system stored procedure sp_changeobjectowner.

EXEC...

Hello Shashank, and welcome to the wonderful world that is SQL Server.

First of all, having someone explain basics here will not give you a good understanding. I suggest starting by...

user is a reserved word, so you need to quote it.

SELECT * FROM [dbo].

dbo would not have needed to be quoted, but it is never wrong to do it.

Every time I do a select on this table, it shows duplicate record. But when I execute the DBCC DBREINDEX on this table and do the same select again. The...

Well, yes, it is known. It is how the Hide Server feature works.

It only changes the port from 1433 (default) to 2433 and...

OK, so it seems there were some error when installing the developer edition then. Which version did you install? Was it April CTP, June CTP or other? I know a...

SQL Native Client is not a client tool, it is the new API to work with data in SQL Server 2005 from client tools. Where did you install SQL Server...

No problem. For more information regarding temporary tables I suggest you start at the CREATE TABLE topic in Books Online. Towards the end on that topic there is a section...

Well, yes, it would be possible. But there are some questions here, regarding how the data is stored. First of all, you should not be storing redundant data. Storing date...