If the server belongs to XYZ domain then users from that doamin can connect to the sql server using windows credentials other must use sql credentials to connect and cannot...

The URL for 2005 is given below.

http://support.microsoft.com/kb/918992/

Yes go for log shipping. But with log shipping you will be only able to read the data and transaction will not be possible if its ok then go ahead...

Read the KB article in the link below. It gives a solution for you. http://support.microsoft.com/kb/303120/ 

Try using the EM to add the ESP instead of query analyzer. Also is this dll registered in the server?

What is the account in which your sql services run. try to run them under local system and see if this error occurs else then its a permissio problem given...

Use Quest DataModeller they have good options there. I have used it.

Write a single TSQL statement with taking 2 arguements so that the user can pass the arguments necessary and take reports as per his need.

select * from tablename where datecolumnname...

Once you set the default in the EM then all/any databases created without path will take the default location specified this can be only override specifying the location when you...

SO hope you will never mistake with the fillfactor again. These things are normal each one does a mistake but are major considering the effects that they would do to...

Read the KB article in the link below. It gives a solution for you.

http://support.microsoft.com/kb/303120/

http://www.sqlmag.com/Articles/Index.cfm?ArticleID=16389&DisplayTab=Article

http://sqlserver2000.databases.aspfaq.com/how-do-i-recover-data-from-sql-server-s-log-files.html

You have few third party tools not only log explorer. You can downloas these and try to decide which best suits for you.

Always make a point to use the RECONFIGURE with OVERRIDE option when you change any configuration options that comes under the advanced options category few may require restart few might...

These syntax is not supported in SQL 2005. Yo have to use only ANSI syntax in 2005 and you will not get expected results with these.

I had a similar situation a year back. I just wrote a script to use sp_helptext and inserted the text to a hash table and did the manipulation there. A...