Speaking of HIPAA, I'm working with a medical provider that needs to produce EDI files (specifically form 837 for Medicaid claims). They transmit the file manually so they only need...

Thanks Steve. I'm actually able to reproduce the issues on other servers so that rules out hardware.

Thanks for the info Paul - and yes, they did see performance improvements after a couple of days but now it seems to be back to where we were right...

Hi Greg,

Sorry if I wasn't clear.....here's the scenario:

Company A has a database with customers, locations, invoices, etc.. Company B has purchased Company A and uses the same software (so same...

The schemas are identical but my concern is keeping the relationships between tables in the old database when converted to the secondary database that already contains data. Is there a...

DBCC TRACEON (3604) & DBCC TRACEON (1204)  doesn't seem to work on SQL 2005.....I executed both, in that order on the server and watched the logs only to discover users...

The database was in suspect mode so I put it in emergency mode to detach the logs as I was unable to backup the database in suspect mode. When reattaching...

Thanks for the reply MohammedU. I ran DBCC CheckDB ([databasename],repair_rebuild) right off the bat and it didn't give me any errors. I'm now in the process of creating a DTS...

Ahh, got it - so you HAVE to use a list / table / chart / matrix in the body of the report? You can't just drag and drop fields...

Just to clarify - everytime I drag and drop a field onto the body of the report is automatically adds the '=First' expression. As I mentioned above, even when deleting...

Peldin, you were right - I was using '=first'. How does that happen??  I removed it from my fields but I'm still only seeing...

I can - I believe I may have actually found the problem. I was using an ODBC connection and when I changed it to a SQL connection, it worked

Yes, unfortunately....I know that problem all too well. Apparently it's a problem with the network connection, according to various articles on the web. I generally just create a new connection in...