I am trying to change the value of an environment (MSSQL service user)
variable with the following tsql:
exec master..xp_cmdshell   'SET test=test'
unfortunately the variable is not changed; anyone would know why this

i have a database that has a data file that's over 50GB.  i want to make it
smaller.  how can i find out which table is causing the overall DB to be so
large.  is there a command that shows me the database size broken down by
table, etc.

I have two servers running SQL Server 2005.  I'd like to transfer data back
and forth between the two.
Aside from the UI associated with SSIS, what are the pros and cons of using
linked servers to insert/update/delete data versus using SSIS?  The

I just installed sql server 2005 on a sbs 2003 R2 server.  There are no
applications using sql server yet but there will be soon.  The sqlserver.exe
process is eating up 1.6GB of memory and slowing the system down.  I see a
lot of posts talking about setting max memory size.  I ...

A client of ours has a box dedicated to our application and is happy to change
anything on it to suit our application.
For extremely poor reasons we have an application which tries to create a
dedicated SQL authentication user with a fixed 6 character password. (uses

Good Day,
I have noticed this warning in my SQL Server 2005 log. The full message
reads:-
Warning: Failed to get MSFTESQL indexer interface for full-text catalog

I traced a login to SQL Server (2000 and 2005) and saw a series of SET
commands upon login.  One of these commands is
SET CONCAT_NULL_YIELDS_NULL ON
The database server is configured to set this option OFF by default, and my

Sample database won't attach.  Gives the errors below.  Many references on
the web with users having this error.  No resolution shown.  I'm enrolled in
a class based on SQL 2005 and I am not able to do the labs.  Anyone have any
ideas?

We are moving a 2000 database to 2005.  I know we can just do a restore from
a backup but I want the 2005 database to be a version 9 DB.  As I understand
it, the restore will just make it a 2000 version, is that correct?  If so,
how can I make it so that it is a 2005 native DB?  ...

Hello, I have a database with a table that had it's primary key as 3 columns,
I finally added a new column to be an idenity column but kept the original
primary key to keep things working.  But when I create new tables I want to
link on my new field.  By doing something like ...

I was treated very rudely on the SQL Programming message board by someone who
doesnot have all of the facts about my background.  Hopefully, there will be
someone here who has some decency and kindness.  (Otherwise, I'd continue
posting there.)

We are having a problem with Oracle linked server.
Environment details:
Windows Server 2003 64 bit
SQL Server 2005 Std Ed 64 bit with SP2

I use MSDE with latest service pack. As you may know MSDE is not Volume
Shadow Copy aware. I have a backup software which requires me to stop MSDE
before it can properly backup the none-vss-aware (volume shadow copy)
database.

When an attach is done inside management studio, as soon as we navigate to
to the primary data file,
all of the information for any secondary data files as well as log files is
populated instantly.

Hi, I need a tools that help me to find error in table definitions and
stored proc, on an existing sql db.
Thanks a lot.
P.