Filegroups/Table Layout
Tue, 2 Sep 2008 16:56:19 -0500
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
order by sys.tables.name
Which gives me the tables with LOB object locations, but not the location of
the table itself. I've spent a fair amoun ...
|
default value for int type in stored procedure
Tue, 2 Sep 2008 11:33:02 -0700
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. ...
|
Backup and Restore
Tue, 2 Sep 2008 11:28:11 -0700
I need to backup data on Computer A and restore on Computer B.
How do I do that?
Both are SQL Server 2005.
--
Arne Garvander
(I program VB.Net for fun and C# to get paid.) ...
|
error opening Sql Server Management studio express
Tue, 2 Sep 2008 10:50:02 -0700
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?
--
Steve Sovie ...
|
Restoring a number of logs (SQL2K)
Tue, 02 Sep 2008 19:13:06 +0200
Hello,
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
Joachim ...
|
Trim Field
Tue, 2 Sep 2008 07:45:00 -0700
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 my form, but it didn't work,
s ...
|
Help with SELECT DISTINCT
Tue, 2 Sep 2008 07:38:00 -0700
Hello,
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
FROM Products
WHERE (Category = 'T')
But it doesnâ??t s ...
|
|
|
Uploading German Characters from file giving problems
Tue, 2 Sep 2008 00:39:01 -0700
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
square.
Does anyone know what I shou ...
|
Linked server results taking 24 minutes (too long)
Mon, 1 Sep 2008 13:56:00 -0700
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
LEFT OUTER JOIN OPENQUERY(DB2Link, 'SELECT * FROM Sch.AtypcdTABLE') AS ct
ON gi.Atypcd = ct.At ...
|
Upgrading SQL2005 32 bits to 64 bits on Vista
Mon, 1 Sep 2008 12:40:02 -0700
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,
...
|
