Search results for query: *

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

Hi all, I have many DTS jobs that copy files to my SQL server and import them into SQL tables. Is there a way to get a list of all jobs and what files they are accessing? TIA, Joe

Hi All, I setup a transation replication. Everything seemed to go very smoothly when I set it up. When my snapshot ran it failed due to this error: "The process could not create file '\\RP3\MSSQL\MSSQL\REPLDATA\unc'." Access denied. can someone tell me what account runs the Repl agent and...

Thanks, Doesn't reseed only deal with new rows coming into the table? I want to update the present rows back to 1 thru blah, right now my table starts at 7,8,9,23,45,56,57,58,59... Thanks again

I have a table with an Identity column. When rows are deleted the Sequence goes out of whack, Is there a way to restart the numbering at 1 and go to whatever? TIA, Joe

Thanks all! I have created a DTS package that has an ActiveX script using FSO to import the file into a global variable then I created a simple SP that loads a table from the variable. this all works great. Thank again for all the input. I would never have gotten it without all your help. Joe