If you house the database on the same SQL Server, using the same physical disks than I would say no.  The fact that this means that both databases would be...

There may be a better way to do this, but here is a method using substring that will work:

declare @mychar varchar(20),

 @Index int,

 @NumericText varchar(20)

set @mychar = '*CA 4000'

Set @NumericText =...

Is this a joke??  If not, along with sample data, output, and a synopsis of what you are trying to accomplish, you may want to give us your create table...

This works:

create table appname_test (

 USUARIO VARCHAR(100) DEFAULT SUSER_SNAME(),

 FECHA_AUDIT DATETIME DEFAULT GETDATE(),

 HOST VARCHAR (50) DEFAULT HOST_NAME(),

 App varchar(50) DEFAULT APP_NAME()

&nbsp

insert into appname_test default values

select *...

Both ways demonstraited here would work.  If your 2 columns should logically be part of a composit key, use the Primary Key method.  If you just need a unique constraint...

First of all, are you sure that all of your firstname/lastname combinations will be unique?  There are plenty of Bob Smith's in the world (no offense meant to any of...

It sounds to me like the client was using the additional storage on their data drive to store other data.  I have seen this a number of times where, since...

http://www.microsoft.com/downloads/details.aspx?FamilyID=5691ab53-893a-4aaf-b4a6-9a8bb9669a8b&displaylang=en

I don't know of a way, outside of killing the process, that would pause your profile if it is waiting for resources.  You've clicked the pause button and the pause...

Is your SQL Server extremely busy during this same hour?  This seems to me to be more of a resource problem than a Profiler problem.  I would say that the...

Yes, all of the data was present.  I ran select queries.  I also ran DBCC CHECKDB, which displays record counts for each table after it completes. 

sp_attach_single_file_db gives the following...

You could script the following:

1. sp_rename tables to new table names (backup_tablename)

2. drop constraints from backup tables

3. re-create original tables with constraints

4. run import/verify

5. drop original tables

6. add constraints to backup tables

7....

3) Run tests; verify data

What sort of tests and verifications are you going to do?

I assume that you have MSDE running on a server or a workstation somewhere?  Are you the network admin too?  Have your network admin make sure that you're domain account...

You do not need to delete and re-register the MSDE Server.  If you right-click on the MSDE server, it will let you edit your registration data, including your authentication mode...