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

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

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

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

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

In SS2000 we could go to Security->Right click on Logins->Select New Login...->Click on the search box "..."->Find a user group-> and click the "Members..." box to see all members of a user group. In SS2005 this has changed and I don't know a way to find the members of a User Group. Any ideas...

Does anyone know of any 3rd party debugging tools for SQL Server 2005? I know that Visual Studio 2005(Pro) will do the job but we don't use VS and it costs too much to justify purchasing multiple copies for debugging SQL stored procedures. Regards, GCoast

Receiving the following message after installing SS2000 SP4 on one of my servers and trying to step thru the debugger in Query Analyzer from my PC. I can step thru the sp's if I logon to the server directly leading me to think the problem exists on my PC. I can still step thru stored procedures...

I import data from FoxPro on a regular basis(until we can convert legacy applications to use SQL Server). The following code works fine once or twice but then our server begins to run low on memory. I know that this is not unusual with SQL Server as it is designed to use as much memory as it...

Does anyone know if there is a way to get the schema of a FoxPro .dbf table using SQL? I'm looking into using Open query but haven't found a way to perform a FoxPro command i.e. List Structure, to return this info. Why you may ask, well we have hundreds of legacy FoxPro tables that are due to...

I need to store a password field in a table. Is there anyway to encrypt this field? We already thought about using views to get around this, but it seems that even the DBA shouldn't be allowed to see the field so encrpytion will be necessary, if possible. Running SS2000 Sp3a Thanks in...

My current table (3 million records) has this structure. PN Grp Seq ---------------------- 111 0 10 111 0 20 111 0 30 111 1 10 111 1 20 111 1 30 111 1 40 222 0 10 222 0 20 222 0 30 222 1 10 222 1 20 222 1 30 . . . I need to produce this output without using a cursor. Resequence the Seq field...