Search results for query: *

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

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.

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?

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?

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

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

I have a query getting a list of procedures and arguments from a table. Using the results I'm trying to run a series of stored procedures for example this comes back from the query: sp='sp_gpa' argument='2.5', sp='sp_sex' argument='m' and in the page I have the following code: <cfoutput>...

I have a DSN defined on my webserver, but now what? How do I connect to it? If it's important I'm connecting to a sybase database.

I'm having the most difficult time accomplishing a crosstab query. At the moment I have results coming back like this ID# LastName FirstName Code Number 1 Smith Steve CF 3 1 Smith Steve CON 1 4 Jones Walter CON 2 4 Jones Walter REF 1 I would like to...

I have a problem. On one page I have several items that will be discounted, they are being passed in form variables to the next page where the query is being executed. So I have form variables that look like this form.itemid1=1, form.itemdiscount1=40, formitemid2=17, form.itemdiscount2=70, etc...