really didnt wanna post under my name oooops!!!!!!

is there any way to delete that ?

Hi Grant

your probably right!

obviously i have googled typical questions and to be honest i am more than fine with 95% or more of what i read, i really only...

Don't even mention open rowset lol I prob have questions on every forum trying to make it work on this server- it simply hangs each time and returns nothing- I...

cheers ninja - we actually are running pretty decently - i was just wondering if there was anything that maybe would give us an unexpected boast in sp3

any bug fixs that could improve overall performance?

yea ill upgrade to sp3 once im happy with current setup - the install discs just are sp 2

is it just bug fixs or are there any decent new features?

both 32 bit

found it!

SELECT * FROM sys.dm_os_performance_counters

WHERE counter_name IN ('Target Server Memory (KB)','Total Server Memory (KB)')

which shows it worked ! 🙂

i have since had to move my scripts and application to a sql 2000 server and link back to sql 2005 - this is working perfectly!

but really its a bit...

some new developments

i added some logging to my script which showed me

17/06/2011 12:32:48.91 Starting...

17/06/2011 12:32:48.91 Done.

but the query took 16 mins to finish?

hmmmm...

works some times and not other times, works all the time on another sql server !!

any suggestions welcome!

when i check sp_configure xp cmdshell has max value of 1 - what...

i enabled ole automation and it now works yipeee 🙂

its the server 🙁

just set it up on another sql server with a different report and it worked fine

yea i think your right, its not particularly expensive $350 but fingers crossed it works!

hi lowell

i just downloaded yesterday on advice from a friend (hes on hols in the usa so i dont want to bother him if he had the same issue) and...