Thanx for your reply Jack...

Currently we have a .net 2003 desktop application that downloads a tag_id with a date and time stamp per line from a reader. Each ready has...

Hi Gail, I was desperate on friday and gave him the go ahead to remove the drive ASAP so it's my own fault coz of desperation and a WELL LESSON...

EISH :ermm: i'm going through this @ the moment ... http://msdn.microsoft.com/en-us/library/ms188411(SQL.90).aspx

hoping it gets me to remove the stuffed replication setup

JUST AN UPDATE ...

I create a NEW TRACE FILE when the server was idling @ 100% activity :hehe:

Ran the tuning advisor and it recomended 2 non clustered indexes. It was...

Hi guys, I'm going through the tips 1 by 1 but on friday we increased the Page swop file on the server from 4gig to 8gig as the 4Gig was...

I rebooted the server and it's still the same

sqlservr.exe kills the CPU's!!!

I'm on the MCITP: Database Administrator list :cool::cool: 4 Dec 2008 ;);)

Congratulations on getting your MCITP Database Administrator cert, I got mine the 4th December 2008 :cool::cool:

I'll go with 2008 sometime during 2010. Might go for the developer or BI cert...

70-443, I passed 1st time out ... 😀

Pure luck as I failed my 1st attempt at the 70-431 :doze:

Read through the questions and then went through the case study after...

The problem is fixed, there was a delay on the mail server which caused the timeout error...

So nothing on the SSIS side but the actual mail server issues ...

Tip ......

Any news on the fix???

I got this error on a job that ran last night ...

All of a sudden it doesn't want to send mails with attachments :blink:

I tested with...

Hi Guys as I stated in another thread I finished the 70-443 on 23 June 2008. I'm taking a little break until I start the 70-444. The 70-443 is a...

it was a SP2 hot fix, check this out ... http://support.microsoft.com/kb/921896

We had an issue with a New production server, 64bit MS SQL 2005 on 4 AMD chips ... 2 CPU's were always MAXED out (100%), with DB activity or no...

Passed my 70-443 Exam 2day 😎

Going to takkle the 70-444 a little bit later on this year 😛