Thank you for suggestion. But I have no luck. When I try to put database in emergency mode, I get the error as I was wrote  in...

Yes. I wasn’t enough clear in the last paragraph. The corrupted database was on the laptop. Just with such kind of trick, I can moved it to...

Thank you for advice. I tried this and many other similar advices but unfortunately nobody rescue my problem.

Anton

My SQL is running on a single x64 PC. The SQL and FTS services have a local system account as logon account. My default...

Hi,

I have one full text catalog and the second select gives me the following row:

12 HOME_Informacije C:\MySQL\FTData\HOME_Informacije 0 1 1 65537 1

The first one gives me no rows. The reason for this is...

Thank you for your answer. I have the wrong version. I have the basic version of VS2005.

Hi,

Another question with wrong correct answer.

In the BOL is the following statement:

Activates the ability for full-text index data to be gathered for qualified_table_name, after it has been deactivated. There...

Hi,

Even we use foo table instead of People, there is wrong corret answer or wrong select statement.

Try to create table and insert this 4 rows and then try to...

Yes, I have started SQL Server Agent before I have stopped and started Mail Services.

I have checked  the SQL ServerAgent Error Log, also. There aren't any errors.

Messages in this log...

Thank you for your solution. I installed Outlok 2002 and now it works.

The correct answer is the first one, because you don't need to enable text in row option before seting it limit.

You can check result of the first answer with

SELECT...

Are you sure that the second answer is correct?

I was added this trace flag to SQL 2000 startup flags, stoped SQL server, restarted it again and disable option in...

Yes, this is the best solution. But I have same programes who don't care about how many nested level of transactions they have. Becaouse of this they have sometimes unexpectedly...

I am definitly sure, that I havn't a network error or SQL server error. When I was rollbacked MDAC to version 2.71.9030, this store procedure worked without problem.

The same...

Thank for sintax and help.

With suggested code I can excute DTS package from file, but I can't store it into SQL server.

In the BOL under DTS programming topic,...