Search results for query: *

The original database was set up without a translog after attachement there is a translog which I have not yet removed. The difference seems to be a full day (looks suspiciously like since its nightly backup).

The Backup on the right-click menu. Unfortunately this database was set up without a trans log.

Okay I had two versions of a database. One was the detached database file (.mdf), the other was a backup file (.bak). For Both were done at the same time, but the Bak file seems to not have the latest updates. Is there anything I can do to figure out what transactions have occured on the one one...

The problem seems to be a network there's a goofy switch or firewall in the way.

I have a Windows 2003 Server with SQL Server 2000 installed. On the server itself I can create a DSN to connect to the localhost, but on any other machine I can't. I tried to telnet to 1433 from the command prompt but get no connection.

Thanks. That's exactly what I was talking about.

I'm afraid I didn't explain myself very well. Let me try this again. I have a database of information about one object. That object has about 65 attributes. I could create one table and store all 65 items at once in a single insert statement or I could create about 10 or 11 tables and store...

I need to store about 65 fields. I'm wondering whether it'll be faster to do about 11 insert queries of about 6 fields or one insert query of about 65?

No groups just 21 columns with names in each in the details area and that's it.

The same well Excel does it. :(

So there's no way to make a report that's wider than a sheet of paper and have it just print to a second sheet? That's absolutely stupid.

This is for actual printing.

I have a report that is very wide (about 2 pages in landscape for an 8x11 sheet). Is there any way I can make this report work in CR XI without having two different files?

Well I've got Crystal 6, 8, and 10 and a SQL 2000 Server. Actually I was looking to execute it from a batch file, or DOS command prompt, but I think I'm going to have to write a VB App. Eventually the task is going to have to be encapsulated into a stored procedure so that's another issue and...

I have a report that will fetch from my database all the parts in a particular product and it has an argument say a serial number. I want to print or generate a PDF from this report using the serial number automatically. If I know the serial number, is there any way for me to execute something...

This is what I did in the event anyone should care. :) CREATE PROCEDURE [Print Report] (@filename VARCHAR(400)) AS Begin Declare @command varchar(400) set @command = 'master..xp_cmdshell ''"c:\Program Files\Adobe\Acrobat 7.0\Reader\acrord32.exe" /p /h ' + @filename + '''' exec (@command) end

Is it possible to use a stored procedure to launch another program? Specifically I'm trying to use a stored procedure to open/print a Crystal Reports report.

I have a question. In my workplace we have rather small mailboxes, and sometimes a mail message that is supposed to be sent by cfmail will bounce back because someone's mailbox is full. Does anyone know of a way that I can either query the mail server to verify a user's mailbox is not over...

recordcount is undefined in sp. New thought: I hardcoded the stored procedure to run in cfquery tags like so. <cfquery datasource="soe" name="query"> execute sp_name 'argument' </cfquery> it tells me it executes with no results, but when I copy the text and run it in native sql it works...

That didn't work. It's not so much that Coldfusion is having difficulty dereferencing the resultset. It's that the recordcount is always zero.