Which SQL SERVER 2000 edition is best for HQ
As you know SQL Server 2000 Standard Edition and SQL Server 2000 Enterprise
Edition are supported on Windows Server 2003.
Now Which SQL Server 2000 edition is recommended for HQ implementation
STANDARD OR ENTERPRISE ? If any of them, Y ?
I am running SQL SERVER 2000 Engine on WIN Server 2003 OS & HQ server is
seperated running on WIN XP Professional Edition. Are operating Systems
Depends on your organization's needs. RMS is not going to make use of
any SQL Server Enterprise features directly, but if you wanted to say
implement a fail-over cluster (minimum ...How do I insert Roman Numerals?
New to Word 2007 would someone please explain to me how to insert Roman
Numerlas in my document?
"ckj" <firstname.lastname@example.org> wrote in message
> New to Word 2007 would someone please explain to me how to insert Roman
> Numerlas in my document?
Just type them...
Type a number e.g. 21, select it and run the following macro
Dim oRng As Range
Set oRng = Selection.Range
oRng.Fields.Add oRng, 34, oRng.Text & " \*Roman"...Editing views on the activites page
I have stumbled upon the ability to edit views for activities by using the
viewmanger.aspx page and changing the object type code to the code for
I have made these changes and have published them using deployment manager
in a test environment, and they seem to be working great.
The question I have is why did Microsoft hide these pages. It is possible to
edit other objects (leads, opportunities, accounts, ect.) by just using the
standard interface. It seems like the may not be showing these pages for a
reason, but I have no idea why.
If anyone has any input on this i...Insert trigger
Looking for some advice on SQL 2005. I have a table that will usually be
populated by an SSIS package. I want to set the "loaddate" column to the
current time after a record is inserted. Should i do this via trigger or
should i just build a step in the SSIS package to update the column after the
If trigger is the way to go, what is the syntax to create the after insert
Thanks in advance.
You can create a default constraint on the table set to CURRENT_TIMESTAMP. That will handle the automatic date
assignment without any need for coding.
-...inserting hrs and minutes
I have a cell in my time card that displays total weekly time -ex-
"40:15" is there a way to make it more like this...40hrs,15mins
Message posted from http://www.ExcelForum.com
Use a custom format hh"hrs",mm"mins"
"-Brian-H- >" <<Brian-Hemail@example.com> wrote in message
> I have a cell in my time card that displays total weekly time -ex-
> "40:15" is there a way to make it more like this...40hrs,15mins ?
> ...Pressing Change Password -button in WIN XP causes reboot
I want to change my password.
I press Ctrl-Atl-Del buttons and then I press Change Password-button and
WIN XP Pro computer reboots immediately!
I can´t change my password.
...Editing an External Web Query Import
I've currently got an Excel sheet with a table I've imported from a
web page I've created. This was done using the Data->Import External
Data->New Web Query. The page itself is a CGI script and as such
takes arguments in the address.
I was wondering if anyone knows how I can alter that URL from a cell
in Excel. Specifically I want to be able to change the hostname in a
cell in Excel and the corresponding ?hostname='blah' to change.
Any ideas would be greatly appreciated.
Data>get external data>run saved query. Right click the query and select
edi...Need help editing budget
In many catagories of my budget, the budgeted amount
includes a billed amount rather than only what I
budgeted. When I go to edit budget, I highlight the area
I want to change and a copy of the reoccuring bill shows
up. What am I doing wrong?
...insert an interactive excel file into word web page
I'm trying to insert a excel file into a word document with text, and then
save it was as a web page, but I want to keep the excel part interactive.
...Insert | File > Attachmnet-Button Drop Down ;What is the difference between Insert and Insert As Attachmnet
re: "Outlook2003, File-Insert-Options"
On making new-email with Attachment-File(s),
File Menu | Insert | File >>> (Brows and select File to insert )
then we can see the button "Insert", and write side
Drop Down Arrow lower-right side of Dialog Box;
If it clicked,
we can see three options as follows:
Insert as text
Insert as Attachment
I can not recognize/understand the difference
between "Insert" and "Insert as Attachment"
What is the difference between Insert and Insert As Attachment ?
I would appreciate y...Inserting Hyperlinks in a Protected Sheet
I run Excel 2000 and I have a protected worksheet that I share wit
users in my organisation. I want to allow the insertion of a hyperlin
to a specific file type within a specified directory on our server.
1.Protection on disables the insert hyperlink command. Can this b
overcome with worksheet activate code?
2.Can I limit the types of files (preferably by requiring the file t
meet a mask format eg "z-*.xls")?
3.Can I limit the directory that can be linked, by referring to
pathname stored in a cell on the active sheet?
Would appreciate your suggestions.
Thanks S...how to automatically load my function after the ListBox have shown on the screen?
i generate a project based on a dialog. and i insert a ListBox. i need to init some instruments in my programm, so i want to display the init process in the Listbox. how can i load the init function automatically but not spring the function by mouse or keyboard clicking after the Listbox have shown on the screen?
You can populate the listbox in OnInitDialog. This is called before the
dialog is shown.
Ajay Kalra [MVP - VC++]
"mark" <firstname.lastname@example.org> wrote in message
> i generate a proje...Change position of Navigation Buttons?
Is it possible to change the position of the inbuilt navigation buttons? (And
if so, how??) Or can they only be displayed in the bottom left of a form?
On Sun, 3 Feb 2008 10:30:00 -0800, CW wrote:
> Is it possible to change the position of the inbuilt navigation buttons? (And
> if so, how??) Or can they only be displayed in the bottom left of a form?
> Many thanks
As far as I know they can only be displayed at the lower left corner
of the form.
However, you can set the form's Navigation Button property to no, and
then add your own command buttons to the...Editing Views
While it is possible to edit the views for some entities, it has come to my
attention that editing views suh as 'history' within an entity is not
possible (or at least easily accessible), and doesnt simply follow the format
as laid out by the user for 'Activities'. Does anyone know a way to edit
this view, as I would like to add some fields to this view.
Also, is there any way to change the status of some read-only entities so
that one can alter the display name of attributes. This would also help in
regards to views, as some of our employees wish for attributes to have...Insert with a where condition
Hi, sql 2005
I have an insert statement that is ignoring the where condition. That is, I
want to insert records when they do not already exist in the destination
INSERT INTO dbo.tblmnuGroupPerm
FROM dbo.locmnuTabFunction AS ltf
ltf.mtfID NOT IN
FROM dbo.tblmnuGroupPerm AS gp
Any ideas or recommendations appreciated :-)
It's OK... <oops "redFace">I did not correctly se...Auto-Editing
Word 2003 has a very annoying default. It assumes too much! If I reformat a
few words in a document, it changes the entire document to that formatting.
Grr-rrr-r! I have to constantly press undo to get what I want. I know
there's a feature that's causing this annoyance but I can't find it to turn
it off! Can anyone help, please?
Microsoft Word MVP
"Connie Martin" <ConnieMartin@discussions.microsoft.com> wrote in message
news:CD959D82-F81B-4A9D-993E-73...Declare Function issue with Vista
I distribute a standard DLL with my Excel Add-In, install it to
<windir>\System32, and reference it from the Add-In with Declare
Function. That works fine with Windows XP, but on Vista, if the user
doesn't right-click the setup file and choose Run As Administrator,
the DLL doesn't get copied.
I could copy it to the Add-In's folder instead, and then there would
be no problem copying the DLL to that folder, but since the user can
customize the install folder during setup, I can't hardcode the folder
in the Declare Function statement.
I could add the user's ...Insert
I want to overtype in a Publisher text box. I find I can only insert. The
"insert" key doesn't do anything.
...RMS Stalls when close cash drawer button is pressed
When we click the close cash drawer button after a transaction RMS appears to
stall, nothing happens for about 30seconds. Then it starts working again. We
have had this problem from the beginning but it appears to be getting to a
point where it happens with nearly every transaction. The thing is that you
can type, nothting appears on the screen but you can login in and begin
scanning, it eventually catches up to where you are. Has anybody else
experienced this problem. Or does anyone have a suggestion to what i can do
to fix it.
plenty of memory??
"Tackeyon" <Tackeyon@di...how to insert data in a table
I am creating an access database in which I want to insert data in
already created table.
Vikky <email@example.com> wrote in news:1194124711.012302.269990
> Hi Exprets;
> I am creating an access database in which I want to insert data in
> already created table.
> Kindly help.
Data from where? Do you want to import it from excel, from a text
file, copy it from another table or type it in manually?
PA is y I've altere...How do you insert page numbers larger than 1000?
I have my purchase orders set up as a Publisher document. When our
organization upgraded from Publisher 2000 to Publisher 2002, the new version
set parameters on the page numbers. This was one of those things that worked
just fine in the previous version... Does anyone know how to turn it off or
Hi mregen (firstname.lastname@example.org),
in the newsgroups
|| I have my purchase orders set up as a Publisher document. When our
|| organization upgraded from Publisher 2000 to Publisher 2002, the new
|| version set parameters on the page numbers. This was one of those...add note button to vendor id field in payables transaction entry
I'd like to be able to write a note attached to the vendor id, and have it
accessible from the Payables Transaction Entry window. There is currently no
note button next to the Vendor ID field.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.micros...Crystal Enhanced Edition
When I tried to install the enhanced edition, I got the message "setup has
detected that you have 9.2.0 installed".
I now have the 9.2.2 upgrade from Crystal. Do I install on the server or
client? If I install on the client do I also install the enhanced edition on
the client as well?
Thanks for your help
Install on client
Install enhancement on Client
"dpsman" <email@example.com> wrote in message
> When I tried to install the enhanced edition, I got the message "setup has...insert downloads into power point
i downloaded an application called "BioDigital Simulator" of an animated
cleft lip/palate surgery and need it put into my power point presentation,
but can't fiugre out how to do so.... very frustrating...
What kind of file is this application? Is it a video? If so, what kind?
MPEG? AVI? MOV? Or is it an EXE file? Something else?
Which version of PPT are you using?
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2010? http://www.echosvoice.com/2010.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover...Insert dataset to another database
I'm posting this to this group also since it pertains to queries, primarily.
Using VB6/ADO, I'm thinking I can create a recordset and insert it into
another table in a different Jet database, all within the execution of a
single query. But, I can't seem to get it to work, even in an experiment in
My sql in Access 2K:
SELECT D.lorder as Ord, A.Lorder
FROM [;Database = C:\MyDocuments\Acc2K\Wrk.mdb].OrdersData as A INNER JOIN
[;Database = C:\Access\Work\Sales06.mdb].Detl1 as D On D.Lorder = a.lorder
WHERE ((D.fg)= 'MXX-NC' Or (D.fg)= 'MXX.NC')...