Search results for query: *

In some of the documentation for MOSS 2007 there is talk about Managing Site Collection Owners. I do not see this option anywhere in Central Admin. I can Manage Site collection Administrators. Let's say for example I want to setup the "Site Use Comfirmation and Deletion" which sends...

Hi, I just installed SQL Developer and connected to the DB. I clicked on the plus sign next to Tables, Views, Indexes, etc. under the connection but I don't any db tables or anything. I can enter and run Query's and return results. Like I say I am really new to SQL developer. Is there something...

Hi, I am looking for an opinion here. I will soon be accessing a SQL and Oracle Databases. I am not sure how large they are but I do know that some of the existing reports are built on queries that can take several minutes to run. I will only have read access to the DB's, meaning I can't create...

I am looking in my ACT 2000 DB for Title CONTAINS CTO and I get a bunch of Directors. Doh. See direCTOrs contains CTO. so I want to try and search upper case CTO only. Is there a way to search for upper case only either on 2000 or 2008 (were upgrading at some point)? Does anyone use any...

We have several developers working on the same VB code. When one user makes a line change VB will automatically change several variable names. For example moduleName becomes ModuleName or vice versa. From what I understand VB will find the first variable with that name and change the case on...

I have a table that, through a trigger on another table, is being writen to constantly by users, I want to rename it and then recreate the table because it is getting too big. When I say big I mean millions of records. Background There was a maintenenance script writen to be run nightly to keep...

I have 2 tables one table lists a job number and the version JOBS Job_num Version E-1 1.0 E-2 1.0 E-4 2.0 And a work log table WORK WorkInHours Description 1 E-1 Did work 2 E-4 Did more work 1 E-2 Did even more...

I trying to get a count from a number of tables and use that count as a variable in MS SQL. I have to get the table names from sysobjects so I am using an EXEC. here's what I want but this won't work. I have let out all the loops and other stuff. DECLARE @query varchar(100) DECLARE @counter...

I am trying to install Cisco VPN but there is a problem with Netgear Prosafe Client. When I try to uninstall it I get a message "The installation support file could not be installed. The system cannot find the specified file." I don't have the installation disks and I have no idea how to...

I have a table col1 col2 one mandatory two not mandatory three not mandatory four not mandatory five mandatory I am trying to write a trigger that will prevent uses from deleting or updating the mandatory records (rows 1 and 5). Something like If you update or...

I have table of usernames and a second table of options for the user. I want to display one row for each user and all his options. UserTable Users Level Bob 1 Mark 2 Optionstable Option Level menu1 1 menu2 1 menu3 1 menu4 2 The result should look like this Bob...

is it posible to bind a record set item to a control in Javascript similar to asp.net. An example would be connection to a dataset using ado and putting the record set into a form with name and address fields and then navigating back and forth using movenext and moveprevious buttons.

I am looking at creating an application that doesn't install anything (or atleast appear to) on the client. The existing VB6 application installs on the client and connects to the Access DB that can either sit on the CD or be copied to the users hard drive. I want to update this program to .NET...

I am simply trying to write a line of text to a file testfile.txt and put tabs in the line. How do I do this? sample that doesn't work a.Writeline("Add a tab between here " & "\t" & "and here")

I have a field (PartNumber) in the talbe Parts that looks like this A1234 B2345 12345 234357 I want to sort the table by PartNumber but have the parts with Letters sorted first. Example would be to sort A-Z then 0-9.

I am trying to format a text string retrieved from a recordset. I want to turn A12345678911 B123456 C1234 to A123-4567-8911 B123-456 C123-4 I Tried format(rs.Fields(1), @@@@-@@@@-@@@@) but I get A123-4567-8911 - B12-3456 - C-1234 Not exactly what I want

I was given a new text file to import into a SQL database for a client. I thought it was all garbled then I realized it was in ebcdic 3780 format. All I know about cobol is it exists. I really have no idea what to do with this data. It contains packed decimal data. I have tried using something...

I am trying to produce a report that has three comlumns. The issue I have is I want to put a border around every group of five records. The records aren't grouped in any particular way it's just they are easier to read if there is not a border around each record. I have tried to put a...

I can't remember if it is possible to put a line break in a label on a report. I know there are lots aways around it (i.e. creating 2 labels one on top of each other to simulate a break) but I thought there was a simple way to do it but I can't remember what it is.

I am starting to design a new project. The project will take raw data and create a book from it. The book will have TOC, Index, sections, page numbers and everything else a book would have. I have created these books before but only to the point where I format the data where composition program...