Search results for query: *

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...

SQLSister, Just curious how Subversion is working for you? We are in need of a version control system and have been exploring the options of VSS and Subversion. Thanks much, gcoast

Will a VFP V6 exe run on a 64bit platform? If so, will the exe need to be recompiled?

During the installation of SS2005 (Standard Edition) I don't see a place to change the default location of where the LOG files are stored. Thanks, gc

mrdenny, thanks for your help definitely worth a star. btw I am using Windows XP SP2 client running SS2005 SP2(CTP)

I checked with Aqua Data Studio and they don't have a debugger either(plan on having one in a future release). Any other ideas? Thanks, gcoast