I have a SQL Server Package that is dumping a text file into an Access
Database.  However, due to update timing every now and then it errors
out due to a primary key violation.  How do I capture that error
number in my next Active Script Task and determine whether or not I

I am trying to move Data and Log files to a bigger drive. I have detached
the current drive and copied the files to a the bigger drive, however when I
try to attach the database to the new drive, I am not seeing it on the
"Locate Database Files" choice. The only drive I is the ...

We have a maintainance plan for full/diff/log backups of selected databases
running at regular intervals through SQLAgent. The backups are working; I can
restore the databases. But starting a few weeks ago we've been getting error
messages in the system event log.

We have a big migration from SQL server 2000 to 2005
It is a big procedure aith millions of records and it uses DTSs
heavily, so I am asking some hints on s your experience on
1. "basic" migration of DB ib itself

I am having a problem and please help. I tried to add a trace flag -g512 to
our sql 2005 sp2 clustered instance. I added to the startup parameters line
of the SQL configuration manager, something like this:
-dT:\Microsoft SQL Server\msql\MSSQL.1\MSSQL\DATA\master.mdf;-eT ...

I just purchased 2 copies of SQL Server 2005 standard edition at the tune of
$1000 each.  It comes with 5 CALs.  I had been using SQLExpress 2005 but
decided to use the full version prior to shipping the deliverable.  When I
went to install the software (on a michine with SQL ...

I am getting confused as to which cluster configuration is better? Active/
Active or Active/Passive.
Thanks in advance
Manu

There are 25 indexes in my database which continue to report they are
severely fragmented even after I rebuild them. The operation completes
without error, so I don't understand why it is still fragmented. It does not
matter if I use REBUILD or REORGANIZE, the result is the same. ...

i need search in BBDD with 10000 tables a filed with type is decimal(5,2)

The company that I am writing app for has sql server 2000. I have the
following questions;
1. Can I develop the app on my sql server 2005 and then deploy on their
2000? If so, what features can I not use in 2005 if the app needs to be

hello...
I've got problem with backups on sql2005
script make backup at saturday with full backup  and at monday script
runs diff backup. On one of few sqlservers2005 diff backups doesn't

I want to install SQL 2000 on a new Win 2003 server which has a temporary
name of Tmp01.  When we are ready to replace the old Win 2000 server named
SQL01 with the new Tmp01, I will rename Tmp01 to SQL01 and take the original
SQL01 offline.

I've got a new Vista x64 build with SQL2005 (+SP2) freshly installed. I'm
now trying to copy existing databased from other services but I can't get it
to work. I get the following error logged in the Event Viewer Application
Log:

I'm trying to setup a linked server from SQL Server 2005 (64bit) SP2
to SQL Server 2000 (32bit) SP3. I use the same setup as works for
several other version/SP combinations, but get the error below. This
used to work, probably before SP2 was installed.

I have a 1:Many relationship.  table A (one) and table b (many) but I want
to be able to have table b records exist independently.  How do I build that
relationship with SQL Server?
Thanks,