Hi - I was wondering if someone can advise please. Our organisation uses a ERP systems which has 4000 Relations tables. There is a discussions on creating a master database - where any changes to these tables are populated into Master database. I am worried about this approach - for example, there is no business logic and any changes gets sent to this MD, which is used for integration with other systems? I would have thought you use master database to bring in data from various systems rather than just duplicating one system into another.

The argument for creating a master database is so there is no need for peer to peer integration - I agree peer to peer is not good but thats what what BizTalk is there for. They want to use BizTalk to pull data from the ERP into Master Database and then use SSIS to push data out to other systems. I can't see why they can't they just use BizTalk to transform the data and push the data out. Their other argument if the ERP system ever goes cloud it is not possible to do a full extract (i.e, not delta extract) using SSIS - but the issue nobody even know if we will ever even go hosted solution for the ERP we have. Additionally, even in such a case if there is a good business case I am sure the cloud prvoide will let SSIS access directly to database on the hosted cloud. Do you agree? Can you give your inputs on the flaws with this approach or is it just me worrying?

Thank you.

I asked about my Confirmation Email not getting thru using gmail, aol, yahoo and outlook. These are 2 answers I received, but I am not a programmer..... Can someone help me?

Response 1 :
Sounds like spam filtering.
Have you got an SPF record setup for your email domain that shows the GoDaddy servers as acceptable senders? If not, this could be causing emails to go into junk folders or be blocked altogether on systems like Gmail, AOL, etc.
GoDaddy emails are likely fine as it sees the emails coming from their own servers

Response 2 :
"A" has already mentioned spam filtering as the likely cause and I tend to agree. One thing to bear in mind is how you're actually generating email. If you're just using the basic mail() functionality within PHP, then that often gets tagged as spam, because it's very easy to miss out valid headers. The email you send does then tend to look like it's been auto-generated by a script (aka SPAM).
When sending email from PHP, I would suggest you look at something like the PHPMailer library. It gives you a lot more config options and it may help to make your emails appear as 'more genuine' to the mail servers.

Can we make the macro first time I press it, to go from a1 to a102 and then after that it goes every 100 rows so next would be 202, 302 and so on.
Can you provide a macro to do the opposite? to go up 100 rows? and a macro to go to the top

Hi
I'd like to install tkinter in my Pycharm

I go to preferences and hit the + install button and there are a chunk of tkinter installs to consider.

Does it matter which one I choose?

Thanks

Hi,

Encountered this error "WARNING: The object has been corrupted, and it's in an inconsistent
state. The following validation errors happened:
WARNING: The primary SMTP address, "SMTP:", is not valid.

When moving DB1 to new DB4 for white space cleanup. See attached error as well. Ps advice. Tks

Troubleshoot:
1. Find user mailbox > Exchange 2010 Warming: The properties on this object have invalid data. If you click OK. Default values will be used instead and will save.
2. Click OK > E-Mail-Addresses > Tried to change to smrt.com.sg but with error. The primary SMTP address is not valid. Click OK
3. Observed user mailbox Last logged on by: empty, Total item: empty, Sizke (KB): empty.
4. Go ADSI Edit to edit
5. When back to user mailbox to unchecked Automatically update email addresses based on email address policy and error in below.
   at Microsoft.ManagementConsole.Internal.SnapInMessagePumpProxy.OnThreadException(Object sender, ThreadExceptionEventArgs e)
   at System.Windows.Forms.Application.ThreadContext.OnThreadException(Exception t)
   at System.Windows.Forms.Control.WndProcException(Exception e)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
   at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
   at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 …

I have another strange problem when trying to save related tables in C# , I keep on receiving an error as below

PersonID is not nullable


Where do I go wrong ???

When I detach the table to remain with a single table everything works okay, I can change data, delete and add new data without problem.

How do I get rid of this not null-able thing
RelatedTable.docx

I have a script, included, which will update statistics on more than 'DBO' and 'SYS' schemas of a database.
I would like to use this script on all databases using the MSFOREACHDB syntax, but can't figure it out.
Could someone add the MSFOREACHDB to my existing script?


SET NOCOUNT ON
GO

DECLARE updatestats CURSOR FOR
SELECT table_schema, table_name  
FROM information_schema.tables
   where TABLE_TYPE = 'BASE TABLE'
OPEN updatestats

DECLARE @tableSchema NVARCHAR(128)
DECLARE @tableName NVARCHAR(128)
DECLARE @Statement NVARCHAR(300)

FETCH NEXT FROM updatestats INTO @tableSchema, @tableName

WHILE (@@FETCH_STATUS = 0)
BEGIN
   PRINT N'UPDATING STATISTICS ' + '[' + @tableSchema + ']' + '.' + '[' + @tableName + ']'
   SET @Statement = 'UPDATE STATISTICS '  + '[' + @tableSchema + ']' + '.' + '[' + @tableName + ']' + '  WITH FULLSCAN'
   --PRINT @Statement
   EXEC sp_executesql @Statement
   FETCH NEXT FROM updatestats INTO @tableSchema, @tableName
