Posted this in programming but might be better off here...
I'm trying to copy a database from one instance to another on a
different server. I detached the original, copied the .mdf and .ldf
files and attached in the new instance. The problem is all of my

What to use linked server to go from client C to Server A to Server B using
Windows Authentication.  Also Server A and Server B are going to running on
Domain Accounts that don't have Domain Admin permissions.  So I have one
question.  Do I only need to register Server A and ...

Gday,
I have a SQL Server 2005 Enterprise edition installation in our office.
When I run the Sql Server Agent,  I get a
Failure Audit:

What is the best data type for time intervals? I have a CSV file that
I want to import using DTS. col4 in the data sample below represents
time intervals (hh:mm:ss.milliseconds) I am free to define the table
in any way. Thus far I have tried varchar for all columns, varchar for

I downloaded the newest set of samples and instructions from MS.  I
successfully unpacked them, and the AdventureWorks_DAta.mdf and ldf are
there.  In SQL2005, (via a query) or the gui when I browse to the mdf and
select to attach it, it fails telling me the operating system is ...

Dear Sirs,
I failed to install SQL Server 2005 Standard in cluster invironment.
Below please find the details.
I have created three Domain Groups, as listed below:

We are using SQL Server 2005, and Database Mail was working fine.
We replaced our Exchange 5.5 machine with a Exchange 2007 machine.  Now I am
getting the following message when I try to send an email through Database
Mail:

I need to install Idera's SQLsafe 4.0 onto clustered production sql
servers(sql2005 enterprise, 64-bit; Window 2003 enterprise), which requires
.NET Framework 2.0 as prerequisite. I am wondering if it will cause any issue
with multiple versions of .NET Framework on the same sql ...

A year ago I installed licensed copy of sql2000 (sp3), installed Developer
Express, and eventually MSDN 2005 developer or standard edition (somehow).
However I was not able to get sql server 2005 sp2 to get installed, so I
decided to start from scratch.

I already have Express Edition installed on Windows Vista as part of
installing VS2005 and I have upgraded the Express Edition to SP2.
Now, I am trying to install SQL Server 2005 Developer Edition.  The install
will not allow me to install management studio because it says there ...

On a 4 dual core, hyper threading server, how many tempdb files I should
configure in order to reduce schema lock contention? 8, or 16? I see 16
processors on the Task Manager. According to some articles dual-core CPU is
considered to be two CPUs. What about hyper-threading?

I have a reporting services project and noticed my installed instance
(default) did not install Reporting Services. After much pain, I ended
up
uninstalling the SQL 2005 instance. The Reporting Services Service was

Is there a white paper for this upgrade or does anyone know the proceedure
and complications that may occur.

Does anyone know what these accounts are?
Server1\SQLServer2005MSFTEUser$Server1$MSSQLSERVER
Server1\SQLServer2005MSSQLUser$Server1$MSSQLSERVER
Server1\SQLServer2005SQLAgentUser$Server1$MSSQLSERVER

If I install build 3159, does that also install all post sp2 patches
previously released? or does that just fix one specific problem?
Thanks!