Recent content by jaylou

Hi all, Does anyone know if there are any ODBC drivers for Omnis that I can use on a Windows 7 PC to connect to SQL Server 2008? I have an application which uses OMNIS 7 datafiles, and I would like to create some reports using SQL SERVER 2008 reporting services. TIA, Joe

Thank you, I guess they left that out of the local help in SQL2005. Thank you again!

Hi all, I was checking indexes on a database and came across this object name sysobjects.name = queue_messages_1977058079 sys.index.name = queue_clustered_index Can anyone tell me what a type of "IT" is on an object in sysobjects? SQL Server 2005 Thanks, Joe

All, I have a SQL2005 server that is running merge replication against SQL2000 boxes. One of my SQL2000 box needed to be replaced due to disk issues. I scripted out my Subscription from my 2005 box and tried to reapply it after I rebuilt my new 2000 box. When I run the script I get an...

Unfortunatly I think I do need to run the repair. I dont have a good backup for this database without the table in the current condition. Do you think it would help if I drop and recreate this table and re-load the data? Thanks again When I ran the DBCC chectable, I receive the following...

Thank for the info... Now all I need to do is find the time when I can place the DB in single user mode. Thanks agaon. joe

Hi All, I am driving myself crazy trying to debug this one. My Integrity check keeps failing due to: Test (m_freeCnt == freeCnt) failed. Values are 7798 and 8094. And Test (emptySlotCnt == 0) failed. Values are 1 and 0. I have been researching this all morning. I ran a simple select on the...

I am having issues where i lose connections to my SQL server 2000. I get errors like "Logon to server '(local)' failed (JobManager)" I checked sysdatabases and there is an entry for (local) and also for my servername. My serverName is SrvID 0 and (local) is SrvID = 20 ServerName isremote = 1...

Thank you. I know about DTS not working. we do not use DTS here I am using merge replication. Thanks again, Joe

Hi All, I am having some memory issues and SSL issues with my SQL 2000 box. I had SQL 2005 installed on this box, I uninstalled it when I had a crash of my production server. I installed SQL 2000 on this box and moved everything over. Everything including my replication was working fine then...

Hi All, I have a merge replication running from 20 of my branches to a central location. Not all the time but every now and then I get an error from the Agent: The process could not bulk copy out of table 'cont2EBA90D8603A43BDBBCDCF7A2FE9BC4B' I remember seeing something about the number...

Yes it is. I was trying to to connect as SA as well. I am thinking SQL2005 uses SSL's? I had 2005 installed. I uninstalled 2005 and installed 2000 on the box. Maybe 2005 left some incompatible items? Who knows.... I deleted the SSL's on the server and all seems to be working again. Thanks...

Hi All, I just moved my databases from an older Server to a new windows 2003 SP1 server. I was connected and all my jobs ran fine last night. All of a sudden this morning I tried to connect thru EM and I get the following error: "A connection Could not be established to (local) Reason: SSL...

Is there a way to import all DBF files in a folder into SQL 2000 tables without naming the file to be imported? I have a folder where all .DBF files have DWxxxxx.DBF format. Can I create a DTS job to copy all those files into a table? TIA, Joe

Is there a way to grab all the file names in a directory and populating a SQL table with them? I am trying to create 2 different jobs: 1) I want to get a list of all my backup files in my directory and move all files over one week old to an archive folder. 2) I want to grab zip files that...