Search results for query: *

What would you suggest I do to find the queries that are locking records? what spids are being blocked?

I would like some assistance from anyone in this group. I need help identifying, what can cause 1222s in a large 22gig user database? I have not been able to identify what's causing the 1222s that prevents users form saving new data in the database. Please suggest, what can I use to find out...

Hello guys! I was wondering, in what order would you guys suggest running the following on user databases: update statistics reorg shrink database Please advise. Thanks a bunch!

Yes, complete backups are running and the recovery model being used is full because transaction log backups are also running. But still the .ldf file keeps growing! Do you guys think that taking a complete backup shrinks the .ldf down? Do you guys think that shrinking the database will help...

Good Morning Everyone, I need urgent help. I would like to find out if any of you have suggestions on how to keep the transaction logs from growing so big. For example: There is a .mdf file that's about 2gigs and the .ldf file is over 10gigs now!! What would be some of the suggestions for...

Hi Reebo, I tried Right({Table.ID},1) and it worked!!! Thanks a bunch.

Thank you, let me give this a try.

Thank you!

Hi you guys, Does anyone know, when looking at the process info screen, what column data can be used to identify a lock that should be killed? Does the Physical IO help to identify these locks and if so, what # would be considered a lock? Thanks for any suggestions.

Hello, Does anyone know how to pull only the last # within a field? For example: ID: 12345 ID: 123 ID: 12345678 I would like to tell the report, if the last # in this field is 5 then "....", if the last # is 8, then "....".. Thank you for any suggestions :-)

Hello Everyone, I am new to this site and I was wondering if anyone knows of a way within Crystal 8.5 to only print the Design Tab? All I want is to print the desing of the report without printing the actual data. I know of how to export the report definition but it's kind of long and messy...