As I said earlier, we are not worrying about OS admin or users having OS admin roles. We do not want to blame any one in an organization on any...

Gail Shaw

I understand your point which is all in place !.

The issues here. We suspect Windows admins !!!. If they took the copy of SQL MDFs and send to any...

You could do this way as well:

  - create a DTS package that should generate .XLS file as an output.

  - create a job where you to call the above...

<<use dynamic properties task and pass the name as global variable...-Krishnan >

Could you please explain me bit more in details enabling me to modify my existing DTS. In the...

Thanks for your advise.

I'm thinking about moving whole applicaiton to new box with dual processor with 4 gb RAM.

Yes, I'm using SQL2k Standard Edition. At the moment memory has...

Hi,

There would be different ways to call/run  a DTS from any front-end applicaiton. Below is the method that I normally apply:

- Will create a SP to call/run DTS package and...

Thanks Jason.

>> however you can backup your transaction log at any interval (10 minutes). 

HOW CAN I SETUP ABOVE through SQL JOB ? Please advise..

Rgds

Hi Dharmendra ,

Hi All,

What exactly are trying ? As you said that you have SQL Server called "RNOOEMSITSQLA02" and tried to "register" another SQL Server !. You mean,...

Hi,

I was reading all the post related your SP Vs. Quey Issue ! After reading your final post in which you metioned that you achieved the results within 7 miniutes and...

Hi,

To test a script I might need a table, Creating myself time consumes.

Pls export couple of records from each tables you use in the query into EXCEL and zip it and...

Hi,

Try both and look for which is faster:

 DELETE FROM Table2 WHERE AccountNumber IN(Select AccountNumber from Table1)

  INSERT INTO Table1 from Table2

--- Method 2

 INSERT INTO Table1 FROM Table2 WHERE AccountNumber NOT IN(select AccountNumber...