I thought that in 7 and 2000 the extention was also only recommended, not enforced. I will check it at home

Do the rest of the queries. SUSER_SNAME will show you the login name. There could be one case that may lead to your situation:

Windows User X and SQL Server Standard...

Check Path field of sp_help_fulltext_catalogs for mycatalog. Make sure this path and  the catalog exist on your server. The default location is:                                                      

Drive:\Program Files\Microsoft SQL Server\MSSQL\FTDATA

In Enterprise Manager in Users of your database check what login is mapped to the DBO

This is correct that if you login as a login who is mapped to the...

Hi,

editions of 2000  that will install on the laptop with workstation OS are Personal (which is a developer's counterpart of Standard Edition) and Developer (which is a developer's conterpart of...

Can you post the full description of the error message from the event log. It is possible that the startup account changed the password.

QA is the front end that returns results based on the recordset properties that may specify that results are returned to the client after certain number of records are retrieved....

set @d = getdate()

The best book is:

Hi,

This message comes up when user does not have permissions to his/her default database. Like SomeLogin has a default database Pubs but in the login properties on the Database tab...

My job sends me an email about job status on other servers whilst I eat lunch. It is more convenient than during the morning coffee time or five-o'clock tea time.

You will be able to request the admin rights if you prove that you have the proper knowledge. I would (and I did) pass a  Windows 2003 server exam. In...

Enrico,

What is your time zone? Could it be that it is ahead of GMT by 1 hour now? I am setting up the test log shipping and will see if...

Can you monitor the open transactions level when executing from each QA and the Job? Could it be that when executing from the job the whole thing is considered as...

Asif,

Text data type will always show 16. This is the size of the pointer to the text data. You can store a lot of text in the text data type....