I have this query:
select sys.tables.name,sys.data_spaces.name
from sys.tables,sys.data_spaces
where sys.tables.lob_data_space_id = sys.data_spaces.data_space_id

I have just started working in SQL 2005 and was wondering what the easiest or
standard way is to backup the databases on the SQL Server.
Thanks...Mike

When I open Sql Server Management Studio I get a message box with a triangle
and a ! but no message when i click on ok it goes on looks like it works. How
do i remove this error?

I'm trying to assign a default value to an int type column in a stored
procedure that will display all records if the user does not select an item
from a drop down list. I have tried ">0"  and "%" but I get an error. How do
I select all records. Thanks for any help.

When I have to restore a number of Logs, I have to change the FILE number in the RESTORE command
manually.
Is there a way to automatically restore *all* log files?
Thank You

When trying to upload German characters from an Excel sheet to a database
table using DTS package the following happens:
Characters can be read in the Excel sheet. After uploading, the characters
cannot be read from the database table. The characters are replaced by a

I have a table called Products with columns ID (Primary key), Names,
Category, Store and Vendor. I want to get the unique names along with their
ID that fall under Category T, so I tried the following,
SELECT DISTINCT Names, ID

I have a SQL Server database as a back-end to an application built in Access.
My description field is set to 50 and if the users key's in a 10 character
description, the remaining become spaces.  What would be the best way around
this?  I tried putting =RTrim([Description]) on ...

I installed SQL2005 on Vista.  My question is: Will the subsequent upgrades
convert this installation into a 64 bits version?
If not what is the process to obtain the 64 bits installation software?
Thanks,

I am looking for a simple way to find out when a DTS was last time
executed. We do have hunderts of DTS on our SQL2k servers and want to
get ride of the not used DTS before we migrate to SQL05. Some of these
DTS may run only every 3 month (Quaterly end), some only every month

For each group I wants to give an UniqueId like this.
ID UniqueId
3 1001
3 1001

We have the following select statement:
SELECT gi.anbr AS A_Number, gi.Adt AS A_Date, ct.Atypnm AS A_iSSUE,
gi.Amedt AS A_ISSUE_Date, gi.Atypcd AS A_CODE
FROM OPENQUERY(DB2Link, 'SELECT * FROM Sch.GenInfo') AS gi

I have a problem handed to me from a Client. The Client is using a SQL server
database for production statistics and follow up. Somehow (I don't know how,
nor does my client contact) the databse in question was marked as SUSPECT by
management studio and could not be accessed.

I have a insert trigger that should sent the responding column or columns to
a stored procedure on another server. My guess is that only one row of data
is transferred to the stored procedure. Of course i want all returning rows
to be transferred!

Source Code Msg: setup.rll
Msg ID: 70342
LinkID: 20476
Microsoft SQL Server - 9.00.3042.00