Express is limited to 1 socket or 1 physical CPU, so getting 2 CPU's isnt going to help.

In 2012 it is also limited to lesser than 1 socket...

might be a long shot but nothing automated restoring the database

select

destination_database_name,

user_name,

restore_date,

case restore_type when 'D' then 'Full Restore' when 'L'...

are you able to see the windows application event log to see if the error was logged there so we have something more to play on

you may have checked this but the targetserverurl of the solution is set to the report manager url? e.g http://servername/reportserver (that is assuming you have used the default installation...

how was the copy created the first time around?

is there a need to keep this copy updated with the data in the first DB? if so what is the...

DiverKas (5/8/2012)

---

anthony.green (5/8/2012)

---

Not to worry, glad you spotted the mistake.

Just out of noticing your joining syntax, what type of join are you after here as the syntax from table1, table2...

Not to worry, glad you spotted the mistake.

Just out of noticing your joining syntax, what type of join are you after here as the syntax from table1, table2 denotes a...

will the filename be exactly the same and in the same directory every time the import needs to be run? if so one of the last screens is run...

please provide the create table definition and some sample data.

use the text qualifier on the import screen and set it to " this should then remove the " when you look at the csv in the preview

thanks, can you also provide the create table command as well for the table and a few insert statements for some data within the table (granted data maybe sensitive, but...

it is substituting 0 with the default date of '1900-01-01 00:00:00.000'

If only a time value is assigned to a variable of a date data type, the value of the missing...

what is the error?

can you also detail the full query, including tables and sample data as per the second link in my signature block to help us create a mock...

can you detail the error

if your trying to put a uniqueidentifier into an int column it will not work as this conversion is not allowed

you need to set the variable = null

CREATE PROCEDURE dbo.GestionStatutDossier

-- Add the parameters for the stored procedure here

@StaId int = NULL,

@DosID uniqueidentifier,

@staDate datetime,

@staBL nvarchar (50),

@staCRprod nvarchar (50)

AS