Recent content by kramers

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