Follow EvilDbas great advice. That will work.

Thank You,

Best Regards,

SQLBuddy.

As Michael mentioned, there is no way to get the licensing info from the SQL Server.

...

Create a maintenance plan with Update statistics task and schedule it to run daily.

...

Pls check the folowing

http://www.sqlservercentral.com/articles/Installation/66128/

http://www.sqlcoffee.com/Tips0007.htm

Thank You,

Best...

As Gail and George mentioned, pls try to be more specific. The quality of the replies depend on the quality of information that you post.

IIS is required only if you...

Lutz and Jeff are correct. A basic google server should fetch a lot of very good articles.

But if you are referring to DTS Pkgs, then check the folowing

http://www.devarticles.com/c/a/ASP/Creating-DTS-Packages-With-SQL-Server-2000/

...

Yes , You can do it . Assign Lock Pages in Memory privilege to the SQL Server Engine Service

Ctrl Panel --> Administrative Tools --> Local Security Policy --> User Rights...

Are you using Lock Pages in Memory Privilege ?

If Parameterized queries are not an option, the try to implement Forced Parameterization. This will reduce the compilation overhead and the procedure...

You can use sp_msforeachdb as Henrico mentioned

But the script will fail if there are any 80 compatibility mode dbs due to the DMV limitations. Please note that this may put...

It could most probably be a Double Hop issue as Craig mentioned.

You may not be able to use the Linked Server from your desktop but if you RDP on...

1. If fine, ask him to analyze the SQL Server and Windows server configuration settings in your environment and come up with his findings

2. Ask him to make a...

Default value for the Worker threads has been changed to 0 (Dynamic) for SQL Server 2005 and 2008. But it can be set to 288 for your system under special...

Do you have permissions to create a SQL Server Agent Job ?

Also I don't see any attachment.

...

I think you can find the date and time from the summary file in

C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG

...

My vote for homebrew01. Very well said!