It depends if you can use SQL Server Client Tools with this SQL Server. If you can, than use SQL Profiler or set up a server trace for a day...

That may be because the clustered index is the actual data, sorted. I don't have the explanation why it did not happen in 7.0. I am not sure I had...

Hello,

You may want to try the following:

- SQL Server 2000 replication over FTP

- SQL Server 2005 replication over HTTPS (new feature, did not try)

- DTS Export job to files on...

Hello JuanBob,

Yes, you do understand correctly.

Here is what I normally do: I request a domain account without any administrative rights to the domain. This account should have "Password Never Expires" checked....

I  do know that you can do a replication over FTP, it is difficult in SQL Server 2000. Replication over HTTPS is advertised as a feature with SQL Server 2005. You may...

I guess you are asking about non - "domain admin" , means the domain account that does not have domain admin rights. Yes, it is recomended if you server has...

Hello Macca,

In the Management Studio right-click on your table, click Modify, right-click on the column you need.

Select Set Primery Key for setting Primary Key. Set it on one column. Right-click on...

Hello Sachin,

Thanks a lot for the explanation, I do understand the process now, it was VERY helpful.

But I dicovered that my problem was due to security. I told you I...

I sure answered correctly but I don't feel the answer reflects the important points. I would say:

"A server login provides access to the resources on the server level and the...

I query MSDB sysjobs and sysjobhistory tables on different servers from one server (from one workstation) using OPENROWSET with composing a query string with connection information dynamically for each server...

There is always a process way. Just to stress to the users that he/she should use only the approved login when connecting through Query Analyzer.

Also, most of the report tools...

This means that the user can not be authenticated whatever the reason is. The reason could be that he can not be authenticated by the domain controller, maybe he logged...

Do you create Temp Tables or permanent tables? I sometimes use temp tables if I have to group different ways for the query, it does take time.

Did you try to use...

Hello Sachin,

To answer your questions, No SP1, Created nothing. This is probably the reason that it has to have a master key or something. This is OK. I am not...

(Updated)

I got an error on the second statement:

ALTER

DATABASE MyDatabase SET ENABLE_BROKER

GO

The database does have Trustworthy set to True. This database was...