Thanks for your replies.

why I need this much of data : This is the requirement by Higher management for some analysis purpose, I know this much of data is of...

Thanks Kingston Dhasian,

any other way?

Thanks GilaMonster for your reply,

let me ask you in a different way for my better understanding,

I ran a query and it extract suppose 100K records , the query finished but...

No, that's will give the difference.

I want dates between those two like below

2013-08-01

2013-08-02

2013-08-03

2013-08-04

2013-08-05

2013-08-06

2013-08-07

2013-08-08

Total SPID's 26K

number of read from 6 to 991147

what can I conclude from it ?

you can use the below script to find when the table got accessed last time

WITH LastActivity (ObjectID, LastAction) AS

(

...

yes i agreed with n79799,

create a SQL job with Four Steps, first three will have the SSIS packages and the fourth one the command to update table. Make sure to...

why arent you using SSIS? you can easily do it using SSIS.

thanks for your reply,

let me ask in a different way.

suppose all three express/standard/developer fits application requirment

and we developed a application which keeps/calculate salary records of all the employee in...

we were using a tool called MAGIC for payroll, its a very old tool and the DB has become big now,

the vendore has now upgraded the tool so that it...

I hope below Script will Help you :

Backup all the databases

select name into #temp2 from master..sysdatabases

select 'BACKUP DATABASE ' +name+

' TO DISK = N''\\192.168.23.80\Backup\VITAS2SQLA_BACKUPS\Reporting server backup\'+name+'.bak'''+

' WITH...

Sorry if the above was not clear,

create table test1 (question nvarchar(50),answer nvarchar(200))

insert into test1 values ('Sexe','un homme')

insert into test1 values ('Sexe ','une femme')

insert into test1 values ('Statut ','Célibataire')

insert into...

This needs to be done at MYSQL server end, i never worked on MYSQL so cannot tell you how to create user or give permission at MYSQL. In my case...

the USerid and password you are using to connect to Mysql dont have appropriate permission

Thanks Again for your reply, i will try this also.

but i did it other way, i created a batch file and use that batch file in SQL JOb and all...