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

My DBA believes this is a confriguration problem. I couldn't tell you either way. Still looking for answers

Connecting as 'owner'? I only have read access to the tables I am not the DBA. You're telling me this is a permission problem?? I was hoping this was some sort of weird configuration thing that SQL Developer needs to enable viewing of the table scheme.

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

I can't access the linked file. Can you re link it?

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

So there is no checkbox setting in VB that says something like: Arbitrarily rename variable [] or Ask before renaming variables [] Actually I wouldn't even care if VB renamed the variables if it was consistent. Everyone is using the same setup and code why does it decide for one developer to...

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

The good new is that the query ran great. But it took 33 minutes to return 11,000 rows. thankfully, although neccessary, I only need to run it infrequently.

Thansk, that did it George. If you could see me you would have seen me jump out of my seat. Thanks to Borislav and Denis too. I guess it's all in asking the right question.

Doesn't Denis assume the job number is 3 characters. I mentioned there are thousands of jobs and therefore it can't be 3 characters. Is there a function that will dump everything after the first space?

Thanks guys. I know it's bad design but I am converting from VSS and a corporate help desk to SVN and JIRA. However, I'll have Microsoft, Tortise, and Atlassian better cordinate there table structures. There are thousands of Jobs. however the sturcture of the description is always the same...

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

Thanks Denis. Worked perfectly.

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

Actually I think I have found the answer on http://www.tek-tips.com/viewthread.cfm?qid=1089209