Hi,

but is DTSRUN also applicable for running DTS packages in a 64bit SQL Server environment? or do you have to create an SSIS wrapper?

I read somewhere that SQL Server 64bit...

Just done this today.

I had to upgarde two instance SQL Standard SP2 --> SQL Enterprise SP2.

Just Run "setup.exe SKUUPGRADE=1" as explained above. Then I selected each instance name and wnet...

I have sorted this now. Turns out the follwing error was occuring

[red]The local MS DTC detected that the MS DTC on CISQHSSQLT008V has the same unique identity as the local...

belive it or not, this is LIVE

before you say anything I know I know! but this request has come from high up above...

thank you very much for this. I have been invetsigating and I was inteding to run the follwing command

use

[dbname]

GO

GRANT

VIEW

I created the read only reader to allow DEV team to query the database. But they also require to see the list of SP's or even view the SP contents for all...

Sugesh,

thanks for the response. Excuse my lack of knowledge on this as I am failry new to SQL2005. How exactly do I do this and is it possible to apply...

It turned out that after a recent AD migration my new account did not have permissions to the replication snapshot folder. Once full foder permissions were restored I can no...

Hi Barbara,

I am having this very same problem! It is very frustrating. Can you tell me what tables you created the indexes on?

Siz

thank for the quick reply to my question as always!  

I was quite worried bout that too. But surprisingly I'm running the script across four linked servers as a distributed query and UNION ALL  for the results and it takes...

Hello gentleman, thank you both for the input which proved very helpful and gave me a few angles to work from.

In the end I decided to go for Ninja's initial...

well its given me a new angle...thanks for that. Im getting individual jobs returned but they are duplicates now. I will investigate!

Superfast respons as always!

SQL Noob, that is exactly what I am afraid of! Upgarde to SP4 then...SPLAT!

Rudy, I totally agree with you. I think in the past what has happend is that whenever...

Thanks every1 for the input,

Ninja, tru the convert doesnt slow it down that much. I just wanted to know if there was another way to trim down the date field...