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

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

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

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

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

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

Is there a way to import an XML file into a SQL2000 table? I can only find information on how to retrieve the XML data from a query. I have tried: DECLARE @idoc int DECLARE @doc varchar(1000) SET @doc ='E:\XmlFiles\ENICOpen.xml' --Create an internal representation of the XML document. EXEC...

Hi all, I am trying to sequence rows in a table. this is for different policy#'s I am using policy#,effectiveDate as my critiria to start my numbering. The problem is there are no unique Identifiers in this table I have 6 rows that are exact dupes. when I run a normal cursor, it updates...

I have an application that runs an encrypted SP. it is failing due to a data type. Is there a way for me to unEncrypt the Procedure so I can see where it is failing? TIA, Joe

Hi All, I am having an issue restoring an 80GIG database. it gets about 3/4 of the way thru before choking. I moved the BU file from my Production server to the Dev server I am rebuilding. I am getting an error I never saw before: "Nonrecoverable I/O error occurred on file '???'. RESTORE...

Hi All, I have created a trace using a script to run to a 1MB file, with rollover option turned on. Every few minutes I poll the folder to see if it was released yet and I copy it to a table for later auditing. Is there a way to specify the file # at the begining? The reason I am asking is...

Hi All, I have a trace setup to track all Admin events. This morning I noticed tht my SQL agant dropped and created a table thru a DTS package. Can anyone tell me what table holds the DTS package ID, and also what column in a trace file holds this ID? Thanks, Joe

Hi all, Is there and easy way to move a DTS package from my dev server to my production server? I can copy it by using the save as, but I must remove it from the prod before copying it over. Is there an easier way to replace the exsisting one? Thanks, Joe