Recent content by gcoast

We've been running Macola ES for several years now and the BacoAppLog table has over 8 million records. I've been told that they have a job that will purge these records but we can't afford to lock up the system. Question - Is it safe to delete records from this file using SQL directly...

When I use SSMS it's very slow. Not just queries, even just selecting properties can take over a minute. As a test I started SSMS using the run as feature and it's fast? I've started it using run as as myself or even a different user and it's still fast? Very annoying.. any ideas? I've already...

That's correct.

We ran the Repository Rebuild and all is well know. Only took a few minutes and we have a large database. HTH, gcoast

Recently we have started receiving calls from our Synergy users that they are getting the message, Unable to update business component: Request. Data is currently locked by another user. There are no visible locks in either SQL or the MACLOCKS table that I can see. We have many Event Manager...

I need a query that will find shift times starting after 7pm on Fridays. I know I can use the "datepart(dw, starttime) to find the dow but I just need the records past 7pm. I need to query from a schedule table that has schedules for the next 6 months. Thanks, gc

George, I think I will use your last post as it keeps me from specifying the length of the field in the select statement. Thanks again, gc

Thanks for all the replies, Just what I needed. gc

Thanks for the replies. But as I said I must keep the '2400' in positions 5-8. The data will at times contain numbers and letters so I can't convert to an int. Just need the final result to be ' 2400'. Thanks, gc

The field is always eight characters long but may contain numbers or characters. The number of leading zeros will vary. The database is being supplied by a 3rd party and we cannot modify the way they are storing the data. Thanks, gc

What is the best way to replace leading zeros in a char field with blanks? Must keep the '2400' in positions 5-8. '00002400' would become ' 2400' Thanks, gc

We have several SS2005 Standard Edition Database Engines installed. Do we need additional licensing to install multiple copies of the SQL Server Management Studio Client? Thanks, gc

Trying to find a way to copy a database diagram back to the same database on the same server, for use as a template for other database diagrams. SS2000 SP4 Standard Edition

Thanks for the info. When you say 32bit install are you referring to the O/S or Sql Server? g

Installed Windows 2003 Server Enterprise Edition SQL Server 2005 64 Bit Standard Edition FoxPro 32 bit drivers Question: How can I import Foxpro (version 6) data into a 64 bit SS2005. There is no "MS OLE DB Provider for Visual Foxpro" listed in the Data Source drop down when using the...