laying out iscsi drives for SQL
Is there a best practice for laying out a disk structure on a Windows Target
server for an SQL server initiator's drives? Point being, when configuring
the drives on the iSCSI Host, you format them as the VHD, then should you
format the drives the same way as on the initiator, in this case an 2008 SQL
server? We have formatted the drives on the iSCSI host with default settings,
and then on the initiator, our SQL server, we format the drives with a 64K
allocation size. We are trying to determine the optimal size of formatting
Should both servers’ drives be formatt...Leave mail on server?
I know the setting is there somewhere, I just can't find it. I want to tell
Outlook not to delete email from the server on download. Could someone
please tell me where this option is?
Thanks in advance... Bob
"Bob Newman" <email@example.com> wrote in message
> Outlook 2007
> I know the setting is there somewhere, I just can't find it. I want to
> tell Outlook not to delete email from the server on download. Could
> someone please tell me where this option is?
> Thanks in advance... B...OWA question
I�m using Exchange 5.5 with SP4 on Windows 2000 Server.
I want to install OWA server on Windows 2000 Server, I have IIS on it and
install the component of OWA from the Exchange disk.
I have put (for meantime) the OWA server in the internal network.
When I have trying to get the OWA by http://localhost/exchange and also from
other client I have got error message:
�The page cannot display-
a.. Error Type:
Microsoft VBScript runtime (0x800A01A8)
Object required: 'Application(...)'
/exchange/USA/logon.asp, line 12
b.. Browser Type:
Mozilla/4.0 (compatible; MSIE 6...Userform question 12-24-09
Can anybody explain the differences between
showing/loading a userform along with hiding/unloading
I'm guessing that a "load" will create the form in
memory but it remains non-visible?? Does that
mean that a call of "Userform1.Show" loads it
in memory AND makes it visible??
Show : Calls the userform initialize function the first time and not
afterwards and displays the userform
Load : Is the same as show but doesn't display the userform.
Hide : Exits the userform and keeps it in memory so the next time it is
Show/Load is perfor...Help in SQL statement
I would like to know if there Sql Query to convert the quantities of Parent
item to be Single item , i would explain it with an example
Itemlookupcode is 123456 and Qty 1
Parent item (outer pack of single item) like 6 cans of cola drink forms a
pack which can be sold as single as well as pack item
Itemlookupcode 123456-06 Qty 2
I need an sql query to produce result like 123456 QTY = 13 and 123456-06 Qty
Formula = Qty of Single item + Number of pieces in a single pack * Qty of
it would be great help that if it would be possible in sql
...Autoreply from server
I have a mailbox for my organization that autoreply to every mail it
recieves. This is working good if I send the mail directly to the
email-adress defined on the user object. I have also a lot of mailgroups
that the "user" is member of (distrubution groups) but when I send mail to
the groups the serverreply doesn't work.
Is this by design or do I need to do some coding to get this working ?
Is it also possible to include the original message in the serverreply (have
the server reply with) ?
...How do I change the default paste settings in Word 2008?
Operating System: Mac OS X 10.5 (Leopard)
Hi there - <br><br>I need to paste everything as unformatted text. Is incredibly time consuming to select Paste Special and then select unformatted text. Can someone help explain how I can change it to a keyboard command or something that makes it more efficient for me to paste unformatted text? <br><br>Thanks!
Unfortunately there is no available setting for doing so. The only option is
an Apple Script for the purpose but I'm afraid I haven't held on to a copy
of it. You may be able to dig it out...SQL IN
Using ASP.NET, SQL SVR Express 2008
I want to use IN to select records that have one of a list of values like
SELECT * FROM MyTable WHERE MyField IN ("Value1","Value2","Value3")
MyField is a nvarchar(MAX)
My query has a palceholder for the parameter, so it looks like this:
SELECT * FROM MyTable WHERE MyField IN (@MyList)
I create my command object ans set the parameter:
where myList = "Value1,Value2,Value3"
I get no values returned even though ther...all new and existing db's say "ms jet db engine stopped the proces
I've read all the posts regarding this error "The Microsoft Jet database
engine stopped the process because you and another user are attempting to
change the same data at the same time." I'm getting this message every time I
try to open any new or existing MS Access database and they will not open.
I've had this message before as described by others, but this is not an SQL
back end table with a null or query, form, or crash problem. One of our
desktop techs found a solution, but works for another company now. Anyone
else have a solution? I have several desktop...Distribution List Question #6
I have set up a distribution list in Exchange 2003. The list contain
user1, user2, and user3. When user1 responds to the group, I would
like it to go to user2 and user3, but user1 should not receive a copy
of the message.
Is this possible with Exchange? If not, is it possible any other way
without buying some more expensive software?
That is the way groups work. Why is this such an issue out of interest?
<Matthew.K.Swanson@gmail.com> wrote in message
>I have set up a distribution list in Exchange 2003. The l...MSDE or SQL Personal or SQL Developer? or SQL Workstation?
Hi, which one is better for personal non-server computer? MSDE? SQL Personal?
SQL Developer? SQL Workstation?
It depends on what edition of GP you are going to run. If you are going to
use Professional, you need to go with SQL Server developer, assuming you are
installing on a non-server OS.
> Hi, which one is better for personal non-server computer? MSDE? SQL Personal?
> SQL Developer? SQL Workstation?
> Thank you.
Is the function of SQL Developer the same as Enterprise edition?
How about personal edition? Can it be used for GP Pro?
Can dev...eConnect and Trade Discount question
I'm currently using eConnect to insert SOP Transactions. All is going well
except for the insertion of Trade Discounts. When I send the orders to
GreatPlains I do not know the actual pricing so I have used the field
"DEFPRICING" (default Pricing) and set it to 1 or to default the price in.
My problem is I know the Trade Discount percent for each order but I do not
know the actual amount since I do not know the actual numbers till tne
transaction is over.
Can anyone tell me if there is a way to flag that the Trade Discount is a
percent and not an amount?
Also I have pla...CRM Uninstall and move to new server
Not realizing that CRM was not compatible with windows 2003 server I
built a windows 2003 CRM machine.
As it does not work properly I am moving it to a new server. Currently
we have no data in the CRM system so no concerns of loosing
However i am wanting this to go as smoothly as possible.
Please comment on the following steps.
1. Uninstall CRM from server
2. Delete databases and OU (IS THIS STEP NEEDED)
3. Build new server with same name
4. Reinstall CRM.
Any assistance would be greatly appreciated.
You should be able to install MSCRM on the new server...Communicating with a Unix server
Does anyone know how to code communications with a Unix server? I want to be
able to send a command that will execute a program to a Unix server from my
Windows C# program. Also, I would like to be able to send and receive
messages from the Unix server. The help in Visual Studio just doesn't give
me enough to go on.
I need some direction on how to go about doing this and will appreciate any
On 4/23/2010 11:18 PM, Parrot wrote:
> Does anyone know how to code communications with a Unix server? I want to be
> able to send a command that will execute a program to...SRID values for Spatial Data Tyoes in SQL Server 2008
I've been investigating spatial data types in SQL Server 2008 for my
It appears only certain coordinate systems are supported by SQL Server 2008.
How do I request that the missing coordinate systems for my country (New
Zealand) get added?
More details below:
For the geometry data type:
None of the local projected coordinate systems for NZ are supported in SQL
Server 2008. These supported EPSG codes (SRIDs) are stored in the
sys.spatial_reference_systems system view in a SQL Server 2008 DB. (NZ
projected EPSG codes are 27200 (New Zealand Map...Access to SQL Server (?) conversion?
I currently have a single user Access database with
many queries, forms, reports, VBA, etc.. I need to
expand on it to allow multiple user access, with
2-3 with read/write and maybe 6 read only.
Not knowing much on SQL Server, what would be involved
in porting the server side and the client side?
(I'm hoping I can keep most of the current access stuff).
Would it be basically the same amount of work if
I went to something like MySQL?
Why? As in "why would you need to migrate to SQL-Server?"
Access would be quite capable of handling that many simultaneous users.
You cou...CRM 1.2 and Windows Server 2003 SP1
Has anyone tried Service Pack 1 for 2003 Server with CRM 1.2.
Is is ok to apply? Or are there some issues that need to be addressed first?
I am looking for the same info
>Has anyone tried Service Pack 1 for 2003 Server with CRM
>Is is ok to apply? Or are there some issues that need to
be addressed first?
I have updated my server and now i get an error when opening CRM :
HTTP 500 - Internal server error
I'm investigating why
"Ken Foster&...Sql error: Error # 2147217871 Time out expired.
I'm going to continue searching the web on this, but figured I'd ask if
anybody has come across this error in RMS?
"it Says Error # 2147217871 Time out expired. (Source: Microsoft OLE
provider for SQL server Error in Post Transaction Entries)
That comes up after about five minutes of nothing. Then hit OK and Run-time
Error pops up. Then hit OK and Every thing shuts down and have to restart.
At this point the sale does not seem to be recorded in all areas. "
Thanks for any assistance in advance, again, I'll continue searching....
If you are using M...Query question 04-05-07
Employee No Work Code No of hours Start Value
2 89 2
2 92 1
2 92 1
2 92 2
Here is my query and the results I am trying to get are:
Work Code 89 is Earned
Work Code 92 is Taken
The start value is 4 – so I would need to add work code 89 and then minus 92
and then the result is 2. How would I set up a query?
...social security number in SQL Reporting Services
Every piece of thorough research that I have done shows that the following
is the correct formula to use to format a 9-character string field as a
Social Security Number with hyphens from GP, but SQL Reporting Services does
not like it for some reason. It is not displaying the last 4 digits of the
social. Please tell me why:
=Left(Fields!USERDEF1.Value,3) &"-"& Mid(Fields!USERDEF1.Value,4,2) &"-"&
Disregard....I figured it out:
&quo...can not connect to new sql 2008 server?
Just installed a new SQL2008 machine.. Trying to connect to it from a
Windows 7 PC (both machines are x64)
I can ping the sql machine from the win7 machine, but when I put in the
server name into the sql management studio (on the win7 machine) it won't
connect for some reason(using either named pipes or tcp). Most of the
message are to do with the server not responding etc...
I have checked the config on the server, to allow both of these protocols
What else is there ???????
is it a named instance? If so, is the SQL Browser service running?
...Question about Money08
As you may discern from my nickname, I am older than dirt. I retired 3
years ago when I turned 62. I have used Microsoft Money forever,
updating every year, (except for the 05 version,) and the Lifetime
planner for many years. We are fairly confident in our "Results"
except for a glitch which insists on projecting that my wife will get
a "spousal" Social Security benefit, at age 62, (as I have done,)
rather than wait until she turns 66 and can collects the full amount
she would be entitled to on her own. We were told by someone at
Microsoft several years ago, that this was...T-SQL to PL-SQL
Hello, can sombody help me to translate that script in oracle?
DECLARE @ID INT
DECLARE CURSEURS_JOBS CURSOR FOR
SELECT REF_RE_JOB_POSTING_ID FROM DM_RE_JOB_POSTING
FETCH CURSEURS_JOBS INTO @ID
WHILE @@FETCH_STATUS = 0
update DM_RE_JOB_POSTING set publishedI = (select CASE
WHEN rjpd.internal = 1 and (rjp.internal_external in ('B','I'))
WHEN rjpd.start_date is null and rjpd.end_date is not null and
rjpd.end_date >= getdate()
WHEN rjpd.start_date is...IM with SQL 2000 to SQL 2005
Can IM be used to take data from an SQL 2000 database for use with GP 8.0
running on SQL 2005.
Basilcy I need to extract order information from a website running on SQL
2000 and insert in in GP 8.0
Yes, you can use SQL Server 2000 databases as a data source for Integration
Manager with GP 8 running on SQL 2000/2005.
Charles Allen, MVP
> Can IM be used to take data from an SQL 2000 database for use with GP 8.0
> running on SQL 2005.
> Basilcy I need to extract order information from a website running on SQL
> 2...Driver failure forces reinstall of Server 2008
I have encountered an annoying problem several times while debugging my
storport driver. My system is booted from a standard SATA driver on separate
HBA. However if my driver fails to install (BSOD) or crashes while debugging,
the system won't recover during a reboot.
I see the typical incomplete shutdown message but selecting "boot normally"
or "last known good menu" don't allow me to proceed. Instead there is a
notice that a critical component (my driver) has a problem that prevents
windows from booting. Since my driver is not required for booting, ...