change you data transform script to exclude the timestamp column then new values will be created in the destination database. this will work only if you don't want to keep...

You can do something like this.

Create the same physical file structure on the new server. (You may have to create new partitions to create the same file structure as in...

Check the following location on your server/machine to see whether you can find AdventureworksDB files. If they are there attach them manually.

C:\Program Files\Microsoft SQL Server\90\Tools\Samples\1033\awdb\AdventureWorks_Data.mdf

C:\Program Files\Microsoft SQL Server\90\Tools\Samples\1033\awdb\AdventureWorks_Log.ldf

write a script to Go through the list of all objects you wish to ALTER

Get the list of their stats into a temp table

insert into #temp exec sp_helpstats @objname...

Hi Max,

Yes I can see the DLL reference when i run the sp_helpextendedproc. And I ran the sp_dropextendedproc to drop it as well. it's working fine. then i tried to...

My recommendation is to use Microsoft Terminal Client. It's better than PCA, you can have multiple connections, and the Remote server can still be locked while you access it from...

Assume restarting 50 production SQL servers to update a Extended Stored procedure. That's the main reason i cannot restart the SQL server.

I want to do it without rebooting the Machine or SQL server. And RegSvr32 doesn't work since it's not a Registered DLL with Windows.

This is what BOL says

Microsoft® SQL Server™...

Numeric is supported on SQL 2005 Beta 2.

well you cannot view the print resutls with a DTS package as i know. Why can't you juse seperate out the SQL task (i assume you were trying to put...

It's Simple.

You just need the following query to update all your Support and Sales fields.

update warranty

set  Sales = vendor.[AT]

 ,Support = vendor.[AT]

from warranty join Equipment

 on warranty.IND = Equipment.IND

join product

 on Equipment.SubType =...

use SET STATISTICS IO to see if it uses too much IO resources

use SET STATISTICS TIME to see the time usage

use SET PLAN ALL to see the IO, Time and Sub...

Try this

BEGIN TRAN

  INSERT INTO tblUtilityReadings(Data)

  SELECT Data  FROM #tmpReadings tmp

 where not exists(

    select 1

    from tblUtilityReadings tbl

    where tmp.PrimaryKey1 = tbl.PrimaryKey1

     and  tmp.PrimaryKey2 = tbl.PrimaryKey2

   &nbsp