Viewing 14 posts - 151 through 164 (of 164 total)
When I use the UNION, I'm getting a truncated JobList field (truncated at 255), yet len(JobList) yields the
correct length.
If I create a new query using just one of the...
October 19, 2005 at 8:54 am
Worked just fine. I did have the orphaned dbo problem, but was able to change db owner for these.
Thanks!
October 10, 2005 at 9:28 am
I've got an identical database (for dba use) in 6 SQL Server 2000 servers, so there is no difference in data type; so I don't think that's an issue.
Any other...
October 6, 2005 at 10:19 am
Access doesn't have a varchar(8000).
October 6, 2005 at 9:30 am
If you'd like, but it's not really relevant.
I've tested a little and found that the problem is I'm using a UNION query in Access. I'm pulling data from 6 SQL...
October 6, 2005 at 9:17 am
That column is a comma-delimited list created by a user-defined function that is included in a view. This SQL Server view will show the entire column (if you expand the...
October 6, 2005 at 8:46 am
OK, it was a domain issue. She's on a different domain, but they're going to have her switched to the other.
I also found that you cannot have 2 logins in...
September 29, 2005 at 10:54 am
We are thinking it may be an Active Directory issue.. she is on a different domain.
I'm also trying to get her MDAC version info using Microsoft's MDAC checker.
September 29, 2005 at 9:03 am
I agree with ghughes.
Sounds like you're using an ASP upload component to allow users to upload from the browser? Usually you're better off storing files in a directory, and then...
September 27, 2005 at 8:50 am
Once I got around the following error:
Syntax error converting datetime from character string.
I could see that this is useful.
September 27, 2005 at 8:22 am
I failed to mention that I've been on the job here for about 3 weeks now. The 2 developers that were left have quit due to high turnover. My manager...
September 23, 2005 at 1:25 pm
Rudy, I like your answer, but could I start at the bottom of your list, and work my way back up?
;o)
September 22, 2005 at 2:47 pm
Will he be able to look at maintenance plans, logs, and the like with the DATAREADER role? Basically, he needs to be able to see (from his workstation) that I'm...
September 22, 2005 at 8:50 am
Viewing 14 posts - 151 through 164 (of 164 total)