"My Documents" does not appear on the left hand side of my Open File
dialog box.  Is there an easier way of getting it on there besides
hacking through my Registry keys?  If so, how?  If not, does anyone
happen to know which key it is in the Registry?  Thanks.

I am facing poor perfornance of queries in SQL Server 2005 Standard
Edition.  whereas I had worked on SQL Server 2005 Enterprise Edition
(Evaluation Version) and these queries were performing the best of
them. I had not used any advance option in Ent. Edition for Query

My boss is refusing to switch the Verification on Transaction Log backup on,
as he feels it imposes an additional load on the server.  I say that it
doesn't matter - if we need to ever recover from these logs, if they haven't
been verified and there's a problem we're in deep ...

H!
I use SQL Server 2005 and ASP.Net to program a dynamic web site. I use
full-text  queries against plain character-based data with
'contains' predicat.

I'm pretty new to both sql 2005 and VB but please bear with me. I have
installed SQL 2005 express on a Windows 2003 Standard server. I have
also installed VB 2005 Express edition on the server. SQL seems to be
running fine (I can create databases, tables, modify them, etc.) I have

Win2k3 Server
RAID5 with 5 disks
20GB system partition (C:)
and about 300GB unpartition

I have to allow another application a connection to my database and
only grant them select rights to about 8 tables out of a possible 150
tables in this database. I created a new login and added a new role for
that user and ran some grant scripts to allow them to select from the 8

How do I tell which version of SQL and level. of patching is installed
tks
A

I have to installed one of our applications by a customer (Windows2003
server) who does not have SQL Server 2000. My intention is to first install
SQL Server 2000 Evaluation Edition to check that all is working correctly
and perform a demo.

The question is this, is there any "performance" advantage to creating
multiple files in a single file group in SQL 2000 or 2005?
It seems to be unclear so I'm curious if anyone has a definitive answer
from Microsoft on this.  I've seen conflicting documentation, like

How to enable "xp_cmdshell" on unattended installation using "tamplate.ini"?

We are setting up a SQL 2005 environment in which to migrate all our existing
databases to.
Below is the hardware configuration we have:
2 servers each with:

Working with my first instance of SQL 2005.  Applied SP1 and now I need to
add another service (Reporting Services).  Not sure how to do it.  If I use
RTM media it gives me a backward compatibility error.  If I run SP1, I don't
have the option to add services.  I am sure the ...

OK...I'm installing a new SQL 2005 cluster installation.  We installed the
64-bit version on these same servers without issue.  Due to some
mis-information from a software vendor (not Microsoft), we are having to
rebuild as 32-bit.  So, we wiped the servers, installed Server 2003 ...

In Oracle's database, there is the concept of mirrored transaction logs.  If
the primary copy of the transaction logs gets corrupt along with the
database, you can use the mirrored copy to recover the database (assuming the
mirrored copied didn't get corrupted as well).  Does SQL ...