Can anybody tell if any security mechanism (SSL, for example) is being
used by SQL Server 2005 when you are execting query on a linked
server?
Thanks you

how can i set a cascade delete for a recursive relation ?
setting cascade delet to a normal PK FK Relation (2 Table) is no problem but
for recursive relation are the fields in Relationships Dialog Box disabled.
Thanks

I have the .bak and 3x .trn files from one server running a 64-bit SQL
server. This is getting moved to a 32-bit SQL 2005 server. Can someone give
me the exact procedure to restoring this please?
I can restore the .bak fine, and I've restored this in 'non-operational'

I've got a simple query that i'm using in order to extract data from a
warehouse fact table using local partitioned views (with check constraint on
a column called start_date_id).  The condition of the query is constructed
dynamically in order to specify the appropriate date ...

I have a SQL server 2000, with a suspect database that has been detached.
Client has no backups. I have copied MDF and LDF files.  I have tried to
attached database but get error 3456.  Is there a way to recover from mdf &
ldf files?

i have tried installing SQL server 2005 express edition service pack 2
(KB921896) iam getting an error code 2B22 can anyone help please?
asi use this computer mainly for keeping accounts do i really need this pack
anyway?

I have SQL Server 2000 installation used by ProjectServer 2003. I used to
truncate logs and shrink database every month, but last two months I didn't
and the log grow to almost 3 Gigs. The problem is the commands:
BACKUP LOG @database WITH TRUNCATE_ONLY

Had this query:
SELECT     Sire, [1] AS first, [2] AS second, [3] AS third, [4] AS fourth
FROM         (SELECT     Pos, Pos2, Sire
                      FROM          dbo.Vista_2) p PIVOT (COUNT(Pos) FOR

Is it possible to use database mirroring in SQL 2005 to mirror from one
source server to multiple servers?
Thanks, Sarah.

In of my tables, 4000 rows are added everytime an insertion is made. I
want to add a RowID field of datatype "bigint" so that while deleting
I can pick the RowID and delete a row. I don't want to keep this RowID
field a Primary Key. There are thre other columns that are combinedly

I am trying to understand what happens within the database when a
transaction is rolled back, specific to what occurs between memory and disk
and the log itself.  I am trying to understand at the very core level – I
know what a transaction is, and I understand that when any ...

I'm trying to create a full text index on one of my tables, but I get the
following error...
"Could not load type
'Microsoft.SqlServer.Management.Smo.Agent.JobBaseCollection' from assembly

I have a database in Access 2003 that pulls information form a PC and
converts it to usable data for our custom program.  I have tried to import
the database into SQL 2000 using the "upsizing wizard" in Access 2003.  When
I import the database I get an error saying error 156: ...

Does anyone know a way I can use a print driver to print from our MIS system
(EFI Printsmith) and populate sql tables? eg: print direct to a .txt or .xml
or using PrintForm .NET. The MIS has export features but only on a scheduled
basis. We want to send quotes, proofs and ...

I'll be as terse as possible... Our next product release will support
UNICODE, so all VARCHAR fields, casts, variables, and all usage will be
changed to NVARCHAR.  Hundreds of our customers databases will need to be
programatically upgraded.  We know how the databases SHOULD look ...