END

CLOSE updatestats
DEALLOCATE updatestats
GO
SET NOCOUNT OFF
GO

I have a snippet from another piece of code, but it doesn't seem to cycle through each database -
DECLARE @Database VARCHAR(255)  
DECLARE @Table VARCHAR(255)  
DECLARE @cmd NVARCHAR(500)  
DECLARE @fillfactor INT

SET @fillfactor = 90
Begin

DECLARE DatabaseCursor CURSOR FOR  
SELECT      Name
FROM      master..sysdatabases
WHERE Name NOT IN ('Master', 'MSDB', 'Tempdb', 'Model)      
AND DATABASEPROPERTYEX(name,'status')='ONLINE'…

I would like to learn Exchange 2013 autodiscovery Funktion. Can you please help me to configure my Exchange Server that can use autodiscovery.

for that i installed Exchange Server 2013 .It works very good. i can send and receive mail and also i can Access OWA from external.(https://mail.mydomain.com/owa )



and also i created a subdomain:  autodiscovery.mydomain.com

i do not know how can i go head. where and how test it?

Thanks

Windows 10 machine, can't pull up a URL. Can go from a laptop in the same organization or any other computer but this desktop isn't working. The laptop that works is windows 7.

Website is https://rcm.emdeon.com/Portal?_ga=2.24648314.1352853988.1529636377-1009271983.1529636377  which alters URL wise to https://cda.changehealthcare.com

The windows 10 machine I am trying to get to the URL from can't go directly to the URL https://cda.changehealthcare.com

When I ping cda.changehealthcare.com from the machine I can't access it from I get the following IP: 170.138.16.152
When I ping cda.changehealthcare.com from my machine where I can get to the site, the IP is the same in the result of the ping.

I ran CCleaner
I ran temp file cleanup
The system is missing antivirus.

I loaded Webroot to run some scans
It found a malware infection gen.malware   server.exe

Cleaned  that. Going to run temp file clean up as well.
Will reboot and try again.

I checked IE settings to remove proxy server checkbox
Any other ideas?

I am working in Access 2010.  I have a main form with subform1 and subform2 (this is a continuous form) on subform1.  The problem is with the tab order of subform2.  There are only two fields  on the form.  They are phone, with an input mask, and phone type.  The tab order is correct and it should go to phone but the tab moves it from subform1 to the phone type field and completely bypasses the phone field.  The next tab takes you to the phone field.  This only happens on the first record.  Once the phone and type are filed in it advances to the second record's phone field first.

I set up forms like this a lot and have never seen it act this way.  Any ideas why this is happening?

When I run the script: Get-MailboxPermission 'Joe Bloggs' | Select User,AccessRights | ft -autosize
I get an output that included a lot of default users such as: Domain Admins, Enterprise Admins, Exchange Domain Servers, Exchange Services etc

How could the list produced be reduced to just normal users. Something like  Where-Object {$_.name  -NotLike "*Admin"} may work. How would the script look that removed the line containing *Admin* or remove -Like '*Exchange*'. There are also quite a few SIDs being displayed as will so any entry with 'S-1-5' needs to be removed.

The attached text file are the ones I need to go away in the output.

our network is comprised of 3 vlans and 1 lan. the main default lan is 191.168.0.1 - 191.168.1.255
our vlans are 192.168.10.1, 192.168.20.1 and 192.168.30.1. we have been having dns issues. i can do a search on our network for server name i get not found. if i search using ip address it is found. i can go into our dns server and some address show up and some do not. a weird thing is that if we use the dhcp server to hand out ips, some of our cell phones will not be able to connect to the signal. it can see the signal but can get an ip address. when we put our dhcp on our watchguard firewall the cell phones dont have an issue. we have been told we shouldnt be using the 191.168.0... as internal ip address, could confuse with the outside world. any ideas?

thank you

Using Access 2016:  I have a Query which groups agents by sales. Not every one will have data that month. I would like to email each individual agent his sales for that month. My questions are:
1. what's the best way to set this up, IE should I use a query, or a report based upon the query. I would need to create an agents table with email and name.
2. what are the steps involved?
3. what would be the code, we currently use go daddy for our email. We do not have a server in-house.
4, what event of the report or query would I use to add the code?
5. can you share code that works for 2016 access?

is this even possible? If the agent has no sales for that month, it should not create the email or should not create a report, if the report is based on a query?
If you can help, I would be gratefully appreciative, or if you can point me to a "dummies" link where I can try to create something.

The last question I had, I got some awesome answers from PatHartman and John . I am in hopes that one of the experts can help me with this as well as those two helped me with my query question. I know this is a lot to ask, but if you know, please help.