Viewing 15 posts - 1 through 15 (of 49 total)
I figured it out. I had to add a Reference (under Tools) to "Microsoft ActiveX Data Objects". Now I'm troubleshooting the connection string. But I'm sure this...
January 12, 2012 at 5:42 pm
I was not able to get this problem resolved. I got Microsoft Support involved and eventually they refunded my money because they couldn't help me either.
So good luck.
June 3, 2010 at 2:35 pm
OK, a little time with BOL and I ran this.
exec sp_repldone @xactid=NULL, @xact_seqno=NULL, @numtrans=0, @time=0, @reset=1
Then I was able to back up and shrink the trans log. ...
April 7, 2010 at 5:38 pm
I have run dbcc opentran several times over several minutes with the same results:
Transaction information for database 'WMS'.
Replicated Transaction Information:
Oldest distributed LSN...
April 7, 2010 at 5:07 pm
I was able to make the max size of the trans log file bigger by 10 GB to give me some room to breathe.
Now I'm working on the...
April 7, 2010 at 4:14 pm
You are right, replication is the problem. But I cannot delete the Publication because of the "transaction log is full" error message. Any ideas?
April 7, 2010 at 2:56 pm
I found a little more information that might help. This is what's in my Output window even though I did not cancel the execution. I'm still in Debug...
March 5, 2009 at 4:54 pm
Thanks anyways for taking an interest.
December 29, 2008 at 5:00 pm
There is no preview, it just prints the reports directly from the program. Here's the code in my ReportPrinter.vb class:
Imports System.IO
Imports System.Drawing
Imports System.Drawing.Imaging
Imports System.Drawing.Printing
Imports System.Drawing.Graphics
Imports System.Runtime.InteropServices
Public Class ReportPrinter
...
December 29, 2008 at 4:37 pm
Has anything changed in the .NET application? Nope.
Is the printer the same? Yes.
Does this happen with all printers? Yes.
What happens if you access the reports directly using...
December 29, 2008 at 3:57 pm
We're running SQL 2005 64-bit and I have never been able to get the "Import" function to work with Excel files. I have resigned myself to importing them into...
November 16, 2007 at 9:41 am
I figured it out:
SELECT CODE, ROW_NUMBER() OVER(PARTITION BY 1 ORDER BY CODE) AS [ROWNUMBER] FROM D3CUSTOMERS
But I am glad to hear you didn't see it in BOL either. At least...
August 6, 2007 at 5:10 pm
Paul,
Are you sure you are right-clicking on the database name (not the table name)?
December 1, 2006 at 1:53 pm
If you're just having a hard time because you're working on 2005 then here's the secret... Right-click on the database name, choose Tasks, and then Import Data.
December 1, 2006 at 12:40 pm
Viewing 15 posts - 1 through 15 (of 49 total)