the problem remain . any help ????

i hope the attachment is helpfull

any idea what i have to do ?

the problem is that the query is going in activity monitor in task state ='suspended' and it takes a long time

the query is quite slow even if i use ...

using the query for memory

SELECT

(physical_memory_in_use_kb/1024) AS Memory_usedby_Sqlserver_MB,

(locked_page_allocations_kb/1024) AS Locked_pages_used_Sqlserver_MB,

(total_virtual_address_space_kb/1024) AS Total_VAS_in_MB,

process_physical_memory_low,

process_virtual_memory_low

FROM sys.dm_os_process_memory;

Memory_usedby_Sqlserver_MB is 38199

and Total_VAS_in_MB is 8388607

all the other fields are 0

http://superuser.com/questions/841398/how-to-convert-excel-file-with-multiple-sheets-to-a-set-of-csv-files

i am using the tool "XLS to CSV Converter' see attachment

fisrt of all i finf a tool that converts the excel in csv and each tab to a separated csv file. so if the original excel file haw 40 tabs...

thanks. it works

i do not want to generate an increment but when there is same title should be the same id

??. but I want the numbers of the id to be written automatically and not manualy. lets assume i have a table with 10,000 rows its not possible to...

ok. I want a clarification

I create the table D_Reports_Status and in the job I add 2 extra steps one at the beginning and one at the end

My question is for...

sorry for the Capital letters

so

is it possible to use in one step

update Reports set SSIS=1 where ReportID=51

EXEC msdb.dbo.sp_start_job N'D_Reports'

and in the second step

update Reports set SSIS=0 where ReportID=51

thie is...

OK

IS THIS CORRECT IN ONE STEP

begin

update Reports set SSIS=1 where ReportID=51

EXEC msdb.dbo.sp_start_job N'D_Reports'

end

begin

update Reports set SSIS=0 where ReportID=51

end

BECAUSE I AM GOING TO USE A LOT OF ReportID'S IN DIFFERENT...

ok

is it posiible to use 5 different steps for each db and inside each step to use ( SQL Server 2012)

BACKUP DATABASE [CONNECT] TO DISK = N'C:\Program Files\Microsoft SQL\...\MSSQL\Backup\CONNECT.bak'

I an...

is it possible to use the DETACH