The right order really depends upon your business requirements, the disaster recovery requirements and system restore requirements. My preferences is to perform the backups last, that way I don't...

GSquared (9/24/2008)

---

Since you're on Windows Standard, you can't go above 4 Gig of RAM in use anyway, so there's no point to AWE. I don't think you can even...

Please do not...

If you cannot figure out how to pass in a Null value - then, pick a value that will never exist in the data. I would probably go with...

Right-click on the view in Object Explorer and script as CREATE to new query window. Change the connection or database in the query window to the system\database where you...

First - are you sure you installed developer edition and not express edition? Second, what version of SQL Server did you install? The executable for the management studio...

Also, if your system is setup like most systems - then all of your objects are owned by the dbo schema. If so, you want to modify all users...

Not sure what you mean - are you sure your companies mail server is accessible from anywhere? Have you tried pinging the mail server from home to see if...

Create a role in the database, grant execute privileges on the appropriate schema to the role and add your users to the role. To grant execute privileges you would...

Check out Melissa Data - they are fairly well known and seem to be reliable.

Yes, you have to download it from Microsoft. I don't have the link - but if you search Microsoft for Performance Dashboard it comes right up.

At work, you are connected to your companies LAN and have access to the mail server. From home, you are not connected to your companies LAN, and therefore you...

As was mentioned previously, check the execution plans from both systems.

Just a guess, but I think you'll find that the difference in the execution plans is due to...

If you were to upgrade to SQL Server 2005\2008 Enterprise Edition - you could then rebuild your index online. Well, actually that depends upon the table and index being...

bmr270 (9/18/2008)

---

When I check the version of SQL server in Enterprise Manager

It is showingProduct version:8.00.2039(SP4)

When I check the version of SQL server in Query analyzer (@@version)

It is showing Microsoft SQL...